VIEW: APPS.MTH_SRC_ITEM_COST_V

Source

View Text - Preformatted

SELECT SYSTEM_FK, ITEM_FK, ITEM_COST, FROM_DATE, COST_ELEMENT, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, TO_DATE, INVENTORY_ITEM_ID, SOURCE_ORG_CODE, LAST_UPDATE_DATE FROM ( SELECT FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, CAST(NULL AS VARCHAR2(150)) ITEM_FK, CASE WHEN pivot_row_generator.id = 0 THEN c.material_cost WHEN pivot_row_generator.id = 1 THEN c.material_overhead_cost WHEN pivot_row_generator.id = 2 THEN c.resource_cost WHEN pivot_row_generator.id = 3 THEN c.outside_processing_cost WHEN pivot_row_generator.id = 4 THEN c.overhead_cost END ITEM_COST, c.LAST_UPDATE_DATE FROM_DATE, CASE WHEN pivot_row_generator.id = 0 THEN 'MATERIAL' WHEN pivot_row_generator.id = 1 THEN 'MATERIAL OVERHEAD' WHEN pivot_row_generator.id = 2 THEN 'RESOURCE' WHEN pivot_row_generator.id = 3 THEN 'OUTSIDE	PROCESSING' WHEN pivot_row_generator.id = 4 THEN 'OVERHEAD' END COST_ELEMENT, CAST(NULL AS VARCHAR2(150)) USER_ATTR1, CAST(NULL AS VARCHAR2(150)) USER_ATTR2, CAST(NULL AS VARCHAR2(150)) USER_ATTR3, CAST(NULL AS VARCHAR2(150)) USER_ATTR4, CAST(NULL AS VARCHAR2(150)) USER_ATTR5, CAST(NULL AS DATE) TO_DATE, c.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, mp.ORGANIZATION_CODE SOURCE_ORG_CODE, c.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM cst_item_costs c, mtl_parameters mp, ( SELECT level - 1 id FROM dual CONNECT BY level <= 5) pivot_row_generator WHERE c.ORGANIZATION_ID = mp.ORGANIZATION_ID AND mp.GENERAL_LEDGER_UPDATE_CODE IN (1,2) AND c.COST_TYPE_ID = mp.PRIMARY_COST_METHOD)

View Text - HTML Formatted

SELECT SYSTEM_FK
, ITEM_FK
, ITEM_COST
, FROM_DATE
, COST_ELEMENT
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, TO_DATE
, INVENTORY_ITEM_ID
, SOURCE_ORG_CODE
, LAST_UPDATE_DATE
FROM ( SELECT FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, CAST(NULL AS VARCHAR2(150)) ITEM_FK
, CASE WHEN PIVOT_ROW_GENERATOR.ID = 0 THEN C.MATERIAL_COST WHEN PIVOT_ROW_GENERATOR.ID = 1 THEN C.MATERIAL_OVERHEAD_COST WHEN PIVOT_ROW_GENERATOR.ID = 2 THEN C.RESOURCE_COST WHEN PIVOT_ROW_GENERATOR.ID = 3 THEN C.OUTSIDE_PROCESSING_COST WHEN PIVOT_ROW_GENERATOR.ID = 4 THEN C.OVERHEAD_COST END ITEM_COST
, C.LAST_UPDATE_DATE FROM_DATE
, CASE WHEN PIVOT_ROW_GENERATOR.ID = 0 THEN 'MATERIAL' WHEN PIVOT_ROW_GENERATOR.ID = 1 THEN 'MATERIAL OVERHEAD' WHEN PIVOT_ROW_GENERATOR.ID = 2 THEN 'RESOURCE' WHEN PIVOT_ROW_GENERATOR.ID = 3 THEN 'OUTSIDE PROCESSING' WHEN PIVOT_ROW_GENERATOR.ID = 4 THEN 'OVERHEAD' END COST_ELEMENT
, CAST(NULL AS VARCHAR2(150)) USER_ATTR1
, CAST(NULL AS VARCHAR2(150)) USER_ATTR2
, CAST(NULL AS VARCHAR2(150)) USER_ATTR3
, CAST(NULL AS VARCHAR2(150)) USER_ATTR4
, CAST(NULL AS VARCHAR2(150)) USER_ATTR5
, CAST(NULL AS DATE) TO_DATE
, C.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, C.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM CST_ITEM_COSTS C
, MTL_PARAMETERS MP
, ( SELECT LEVEL - 1 ID
FROM DUAL CONNECT BY LEVEL <= 5) PIVOT_ROW_GENERATOR
WHERE C.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.GENERAL_LEDGER_UPDATE_CODE IN (1
, 2)
AND C.COST_TYPE_ID = MP.PRIMARY_COST_METHOD)