Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT 'ALL'
, ASSAY.ASSAY_CLASS
, ASSAY.ASSAY_CODE
, ASSAY.ORGN_CODE||':'||ASSAY.ASSAY_CODE
, -- ASSAY_DP ASSAY.ORGN_CODE||'-'||ASSAY.ASSAY_CODE||'-'||INST.INSTANCE_CODE||'-'||'OPM'
, NULL
, -- ASSAY_PK_ROWID ASSAY.CREATION_DATE
, ASSAY.ASSAY_DESC
, -- DESCRIPTION INST.INSTANCE_CODE
, ASSAY.LAST_UPDATE_DATE
, ASSAY.ASSAY_CODE
, -- NAME ASSAY.ORGN_CODE
, NULL
, -- USER_ATTRIBUTE1 NULL
, -- USER_ATTRIBUTE2 NULL
, -- USER_ATTRIBUTE3 NULL
, -- USER_ATTRIBUTE4 NULL -- USER_ATTRIBUTE5
FROM QC_ASSY_TYP ASSAY
, EDW_LOCAL_INSTANCE INST