APPS.ENG_VALIDATE_SUB_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 98: -- from bom_inventory_component and bom_bill_of_materials tables |

94: BEGIN
95: ------------------------------------------------------------------
96: -- Select Bill_Sequence_Id, Assembly_Type, Assembly_Item_Id, |
97: -- ACD_TYPE, Component_Item_Id and Implementation_Date |
98: -- from bom_inventory_component and bom_bill_of_materials tables |
99: ------------------------------------------------------------------
100:
101: SELECT bbom.bill_sequence_id ,
102: bbom.assembly_type,

Line 119: bom_bill_of_materials bbom

115: l_rec_ID,
116: l_parent_BIT
117: FROM mtl_system_items msi,
118: bom_inventory_components bic,
119: bom_bill_of_materials bbom
120: WHERE msi.inventory_item_id = bbom.assembly_item_id
121: AND msi.organization_id = bbom.organization_id
122: AND bic.component_sequence_id =
123: p_Sub_Comp_Unexp_Rec.component_sequence_id

Line 296: FROM bom_bill_of_materials bbom

292: --dbms_output.put_line('Verfying component for other common orgs . . . ');
293:
294: SELECT 1
295: INTO l_dummy
296: FROM bom_bill_of_materials bbom
297: WHERE rownum =1
298: AND bbom.common_bill_sequence_id = l_rec_BSI
299: AND bbom.organization_id <> bbom.common_organization_id
300: AND not exists