APPS.CSTPPINV dependencies on MTL_PAC_ACTUAL_COST_DETAILS

Line 402: mtl_pac_actual_cost_details MPACD

398: i_prog_id,
399: SYSDATE,
400: i_login_id
401: FROM mtl_material_transactions MMT,
402: mtl_pac_actual_cost_details MPACD
403: WHERE MMT.transaction_action_id = 1
404: AND MMT.transaction_source_type_id = 2
405: AND MMT.organization_id = i_txn_org_id
406: AND MMT.inventory_item_id = i_item_id

Line 2472: INSERT INTO mtl_pac_actual_cost_details (

2468:
2469: /* insert into mpacd */
2470: l_stmt_num := 40;
2471:
2472: INSERT INTO mtl_pac_actual_cost_details (
2473: transaction_id,
2474: pac_period_id,
2475: cost_type_id,
2476: cost_group_id,

Line 2527: FROM mtl_pac_actual_cost_details

2523: new_make_cost,
2524: insertion_flag,
2525: user_entered,
2526: sysdate
2527: FROM mtl_pac_actual_cost_details
2528: WHERE transaction_id = l_parent_transaction_id
2529: AND pac_period_id = i_pac_period_id
2530: AND cost_group_id = i_cost_group_id;
2531:

Line 2534: Delete from mtl_pac_actual_cost_details

2530: AND cost_group_id = i_cost_group_id;
2531:
2532: /* Delete the MPACD row of the parent */
2533:
2534: Delete from mtl_pac_actual_cost_details
2535: where transaction_id = l_parent_transaction_id
2536: AND pac_period_id = i_pac_period_id
2537: AND cost_group_id = i_cost_group_id;
2538:

Line 2604: INSERT INTO mtl_pac_actual_cost_details (

2600: mpacd */
2601:
2602: l_stmt_num := 70;
2603:
2604: INSERT INTO mtl_pac_actual_cost_details (
2605: transaction_id,
2606: pac_period_id,
2607: cost_type_id,
2608: cost_group_id,