DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on MTL_ITEM_FLEXFIELDS

Line 269: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM

265:
266: SELECT
267: substrb(MIF.ITEM_NUMBER || ' ' || BBM.ALTERNATE_BOM_DESIGNATOR,1,16)
268: INTO cur_msgstr
269: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM
270: WHERE MIF.ORGANIZATION_ID = BBM.ORGANIZATION_ID
271: AND MIF.ITEM_ID = BBM.ASSEMBLY_ITEM_ID
272: AND BBM.ASSEMBLY_ITEM_ID = cur_item_id
273: AND BBM.ORGANIZATION_ID = org_id