APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_ITEM_COST_DETAILS

Line 831: delete from cst_item_cost_details cicd

827: from CST_ITEM_CST_DTLS_INTERFACE ct
828: WHERE ct.error_flag is null
829: AND ct.group_id = SEQ_NEXTVAL);
830:
831: delete from cst_item_cost_details cicd
832: WHERE (ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID) in
833: (Select ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID
834: from CST_ITEM_CST_DTLS_INTERFACE ct
835: WHERE ct.error_flag is null

Line 989: INSERT INTO CST_ITEM_COST_DETAILS(Inventory_item_id,

985: l_stmt_no := 40;
986:
987: /* Now insert into CICD */
988:
989: INSERT INTO CST_ITEM_COST_DETAILS(Inventory_item_id,
990: organization_id,
991: cost_type_id,
992: last_update_date,
993: last_updated_by,