View: EDW_OPI_OPRN_OPRN_LCV

View Text

SELECT OPRN_ID||'-'||I.INSTANCE_CODE||'-OPM'
, DECODE(OPRN_CLASS
, NULL
, 'NA_EDW'
, OPRN_CLASS||'-'||I.INSTANCE_CODE||'-OPM')
, 'OPRN'
, OPRN_NO
, OPRN_NO
, OPRN_DESC
, NULL
, TO_NUMBER(NULL)
, PROCESS_QTY_UM
, NULL
, NULL
, NULL
, NULL
, NULL
, FO.LAST_UPDATE_DATE
, FO.CREATION_DATE
FROM FM_OPRN_MST FO
, EDW_LOCAL_INSTANCE I UNION SELECT BOS.OPERATION_SEQUENCE_ID || '-' || BOR.ORGANIZATION_ID || '-' || INST.INSTANCE_CODE || '-OPI' OPRN_PK
, 'NA_EDW' OPRC_FK
, 'OPRN' OPRN_DP
, BSO.OPERATION_CODE NAME
, BSO.OPERATION_CODE OPRN_NAME
, DECODE(BOS.STANDARD_OPERATION_ID
, NULL
, BOS.OPERATION_DESCRIPTION
, BSO.OPERATION_DESCRIPTION) DESCRIPTION
, MP.ORGANIZATION_CODE ORGN_CODE
, BOS.DEPARTMENT_ID
, NULL PROCESS_QTY_UOM
, TO_CHAR(NULL) USER_ATTRIBUTE1
, TO_CHAR(NULL) USER_ATTRIBUTE2
, TO_CHAR(NULL) USER_ATTRIBUTE3
, TO_CHAR(NULL) USER_ATTRIBUTE4
, TO_CHAR(NULL) USER_ATTRIBUTE5
, BOS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BOS.CREATION_DATE CREATION_DATE
FROM BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_STANDARD_OPERATIONS BSO
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
AND BOS.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND MP.ORGANIZATION_ID = BOR.ORGANIZATION_ID UNION SELECT 'NON-STANDARD-OPI' OPRN_PK
, 'NA_EDW' OPRC_FK
, 'NON-STANDARD' OPRN_DP
, 'NON-STANDARD' NAME
, 'NON-STANDARD' OPRN_NAME
, 'NON-STANDARD' DESCRIPTION
, NULL ORGN_CODE
, TO_NUMBER(NULL) DEPARTMENT
, NULL PROCESS_QTY_UOM
, TO_CHAR(NULL) USER_ATTRIBUTE1
, TO_CHAR(NULL) USER_ATTRIBUTE2
, TO_CHAR(NULL) USER_ATTRIBUTE3
, TO_CHAR(NULL) USER_ATTRIBUTE4
, TO_CHAR(NULL) USER_ATTRIBUTE5
, SYSDATE
, SYSDATE
FROM DUAL

Columns