[Home] [Help]
View: EDW_PMI_PGRD_PGRD_LCV
| Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT 'ALL' ALL_FK
, G.QC_GRADE || '-' || I.INSTANCE_CODE ||'-'||'OPM' GRADE_PK
, G.QC_GRADE GRADE
, G.QC_GRADE_DESC DESCRIPTION
, G.QC_GRADE GRADE_DP
, G.QC_GRADE NAME
, I.INSTANCE_CODE INSTANCE_CODE
, G.LAST_UPDATE_DATE
, G.CREATION_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM QC_GRAD_MST G
, EDW_LOCAL_INSTANCE I
Columns
| Name |
| ALL_FK |
| GRADE_PK |
| GRADE |
| DESCRIPTION |
| GRADE_DP |
| NAME |
| INSTANCE_CODE |
| LAST_UPDATE_DATE |
| CREATION_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |