DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on MTL_SYSTEM_ITEMS

Line 247: MTL_SYSTEM_ITEMS SI,

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
251: AND BOM.ASSEMBLY_ITEM_ID = SI.INVENTORY_ITEM_ID

Line 450: From mtl_system_items msi

446: trunc(rev_date);
447:
448: Cursor Calculate_Offset(P_ParentItem in number, P_Percent in number) is
449: Select P_Percent/100 * msi.full_lead_time offset
450: From mtl_system_items msi
451: Where msi.inventory_item_id = P_ParentItem
452: And msi.organization_id = Org_Id;
453:
454: No_Revision_Found exception;

Line 460: From mtl_system_items_kfv msi,

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