APPS.BOM_EXPLODER_PUB dependencies on BOM_BILL_OF_MATERIALS

Line 2541: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM

2537:
2538: SELECT
2539: substrb(MIF.ITEM_NUMBER || ' ' || BBM.ALTERNATE_BOM_DESIGNATOR,1,16)
2540: INTO cur_msgstr
2541: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM
2542: WHERE MIF.ORGANIZATION_ID = BBM.ORGANIZATION_ID
2543: AND MIF.ITEM_ID = BBM.ASSEMBLY_ITEM_ID
2544: AND BBM.ASSEMBLY_ITEM_ID = cur_item_id
2545: AND BBM.ORGANIZATION_ID = org_id

Line 2551: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1

2547: ((top_alt = 'none') AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL)
2548: OR
2549: ((top_alt <> 'none')
2550: AND (
2551: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1
2552: WHERE BBM1.ORGANIZATION_ID = org_id
2553: AND BBM1.ASSEMBLY_ITEM_ID = cur_item_id
2554: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
2555: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt

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

2554: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
2555: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt
2556: )
2557: OR
2558: ( NOT EXISTS (SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM2
2559: WHERE BBM2.ORGANIZATION_ID = org_id
2560: AND BBM2.ASSEMBLY_ITEM_ID = cur_item_id
2561: AND BBM2.ALTERNATE_BOM_DESIGNATOR = top_alt)
2562: AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL