APPS.BOM_EXPLODER_PUB dependencies on BOM_BILL_OF_MATERIALS

Line 2628: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM

2624:
2625: SELECT
2626: substrb(MIF.ITEM_NUMBER || ' ' || BBM.ALTERNATE_BOM_DESIGNATOR,1,16)
2627: INTO cur_msgstr
2628: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM
2629: WHERE MIF.ORGANIZATION_ID = BBM.ORGANIZATION_ID
2630: AND MIF.ITEM_ID = BBM.ASSEMBLY_ITEM_ID
2631: AND BBM.ASSEMBLY_ITEM_ID = cur_item_id
2632: AND BBM.ORGANIZATION_ID = org_id

Line 2638: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1

2634: ((top_alt = 'none') AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL)
2635: OR
2636: ((top_alt <> 'none')
2637: AND (
2638: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1
2639: WHERE BBM1.ORGANIZATION_ID = org_id
2640: AND BBM1.ASSEMBLY_ITEM_ID = cur_item_id
2641: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
2642: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt

Line 2645: ( NOT EXISTS (SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM2

2641: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
2642: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt
2643: )
2644: OR
2645: ( NOT EXISTS (SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM2
2646: WHERE BBM2.ORGANIZATION_ID = org_id
2647: AND BBM2.ASSEMBLY_ITEM_ID = cur_item_id
2648: AND BBM2.ALTERNATE_BOM_DESIGNATOR = top_alt)
2649: AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL