APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 2522: FROM mtl_item_locations mil

2518: /* DE-NORMALIZED MATERIAL STATUS */
2519: CURSOR is_RSV_loct( org_id IN NUMBER
2520: , loct_id IN NUMBER) IS
2521: SELECT NVL(mil.reservable_type, 1)
2522: FROM mtl_item_locations mil
2523: WHERE mil.organization_id = org_id
2524: AND mil.inventory_location_id = loct_id;
2525:
2526:

Line 2531: FROM mtl_item_locations mil

2527: /* NORMALIZED MATERIAL STATUS
2528: CURSOR is_RSV_loct( org_id IN NUMBER
2529: , loct_id IN NUMBER) IS
2530: SELECT '1'
2531: FROM mtl_item_locations mil
2532: WHERE mil.status_id IN
2533: (SELECT mms.status_id
2534: FROM mtl_material_statuses mms
2535: WHERE NVL(mms.reservable_type, 1) = 1

Line 5547: , mtl_item_locations loc -- invConv change

5543: , x.transaction_action_id, x.transfer_subinventory_code
5544: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
5545: ) x
5546: , mtl_secondary_inventories sub
5547: , mtl_item_locations loc -- invConv change
5548: , mtl_parameters mp -- Onhand Material Status Support
5549: , mtl_material_statuses_b mms -- Onhand Material Status Support
5550: WHERE
5551: x.organization_id = loc.organization_id (+) -- invConv change

Line 6207: , mtl_item_locations loc -- invConv change

6203: , x.transaction_action_id, x.transfer_subinventory_code
6204: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6205: ) x
6206: , mtl_secondary_inventories sub
6207: , mtl_item_locations loc -- invConv change
6208: , mtl_lot_numbers lot
6209: , mtl_parameters mp -- Onhand Material Status Support
6210: , mtl_material_statuses_b mms -- Onhand Material Status Support
6211: WHERE

Line 6862: , mtl_item_locations loc -- invConv change

6858: , x.transaction_action_id, x.transfer_subinventory_code
6859: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
6860: ) x
6861: , mtl_secondary_inventories sub
6862: , mtl_item_locations loc -- invConv change
6863: , mtl_lot_numbers lot
6864: , mtl_parameters mp -- Onhand Material Status Support
6865: , mtl_material_statuses_b mms -- Onhand Material Status Support
6866: WHERE