287: BIC.ATTRIBUTE14,
288: BIC.ATTRIBUTE15,
289: BET.SORT_ORDER PARENT_SORT_ORDER,
290: BIC.AUTO_REQUEST_MATERIAL
291: FROM BOM_EXPLOSION_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
292: MTL_SYSTEM_ITEMS_B SI,
293: BOM_INVENTORY_COMPONENTS BIC,
294: ENG_REVISED_ITEMS ERI
295: WHERE BET.PLAN_LEVEL = c_level - 1
339: ( BET.TOP_ALTERNATE_DESIGNATOR IS NOT NULL
340: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
341: AND NOT EXISTS
342: (SELECT 'X'
343: FROM BOM_BILL_OF_MATERIALS BOM2
344: WHERE BOM2.ORGANIZATION_ID = c_org_id
345: AND BOM2.ASSEMBLY_ITEM_ID = BET.COMPONENT_ITEM_ID
346: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
347: BET.TOP_ALTERNATE_DESIGNATOR
559: Cursor l_TopBill_csr is
560: Select msi.concatenated_segments,
561: bom.alternate_bom_designator
562: From mtl_system_items_b_kfv msi,
563: bom_bill_of_materials bom,
564: BOM_EXPLOSION_TEMP bet
565: Where msi.inventory_item_id = bom.assembly_item_id
566: And msi.organization_id = bom.organization_id
567: And bom.bill_sequence_id = bet.top_bill_sequence_id
1240: bom.bill_sequence_id,
1241: bom.common_bill_sequence_id,
1242: msi.bom_item_type
1243: From mtl_system_items msi,
1244: Bom_Bill_Of_Materials bom,
1245: Bom_Lists bl
1246: Where bl.sequence_id = list_id
1247: And bom.assembly_item_id = bl.assembly_item_id
1248: And bom.organization_id = org_id
1265: bom.common_organization_id,
1266: msi.bom_item_type
1267: FROM
1268: mtl_system_items msi,
1269: Bom_Bill_Of_Materials bom,
1270: Bom_Lists bl
1271: WHERE
1272: bl.sequence_id = list_id And
1273: bom.assembly_item_id = bl.assembly_item_id And
1287: bom.common_organization_id,
1288: msi.bom_item_type
1289: FROM
1290: mtl_system_items msi,
1291: Bom_Bill_Of_Materials bom,
1292: Bom_Lists bl
1293: WHERE
1294: bl.sequence_id = list_id And
1295: bom.assembly_item_id = bl.assembly_item_id And
1305: bom.common_organization_id,
1306: msi.bom_item_type,
1307: msi.item_number
1308: From mtl_item_flexfields msi,
1309: bom_bill_of_materials bom
1310: Where bom.assembly_item_id = p_ItemId
1311: And bom.organization_id = P_OrgId
1312: And nvl(alternate_bom_designator, 'PRIMARY ALTERNATE') =
1313: nvl(p_alternate, 'PRIMARY ALTERNATE')
1863: 2
1864: FROM BOM_LISTS BL
1865: WHERE BL.SEQUENCE_ID = list_id
1866: AND BL.ALTERNATE_DESIGNATOR IS NULL
1867: AND NOT EXISTS (SELECT 'NO BILL' FROM BOM_BILL_OF_MATERIALS BOM
1868: WHERE BOM.ORGANIZATION_ID =
1869: nvl(BL.ORGANIZATION_ID, org_id)
1870: AND BOM.ASSEMBLY_ITEM_ID = BL.ASSEMBLY_ITEM_ID
1871: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL);