APPS.OE_PURCHASE_RELEASE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 427: FROM MTL_SYSTEM_ITEMS

423:
424: -- Fix for the bug2097383 and 2201362
425: SELECT PURCHASING_ENABLED_FLAG
426: INTO item_purchase_enabled
427: FROM MTL_SYSTEM_ITEMS
428: WHERE INVENTORY_ITEM_ID = l_drop_ship_line_rec.inventory_item_id
429: AND ORGANIZATION_ID = l_drop_ship_line_rec.ship_from_org_id;
430:
431: IF l_debug_level > 0 THEN

Line 792: FROM mtl_system_items msi,inv_organization_info_v org

788: -- FTS on this table can be ignored.
789:
790: SELECT msi.stock_enabled_flag ,revision_qty_control_code
791: INTO l_stock_enabled_flag, l_revision_control_code
792: FROM mtl_system_items msi,inv_organization_info_v org
793: WHERE msi.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
794: AND org.organization_id = msi.organization_id
795: AND org.organization_id = p_drop_ship_line_rec.ship_from_org_id;
796:

Line 815: mtl_system_items mti

811: BEGIN
812: select MAX(revision)
813: into l_item_revision
814: from mtl_item_revisions mir,
815: mtl_system_items mti
816: where mir.inventory_item_id = mti.inventory_item_id
817: and mir.organization_id = mti.organization_id
818: and mti.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
819: and mti.organization_id = p_drop_ship_line_rec.ship_from_org_id

Line 1110: mtl_parameters mp, fnd_user fu, mtl_system_items msi,

1106: sl.source_type_code, decode(msi.inventory_asset_flag,
1107: 'Y', mp.material_account, nvl(msi.expense_account,
1108: mp.expense_account)), nvl(pla.location_id, -1)
1109: FROM po_location_associations pla, oe_order_lines_all sl,
1110: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1111: oe_order_headers sh
1112: WHERE sl.header_id = sh.header_id
1113: AND sl.line_id = p_line_id
1114: AND fu.user_id = sh.created_by