APPS.BOMPBXIN dependencies on BOM_BILL_OF_MATERIALS

Line 246: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,

242: BIC.ATTRIBUTE12,
243: BIC.ATTRIBUTE13,
244: BIC.ATTRIBUTE14,
245: BIC.ATTRIBUTE15
246: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
247: MTL_SYSTEM_ITEMS SI,
248: BOM_INVENTORY_COMPONENTS BIC
249: WHERE BET.PLAN_LEVEL = c_level - 1
250: AND BET.GROUP_ID = c_grp_id

Line 289: FROM BOM_BILL_OF_MATERIALS BOM2

285: ( BET.TOP_ALTERNATE_DESIGNATOR IS NOT NULL
286: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
287: AND NOT EXISTS
288: (SELECT 'X'
289: FROM BOM_BILL_OF_MATERIALS BOM2
290: WHERE BOM2.ORGANIZATION_ID = c_org_id
291: AND BOM2.ASSEMBLY_ITEM_ID = BET.COMPONENT_ITEM_ID
292: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
293: BET.TOP_ALTERNATE_DESIGNATOR

Line 461: bom_bill_of_materials bom,

457: Cursor l_TopBill_csr is
458: Select msi.concatenated_segments,
459: bom.alternate_bom_designator
460: From mtl_system_items_kfv msi,
461: bom_bill_of_materials bom,
462: bom_small_expl_temp bet
463: Where msi.inventory_item_id = bom.assembly_item_id
464: And msi.organization_id = bom.organization_id
465: And bom.bill_sequence_id = bet.top_bill_sequence_id