APPS.BOM_OE_EXPLODER_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 373: FROM bom_bill_of_materials

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

Line 537: FROM BOM_BILL_OF_MATERIALS BOM2

533: ( arg_alt_bom_desig IS NOT NULL
534: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
535: AND NOT EXISTS
536: (SELECT 'X'
537: FROM BOM_BILL_OF_MATERIALS BOM2
538: WHERE BOM2.ORGANIZATION_ID = arg_org_id
539: AND BOM2.ASSEMBLY_ITEM_ID = BE.COMPONENT_ITEM_ID
540: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
541: arg_alt_bom_desig

Line 595: FROM BOM_BILL_OF_MATERIALS BOM2

591: ( arg_alt_bom_desig IS NOT NULL
592: AND BBOM_C.ALTERNATE_BOM_DESIGNATOR IS NULL
593: AND NOT EXISTS
594: (SELECT 'X'
595: FROM BOM_BILL_OF_MATERIALS BOM2
596: WHERE BOM2.ORGANIZATION_ID = arg_org_id
597: AND BOM2.ASSEMBLY_ITEM_ID = BIC.COMPONENT_ITEM_ID
598: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
599: arg_alt_bom_desig

Line 1028: from bom_bill_of_materials

1024: */
1025: Begin
1026: select count(*)
1027: into bill_exists
1028: from bom_bill_of_materials
1029: where assembly_item_id = ob_component_item_id(i)
1030: and organization_id = OB_ORGANIZATION_ID(i);
1031:
1032: If bill_exists = 0 then