Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT 'ALL' ALL_FK
, F.FORMULA_NO || '-' || F.FORMULA_VERS || '-' || I.INSTANCE_CODE ||'-'||'OPM' FORMULA_PK
, F.FORMULA_NO FORMULA_NUMBER
, F.FORMULA_VERS VERSION
, F.FORMULA_DESC1 DESCRIPTION
, F.FORMULA_CLASS FORMULA_CLASS
, F.FORMULA_NO || ':' || F.FORMULA_VERS FORMULA_DP
, F.FORMULA_NO || ':' || F.FORMULA_VERS NAME
, I.INSTANCE_CODE INSTANCE_CODE
, F.LAST_UPDATE_DATE
, F.CREATION_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM FM_FORM_MST F
, EDW_LOCAL_INSTANCE I