APPS.BOMPEXPL dependencies on MTL_SYSTEM_ITEMS

Line 292: MTL_SYSTEM_ITEMS_B SI,

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
296: AND BET.GROUP_ID = c_grp_id

Line 552: From mtl_system_items_b msi

548: trunc(rev_date);
549:
550: Cursor Calculate_Offset(P_ParentItem in number, P_Percent in number) is
551: Select P_Percent/100 * msi.full_lead_time offset
552: From mtl_system_items_b msi
553: Where msi.inventory_item_id = P_ParentItem
554: And msi.organization_id = Org_Id;
555:
556: No_Revision_Found exception;

Line 562: From mtl_system_items_b_kfv msi,

558:
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

Line 1243: From mtl_system_items msi,

1239: bl.conc_flex_string,
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

Line 1268: mtl_system_items msi,

1264: bom.common_bill_sequence_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

Line 1290: mtl_system_items msi,

1286: bom.common_bill_sequence_id,
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