APPS.BOMPBXIN dependencies on BOM_BILL_OF_MATERIALS

Line 242: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,

238: BIC.ATTRIBUTE12,
239: BIC.ATTRIBUTE13,
240: BIC.ATTRIBUTE14,
241: BIC.ATTRIBUTE15
242: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
243: MTL_SYSTEM_ITEMS SI,
244: BOM_INVENTORY_COMPONENTS BIC
245: WHERE BET.PLAN_LEVEL = c_level - 1
246: AND BET.GROUP_ID = c_grp_id

Line 285: FROM BOM_BILL_OF_MATERIALS BOM2

281: ( BET.TOP_ALTERNATE_DESIGNATOR IS NOT NULL
282: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
283: AND NOT EXISTS
284: (SELECT 'X'
285: FROM BOM_BILL_OF_MATERIALS BOM2
286: WHERE BOM2.ORGANIZATION_ID = c_org_id
287: AND BOM2.ASSEMBLY_ITEM_ID = BET.COMPONENT_ITEM_ID
288: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
289: BET.TOP_ALTERNATE_DESIGNATOR

Line 457: bom_bill_of_materials bom,

453: Cursor l_TopBill_csr is
454: Select msi.concatenated_segments,
455: bom.alternate_bom_designator
456: From mtl_system_items_kfv msi,
457: bom_bill_of_materials bom,
458: bom_small_expl_temp bet
459: Where msi.inventory_item_id = bom.assembly_item_id
460: And msi.organization_id = bom.organization_id
461: And bom.bill_sequence_id = bet.top_bill_sequence_id