APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 708: FROM mtl_item_locations

704: print_debug('In check_is_reservable_loc, getting the cache value');
705: l_reservable_type := g_is_loc_reservable(l_hash_value).reservable_type;
706: ELSE
707: SELECT NVL(reservable_type,1) INTO l_reservable_type
708: FROM mtl_item_locations
709: WHERE organization_id = p_organization_id
710: AND inventory_location_id = p_inventory_location_id;
711: print_debug('In check_is_reservable_loc, Query fired');
712: g_is_loc_reservable(l_hash_value).reservable_type := l_reservable_type;

Line 1027: FROM mtl_item_locations mil

1023:
1024: CURSOR is_RSV_loct( org_id IN NUMBER
1025: , loct_id IN NUMBER) IS
1026: SELECT NVL(mil.reservable_type, 1)
1027: FROM mtl_item_locations mil
1028: WHERE mil.organization_id = org_id
1029: AND mil.inventory_location_id = loct_id;
1030:
1031:

Line 4770: , mtl_item_locations loc

4766: , x.transaction_action_id, x.transfer_subinventory_code
4767: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
4768: ) x
4769: , mtl_secondary_inventories sub
4770: , mtl_item_locations loc
4771: , mtl_parameters mp -- Onhand Material Status Support
4772: , mtl_material_statuses_b mms -- Onhand Material Status Support
4773: WHERE
4774: x.organization_id = loc.organization_id (+)

Line 6412: , mtl_item_locations loc

6408: , x.transaction_action_id, x.transfer_subinventory_code
6409: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6410: ) x
6411: , mtl_secondary_inventories sub
6412: , mtl_item_locations loc
6413: , mtl_lot_numbers lot
6414: , mtl_parameters mp -- Onhand Material Status Support
6415: , mtl_material_statuses_b mms -- Onhand Material Status Support
6416: WHERE

Line 7140: , mtl_item_locations loc

7136: , x.transaction_action_id, x.transfer_subinventory_code
7137: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
7138: ) x
7139: , mtl_secondary_inventories sub
7140: , mtl_item_locations loc
7141: , mtl_lot_numbers lot
7142: , mtl_parameters mp -- Onhand Material Status Support
7143: , mtl_material_statuses_b mms -- Onhand Material Status Support
7144: WHERE