DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 392: FROM MTL_SYSTEM_ITEMS

388:
389: -- Fix for the bug2097383 and 2201362
390: SELECT PURCHASING_ENABLED_FLAG
391: INTO item_purchase_enabled
392: FROM MTL_SYSTEM_ITEMS
393: WHERE INVENTORY_ITEM_ID = l_drop_ship_line_rec.inventory_item_id
394: AND ORGANIZATION_ID = l_drop_ship_line_rec.ship_from_org_id;
395:
396: IF l_debug_level > 0 THEN

Line 757: FROM mtl_system_items msi,inv_organization_info_v org

753: -- FTS on this table can be ignored.
754:
755: SELECT msi.stock_enabled_flag ,revision_qty_control_code
756: INTO l_stock_enabled_flag, l_revision_control_code
757: FROM mtl_system_items msi,inv_organization_info_v org
758: WHERE msi.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
759: AND org.organization_id = msi.organization_id
760: AND org.organization_id = p_drop_ship_line_rec.ship_from_org_id;
761:

Line 780: mtl_system_items mti

776: BEGIN
777: select MAX(revision)
778: into l_item_revision
779: from mtl_item_revisions mir,
780: mtl_system_items mti
781: where mir.inventory_item_id = mti.inventory_item_id
782: and mir.organization_id = mti.organization_id
783: and mti.inventory_item_id = p_drop_ship_line_rec.inventory_item_id
784: and mti.organization_id = p_drop_ship_line_rec.ship_from_org_id

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

1071: sl.source_type_code, decode(msi.inventory_asset_flag,
1072: 'Y', mp.material_account, nvl(msi.expense_account,
1073: mp.expense_account)), nvl(pla.location_id, -1)
1074: FROM po_location_associations pla, oe_order_lines_all sl,
1075: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1076: oe_order_headers sh
1077: WHERE sl.header_id = sh.header_id
1078: AND sl.line_id = p_line_id
1079: AND fu.user_id = sh.created_by