APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 1993: FROM mtl_cst_actual_cost_details mcacd,

1989: p_inv_syslink_literal) system_linkage,
1990: 'P' transaction_status_code,
1991: mcacd.cost_element_id cost_element_id,
1992: p_denom_currency_code denom_currency_code
1993: FROM mtl_cst_actual_cost_details mcacd,
1994: mtl_material_transactions mmt
1995: WHERE mmt.transaction_id = p_transaction_id
1996: AND mmt.transaction_id = mcacd.transaction_id
1997: AND mcacd.organization_id = p_organization_id

Line 2136: FROM mtl_cst_actual_cost_details mcacd,

2132:
2133: 'P' transaction_status_code ,
2134: mcacd.cost_element_id cost_element_id,
2135: p_denom_currency_code denom_currency_code
2136: FROM mtl_cst_actual_cost_details mcacd,
2137: (Select SUM(actual_cost) actual_cost,
2138: transaction_id,
2139: organization_id,
2140: cost_element_id,

Line 2216: FROM mtl_cst_actual_cost_details mcacd,

2212:
2213: 'P' transaction_status_code ,
2214: mcacd.cost_element_id cost_element_id,
2215: p_denom_currency_code denom_currency_code
2216: FROM mtl_cst_actual_cost_details mcacd,
2217: (Select SUM(actual_cost) actual_cost,
2218: transaction_id,
2219: organization_id,
2220: cost_element_id,

Line 2324: FROM mtl_cst_actual_cost_details mcacd,

2320: mcacd.cost_element_id cost_element_id,
2321: decode(p_transaction_action_id,
2322: 3, l_xfer_currency_code,
2323: p_denom_currency_code) denom_currency_code
2324: FROM mtl_cst_actual_cost_details mcacd,
2325: cst_cost_elem_exp_types cceet,
2326: mtl_actual_cost_subelement macs
2327: WHERE mcacd.transaction_id = decode(p_transaction_action_id,
2328: 3, p_transfer_transaction_id ,

Line 2398: FROM mtl_cst_actual_cost_details mcacd,

2394:
2395: 'P' transaction_status_code,
2396: mcacd.cost_element_id cost_element_id,
2397: p_denom_currency_code denom_currency_code
2398: FROM mtl_cst_actual_cost_details mcacd,
2399: cst_cg_item_costs_view ccicv
2400: WHERE mcacd.transaction_id = p_transaction_id
2401: AND mcacd.organization_id = p_organization_id
2402: AND mcacd.inventory_item_id = p_inventory_item_id

Line 2473: FROM mtl_cst_actual_cost_details mcacd,

2469:
2470: 'P' transaction_status_code ,
2471: mcacd.cost_element_id cost_element_id,
2472: p_denom_currency_code denom_currency_code
2473: FROM mtl_cst_actual_cost_details mcacd,
2474: cst_cost_elem_exp_types cceet,
2475: cst_cg_item_costs_view ccicv
2476: WHERE mcacd.transaction_id = p_transaction_id
2477: AND mcacd.organization_id = p_organization_id