DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_COMPONENT_OPERATIONS

Line 211: SELECT 1 from BOM_COMPONENT_OPERATIONS BCO,

207:
208: CURSOR All_Numbers_BCO IS
209: SELECT 'X' unit_available FROM sys.dual
210: WHERE EXISTS (
211: SELECT 1 from BOM_COMPONENT_OPERATIONS BCO,
212: BOM_INVENTORY_COMPONENTS BIC
213: WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
214: AND BIC.Component_Item_Id = p_Component_Item_Id
215: AND BIC.Bill_Sequence_Id = p_Bill_Sequence_Id

Line 451: FROM BOM_COMPONENT_OPERATIONS

447: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM
448: and p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
449:
450: select count(*) into l_temp_var
451: FROM BOM_COMPONENT_OPERATIONS
452: WHERE OPERATION_SEQ_NUM = p_bom_comp_ops_rec.new_additional_op_seq_num
453: AND COMPONENT_SEQUENCE_ID = p_bom_Comp_ops_Unexp_Rec.component_sequence_id;
454:
455: IF (l_temp_var <>0) then