DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 3489: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,

3485: OVER (PARTITION BY MMT.transaction_id) outside_processing_cost,
3486: SUM(DECODE(mcacd.cost_element_id,5,nvl(mcacd.actual_cost,0),0))
3487: OVER (PARTITION BY MMT.transaction_id) overhead_cost,
3488: NVL(MCACD.creation_date,MMT.creation_date) txn_date
3489: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
3490: mtl_material_transactions mmt
3491: WHERE MCACD.ORGANIZATION_ID(+) = c_organization_id
3492: AND MCACD.inventory_item_id(+) = c_inventory_item_id
3493: AND MMT.transaction_date > c_valuation_date

Line 4509: mtl_cst_actual_cost_details MCACD

4505: ),
4506: 'N'
4507: )
4508: ) OWN_TXN,
4509: mtl_cst_actual_cost_details MCACD
4510: WHERE MCACD.transaction_id = DECODE(
4511: NVL(TFR_TXN.transaction_id,-1),
4512: -1,
4513: OWN_TXN.transaction_id,