APPS.CSTPPCIC dependencies on CST_ITEM_COSTS_INTERFACE

Line 530: -- to cst_item_costs_interface

526: --------------------------------------------------------------------------
527: -- Merge and update existing costs
528: -- Logic:
529: -- * Copy the based_on_rollup_flag for the p_to_cost_type_id items in CIC
530: -- to cst_item_costs_interface
531: -- * Delete the p_to_cost_type_id items in CIC, CICD, only if they also
532: -- have p_from_cost_type_id.
533: -- * Items get their p_to_cost_type_id costs from p_from_cost_type_id.
534: -- The based_on_rollup_flag is copied from CICI

Line 592: INSERT INTO cst_item_costs_interface

588:
589: SELECT CST_LISTS_S.NEXTVAL INTO l_grp_id
590: FROM dual;
591:
592: INSERT INTO cst_item_costs_interface
593: ( inventory_item_id
594: , cost_type_id
595: , based_on_rollup_flag
596: , group_id

Line 668: -- and removing backed up rollup flags from cst_item_costs_interface

664:
665: --------------------------------------------------------------------------
666: -- step 3> Inserting costs from CPIC
667: -- to the costs for p_to_org_id, p_to_cost_type_id, item in CIC
668: -- and removing backed up rollup flags from cst_item_costs_interface
669: --------------------------------------------------------------------------
670:
671:
672: l_stmt_num := 50;

Line 787: FROM cst_item_costs_interface

783: , SYSDATE
784: FROM cst_pac_item_costs CPIC,
785: mtl_system_items MSI,
786: (SELECT inventory_item_id, based_on_rollup_flag
787: FROM cst_item_costs_interface
788: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
789: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag
790: FROM cst_cost_types cct, cst_item_costs cic
791: WHERE cic.organization_id = p_to_org_id

Line 822: DELETE cst_item_costs_interface

818: ||' Rows Inserted into CIC');
819:
820: l_stmt_num := 55;
821:
822: DELETE cst_item_costs_interface
823: WHERE group_id = l_grp_id;
824:
825: l_row_count := 0;
826: l_row_count := SQL%ROWCOUNT;

Line 1227: -- to cst_item_costs_interface

1223: --------------------------------------------------------------------------
1224: --Remove and replace all cost information
1225: -- Logic:
1226: -- * Copy the based_on_rollup_flag for the p_to_cost_type_id items in CIC
1227: -- to cst_item_costs_interface
1228: -- * Delete the p_to_cost_type_id items in CIC, CICD.
1229: -- * Items get their p_to_cost_type_id costs from p_from_cost_type_id.
1230: -- The based_on_rollup_flag is copied from CICI for items that had rows
1231: --------------------------------------------------------------------------

Line 1278: INSERT INTO cst_item_costs_interface

1274:
1275: SELECT CST_LISTS_S.NEXTVAL INTO l_grp_id
1276: FROM dual;
1277:
1278: INSERT INTO cst_item_costs_interface
1279: ( inventory_item_id
1280: , cost_type_id
1281: , based_on_rollup_flag
1282: , group_id

Line 1349: -- and removing backed up rollup flags from cst_item_costs_interface

1345:
1346: --------------------------------------------------------------------------
1347: -- step 3> Inserting costs from CPIC
1348: -- to the costs for p_to_org_id, p_to_cost_type_id, item in CIC
1349: -- and removing backed up rollup flags from cst_item_costs_interface
1350: --------------------------------------------------------------------------
1351:
1352:
1353: l_stmt_num := 110;

Line 1468: FROM cst_item_costs_interface

1464: , SYSDATE
1465: FROM cst_pac_item_costs CPIC,
1466: mtl_system_items MSI,
1467: (SELECT inventory_item_id, based_on_rollup_flag
1468: FROM cst_item_costs_interface
1469: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
1470: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag
1471: FROM cst_cost_types cct, cst_item_costs cic
1472: WHERE cic.organization_id = p_to_org_id

Line 1503: DELETE cst_item_costs_interface

1499: ||' Rows Inserted into CIC');
1500:
1501: l_stmt_num := 115;
1502:
1503: DELETE cst_item_costs_interface
1504: WHERE group_id = l_grp_id;
1505:
1506: l_row_count := 0;
1507: l_row_count := SQL%ROWCOUNT;