DBA Data[Home] [Help]

APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_ITEM_COST_DETAILS

Line 836: delete from cst_item_cost_details cicd

832: from CST_ITEM_CST_DTLS_INTERFACE ct
833: WHERE ct.error_flag is null
834: AND ct.group_id = SEQ_NEXTVAL);
835:
836: delete from cst_item_cost_details cicd
837: WHERE (ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID) in
838: (Select ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID
839: from CST_ITEM_CST_DTLS_INTERFACE ct
840: WHERE ct.error_flag is null

Line 945: INSERT INTO CST_ITEM_COST_DETAILS(Inventory_item_id,

941: l_stmt_no := 40;
942:
943: /* Now insert into CICD */
944:
945: INSERT INTO CST_ITEM_COST_DETAILS(Inventory_item_id,
946: organization_id,
947: cost_type_id,
948: last_update_date,
949: last_updated_by,