[Home] [Help]
View: EDW_GEOG_AREA2_LCV
| Product: | PO - Purchasing |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT 'ALL' || '-' || 'ARE2' AREA2_PK
, 'ALL' || '-' || 'ARE1' AREA1_FK
, 'ALL AREA2' AREA2_DP
, 'ALL AREA2' NAME
, ELI.INSTANCE_CODE INSTANCE
, NVL(ELI.CREATION_DATE
, SYSDATE) CREATION_DATE
, NULL LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM EDW_LOCAL_INSTANCE ELI
Columns
| Name |
| AREA2_PK |
| AREA1_FK |
| AREA2_DP |
| NAME |
| INSTANCE |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |