VIEW: APPS.MRP_WORKBENCH_QUERY_DFV

Source

View Text - Preformatted

SELECT ROWID, ATTRIBUTE_CATEGORY, STATUS_CODE, WIP_CLASS_CODE, DISPOSITION, (DECODE (ATTRIBUTE_CATEGORY, '2', DEMAND_CLASS, '1', DEMAND_CLASS, NULL)), (DECODE (ATTRIBUTE_CATEGORY, '8', QUANTITY_IN_PROCESS, '1', QUANTITY_IN_PROCESS, NULL)), (DECODE (ATTRIBUTE_CATEGORY, '8', LOCATION_ID, '16', LOCATION_ID, NULL)), LINE_ID, STATUS_CODE, (DECODE (ATTRIBUTE_CATEGORY, '1', ATTRIBUTE_CATEGORY || '.' || STATUS_CODE || '.' || WIP_CLASS_CODE || '.' || DISPOSITION || '.' || DEMAND_CLASS || '.' || QUANTITY_IN_PROCESS, '16', ATTRIBUTE_CATEGORY || '.' || LOCATION_ID, '2', ATTRIBUTE_CATEGORY || '.' || DEMAND_CLASS || '.' || LINE_ID, '4', ATTRIBUTE_CATEGORY || '.' || STATUS_CODE, '8', ATTRIBUTE_CATEGORY || '.' || LOCATION_ID || '.' || QUANTITY_IN_PROCESS, NULL)) FROM MRP_WORKBENCH_QUERY

View Text - HTML Formatted

SELECT ROWID
, ATTRIBUTE_CATEGORY
, STATUS_CODE
, WIP_CLASS_CODE
, DISPOSITION
, (DECODE (ATTRIBUTE_CATEGORY
, '2'
, DEMAND_CLASS
, '1'
, DEMAND_CLASS
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, '8'
, QUANTITY_IN_PROCESS
, '1'
, QUANTITY_IN_PROCESS
, NULL))
, (DECODE (ATTRIBUTE_CATEGORY
, '8'
, LOCATION_ID
, '16'
, LOCATION_ID
, NULL))
, LINE_ID
, STATUS_CODE
, (DECODE (ATTRIBUTE_CATEGORY
, '1'
, ATTRIBUTE_CATEGORY || '.' || STATUS_CODE || '.' || WIP_CLASS_CODE || '.' || DISPOSITION || '.' || DEMAND_CLASS || '.' || QUANTITY_IN_PROCESS
, '16'
, ATTRIBUTE_CATEGORY || '.' || LOCATION_ID
, '2'
, ATTRIBUTE_CATEGORY || '.' || DEMAND_CLASS || '.' || LINE_ID
, '4'
, ATTRIBUTE_CATEGORY || '.' || STATUS_CODE
, '8'
, ATTRIBUTE_CATEGORY || '.' || LOCATION_ID || '.' || QUANTITY_IN_PROCESS
, NULL))
FROM MRP_WORKBENCH_QUERY