APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_ITEM_COSTS

Line 651: and NOT EXISTS (select 1 from cst_item_costs cic where

647: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEFCSTTYPE'),1,240)
648: where
649: ct.error_flag is null
650: and ct.group_id = SEQ_NEXTVAL
651: and NOT EXISTS (select 1 from cst_item_costs cic where
652: ct.organization_id = cic.organization_id
653: and cic.cost_type_id = l_def_cost_type_id
654: and ct.inventory_item_id = cic.inventory_item_id)
655: AND (ct.lot_size is null OR ct.based_on_rollup_flag is null OR shrinkage_rate is null OR inventory_asset_flag is null) ;

Line 682: FROM CST_ITEM_COSTS cic

678: (Select NVL(ct.lot_size,cic.lot_size),
679: NVL(ct.based_on_rollup_flag,cic.based_on_rollup_flag),
680: NVL(ct.shrinkage_rate,cic.shrinkage_rate),
681: NVL(ct.inventory_asset_flag,cic.inventory_asset_flag)
682: FROM CST_ITEM_COSTS cic
683: WHERE cic.organization_id = ct.organization_id
684: AND cic.cost_type_id = l_def_cost_type_id
685: AND cic.inventory_item_id = ct.inventory_item_id )
686: WHERE ct.error_flag is null

Line 824: /* Now insert first into cst_item_costs */

820:
821:
822: fnd_file.put_line(fnd_file.log,'done calculating the item cost and basis factor for total value basis type');
823: l_stmt_no := 30;
824: /* Now insert first into cst_item_costs */
825:
826: /* here we check for the run option.If it is insert only mode, we error out those rows for which rows already exist in CIC for the same item,org,cost type combo.For rem and replace mode, we just delete off all the existing rows and proceed */
827:
828: IF i_run_option = 2 then

Line 829: delete from cst_item_costs cic

825:
826: /* here we check for the run option.If it is insert only mode, we error out those rows for which rows already exist in CIC for the same item,org,cost type combo.For rem and replace mode, we just delete off all the existing rows and proceed */
827:
828: IF i_run_option = 2 then
829: delete from cst_item_costs cic
830: WHERE (ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID) in
831: (Select ORGANIZATION_ID,INVENTORY_ITEM_ID,COST_TYPE_ID
832: from CST_ITEM_CST_DTLS_INTERFACE ct
833: WHERE ct.error_flag is null

Line 852: AND EXISTS(Select 1 from cst_item_costs cic

848: ct.error_code = 'CST_CANT_INSERT',
849: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
850: WHERE ct.error_flag is null
851: AND ct.group_id = SEQ_NEXTVAL
852: AND EXISTS(Select 1 from cst_item_costs cic
853: WHERE ct.organization_id = cic.organization_id
854: AND ct.cost_type_id = cic.cost_type_id
855: AND ct.inventory_item_id = cic.inventory_item_id);
856: END IF;

Line 862: Insert into CST_ITEM_COSTS (Inventory_item_id,

858: fnd_file.put_line(fnd_file.log,'done checking for the run option and deleting or erroring out rows accordingly');
859:
860: l_stmt_no := 35;
861:
862: Insert into CST_ITEM_COSTS (Inventory_item_id,
863: organization_id,
864: cost_type_id,
865: Last_update_date,
866: last_updated_by,