APPS.MRP_AP_REL_PLAN_PUB dependencies on MTL_SYSTEM_ITEMS

Line 2923: from mtl_system_items msi,

2919: (Select nvl(mapv.material_account,
2920: decode( msi.inventory_asset_flag,
2921: 'Y', mp.material_account,
2922: nvl(msi.expense_account, mp.expense_account)))
2923: from mtl_system_items msi,
2924: mtl_parameters mp,
2925: /* Bug 3341083 Note: Any changes to from clause or where clause of MRP_AP_PROJECTS_V, needs a corresponding change to this inline view*/
2926: (SELECT ppp.Project_ID,
2927: ppp.Organization_ID,

Line 2981: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS

2977:
2978: End loop;
2979:
2980: -- fix for 2541517
2981: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS
2982: BEGIN
2983: SELECT pri.rowid,
2984: msi.SECONDARY_UOM_CODE,
2985: inv_convert.inv_um_convert(pri.ITEM_ID,9,pri.QUANTITY,pri.UOM_CODE,msi.SECONDARY_UOM_CODE,null,null)

Line 2991: MTL_SYSTEM_ITEMS msi

2987: INTO lv_pri_rowid,
2988: lv_sec_uom_code,
2989: lv_sec_uom_qty
2990: FROM PO_REQUISITIONS_INTERFACE_ALL pri,
2991: MTL_SYSTEM_ITEMS msi
2992: WHERE pri.ITEM_ID = msi.INVENTORY_ITEM_ID
2993: AND pri.DESTINATION_ORGANIZATION_ID = msi.ORGANIZATION_ID
2994: AND msi.SECONDARY_UOM_CODE is not NULL
2995: AND pri.batch_id = G_PO_BATCH_NUMBER;

Line 3021: FROM mtl_system_items_b msi,

3017: BEGIN
3018: SELECT max(rev.revision),
3019: max(msi.revision_qty_control_code)
3020: INTO var_revision,var_revision_ctrl
3021: FROM mtl_system_items_b msi,
3022: mtl_item_revisions rev
3023: WHERE msi.inventory_item_id = ctemp.item_id
3024: AND msi.organization_id = ctemp.destination_organization_id
3025: AND rev.inventory_item_id = msi.inventory_item_id