OE.PRODUCTS (view) - Revision history

Bot at 09:35, 27 August 2011

2011-08-27T09:35:19Z

2010-06-24T05:15:51Z

2010-02-11T07:28:37Z

2009-08-24T19:10:31Z

2009-08-24T19:02:52Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | OE.PRODUCTS |- |}

2009-05-02T17:07:24Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | OE.PRODUCTS |- |} <pre> </pre>

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''view
| OE.PRODUCTS
|-
|}

<pre>

</pre>

← Older revision		Revision as of 09:35, 27 August 2011
Line 33:		Line 33:
	AND d.language_id (+) = sys_context('USERENV','LANG')		AND d.language_id (+) = sys_context('USERENV','LANG')
	</pre>		</pre>
−
−	~~=== References ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Dependency Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referenced Object~~
−
−	~~\|- valign="top"~~
−	~~\| Select~~
−	~~\| Table~~
−	~~\| [[OE.PRODUCT_INFORMATION_(table)\|OE.PRODUCT_INFORMATION]]~~
−
−	\|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''View
 | OE.PRODUCTS
 |}
 === Source ===
@@ Line 43: / Line 41: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''view
+| '''View
 | OE.PRODUCTS
 |-
@@ Line 9: / Line 9: @@
 <pre>
 CREATE OR REPLACE VIEW OE.PRODUCTS AS
@@ Line 34: / Line 35: @@
 AND    d.language_id (+) = sys_context('USERENV','LANG')
 </pre>

@@ Line 10: / Line 10: @@
 <pre>
-CREATE OR REPLACE SELECT i.product_id
+CREATE OR REPLACE VIEW OE.PRODUCTS AS
 ,      d.language_id
 ,      CASE WHEN d.language_id IS NOT NULL

@@ Line 7: / Line 7: @@
 |-
 |}
 <pre>
+CREATE OR REPLACE SELECT i.product_id
 </pre>