DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on MTL_SYSTEM_ITEMS

Line 243: MTL_SYSTEM_ITEMS SI,

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

Line 446: From mtl_system_items msi

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

Line 456: From mtl_system_items_kfv msi,

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