VIEW: APPS.CSTBV_PAC_ITEM_COST_DETAILS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ cpicd.COST_LAYER_ID /*PK*/ ,cpicd.COST_ELEMENT_ID /*PK*/ ,cpicd.LEVEL_TYPE /*PK*/ ,cpic.PAC_PERIOD_ID ,cpic.COST_GROUP_ID ,cpic.INVENTORY_ITEM_ID ,cpicd.ITEM_COST ,cpicd.ITEM_BUY_COST ,cpicd.ITEM_MAKE_COST /* FOREIGN KEYS RESOLVED */ ,cce.cost_element , '_LA:cpicd.level_type:MFG_LOOKUPS:CST_LEVEL:MEANING' ,cpp.period_name ,ccg.cost_group , '_KF:INV:MSTK:sy' /* ID */ /* WHO */ ,cpic.creation_date ,cpic.created_by ,cpic.last_update_date ,cpic.last_updated_by from cst_cost_elements cce, mtl_system_items sy, CST_PAC_PERIODS cpp, CST_COST_GROUPS ccg, CST_PAC_ITEM_COSTS cpic, CST_PAC_ITEM_COST_DETAILS cpicd WHERE cpic.PAC_PERIOD_ID = cpp.PAC_PERIOD_ID and cpicd.COST_LAYER_ID = cpic.COST_LAYER_ID and cpicd.COST_ELEMENT_ID = cce.COST_ELEMENT_ID and cpic.cost_group_id = ccg.cost_group_id and sy.organization_id = ccg.organization_id and ccg.cost_group_type = 2 and sy.inventory_item_id = cpic.inventory_item_id and '_SEC:ccg.organization_id' IS NOT NULL with read only

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ CPICD.COST_LAYER_ID /*PK*/
, CPICD.COST_ELEMENT_ID /*PK*/
, CPICD.LEVEL_TYPE /*PK*/
, CPIC.PAC_PERIOD_ID
, CPIC.COST_GROUP_ID
, CPIC.INVENTORY_ITEM_ID
, CPICD.ITEM_COST
, CPICD.ITEM_BUY_COST
, CPICD.ITEM_MAKE_COST /* FOREIGN KEYS RESOLVED */
, CCE.COST_ELEMENT
, '_LA:CPICD.LEVEL_TYPE:MFG_LOOKUPS:CST_LEVEL:MEANING'
, CPP.PERIOD_NAME
, CCG.COST_GROUP
, '_KF:INV:MSTK:SY' /* ID */ /* WHO */
, CPIC.CREATION_DATE
, CPIC.CREATED_BY
, CPIC.LAST_UPDATE_DATE
, CPIC.LAST_UPDATED_BY
FROM CST_COST_ELEMENTS CCE
, MTL_SYSTEM_ITEMS SY
, CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_PAC_ITEM_COSTS CPIC
, CST_PAC_ITEM_COST_DETAILS CPICD
WHERE CPIC.PAC_PERIOD_ID = CPP.PAC_PERIOD_ID
AND CPICD.COST_LAYER_ID = CPIC.COST_LAYER_ID
AND CPICD.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID
AND CPIC.COST_GROUP_ID = CCG.COST_GROUP_ID
AND SY.ORGANIZATION_ID = CCG.ORGANIZATION_ID
AND CCG.COST_GROUP_TYPE = 2
AND SY.INVENTORY_ITEM_ID = CPIC.INVENTORY_ITEM_ID
AND '_SEC:CCG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY