APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 2054: FROM mtl_cst_actual_cost_details mcacd,

2050: p_inv_syslink_literal) system_linkage,
2051: 'P' transaction_status_code,
2052: mcacd.cost_element_id cost_element_id,
2053: p_denom_currency_code denom_currency_code
2054: FROM mtl_cst_actual_cost_details mcacd,
2055: mtl_material_transactions mmt
2056: WHERE mmt.transaction_id = p_transaction_id
2057: AND mmt.transaction_id = mcacd.transaction_id
2058: AND mcacd.organization_id = p_organization_id

Line 2197: FROM mtl_cst_actual_cost_details mcacd,

2193:
2194: 'P' transaction_status_code ,
2195: mcacd.cost_element_id cost_element_id,
2196: p_denom_currency_code denom_currency_code
2197: FROM mtl_cst_actual_cost_details mcacd,
2198: (Select SUM(actual_cost) actual_cost,
2199: transaction_id,
2200: organization_id,
2201: cost_element_id,

Line 2277: FROM mtl_cst_actual_cost_details mcacd,

2273:
2274: 'P' transaction_status_code ,
2275: mcacd.cost_element_id cost_element_id,
2276: p_denom_currency_code denom_currency_code
2277: FROM mtl_cst_actual_cost_details mcacd,
2278: (Select SUM(actual_cost) actual_cost,
2279: transaction_id,
2280: organization_id,
2281: cost_element_id,

Line 2385: FROM mtl_cst_actual_cost_details mcacd,

2381: mcacd.cost_element_id cost_element_id,
2382: decode(p_transaction_action_id,
2383: 3, l_xfer_currency_code,
2384: p_denom_currency_code) denom_currency_code
2385: FROM mtl_cst_actual_cost_details mcacd,
2386: cst_cost_elem_exp_types cceet,
2387: mtl_actual_cost_subelement macs
2388: WHERE mcacd.transaction_id = decode(p_transaction_action_id,
2389: 3, p_transfer_transaction_id ,

Line 2459: FROM mtl_cst_actual_cost_details mcacd,

2455:
2456: 'P' transaction_status_code,
2457: mcacd.cost_element_id cost_element_id,
2458: p_denom_currency_code denom_currency_code
2459: FROM mtl_cst_actual_cost_details mcacd,
2460: cst_cg_item_costs_view ccicv
2461: WHERE mcacd.transaction_id = p_transaction_id
2462: AND mcacd.organization_id = p_organization_id
2463: AND mcacd.inventory_item_id = p_inventory_item_id

Line 2534: FROM mtl_cst_actual_cost_details mcacd,

2530:
2531: 'P' transaction_status_code ,
2532: mcacd.cost_element_id cost_element_id,
2533: p_denom_currency_code denom_currency_code
2534: FROM mtl_cst_actual_cost_details mcacd,
2535: cst_cost_elem_exp_types cceet,
2536: cst_cg_item_costs_view ccicv
2537: WHERE mcacd.transaction_id = p_transaction_id
2538: AND mcacd.organization_id = p_organization_id