APPS.BOM_OE_EXPLODER_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 376: FROM bom_bill_of_materials

372: CURSOR get_bill_id IS
373: SELECT bill_sequence_id,
374: common_bill_sequence_id,
375: source_bill_sequence_id
376: FROM bom_bill_of_materials
377: WHERE assembly_item_id = arg_item_id
378: AND organization_id = arg_org_id
379: AND NVL(alternate_bom_designator,'NONE') = NVL(arg_alt_bom_desig,'NONE');
380:

Line 541: FROM BOM_BILL_OF_MATERIALS BOM2

537: ( arg_alt_bom_desig IS NOT NULL
538: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
539: AND NOT EXISTS
540: (SELECT 'X'
541: FROM BOM_BILL_OF_MATERIALS BOM2
542: WHERE BOM2.ORGANIZATION_ID = arg_org_id
543: AND BOM2.ASSEMBLY_ITEM_ID = BE.COMPONENT_ITEM_ID
544: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
545: arg_alt_bom_desig

Line 599: FROM BOM_BILL_OF_MATERIALS BOM2

595: ( arg_alt_bom_desig IS NOT NULL
596: AND BBOM_C.ALTERNATE_BOM_DESIGNATOR IS NULL
597: AND NOT EXISTS
598: (SELECT 'X'
599: FROM BOM_BILL_OF_MATERIALS BOM2
600: WHERE BOM2.ORGANIZATION_ID = arg_org_id
601: AND BOM2.ASSEMBLY_ITEM_ID = BIC.COMPONENT_ITEM_ID
602: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
603: arg_alt_bom_desig

Line 1097: from bom_bill_of_materials

1093: */
1094: Begin
1095: select count(*)
1096: into bill_exists
1097: from bom_bill_of_materials
1098: where assembly_item_id = ob_component_item_id(i)
1099: and organization_id = OB_ORGANIZATION_ID(i);
1100:
1101: If bill_exists = 0 then