eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_LOT_NUMBERS

Line 776: FROM mtl_lot_numbers

772: print_debug('In check_is_reservable_lot, getting the cache value');
773: l_reservable_type := g_is_lot_reservable(l_hash_value).reservable_type;
774: ELSE
775: SELECT NVL(reservable_type,1) INTO l_reservable_type
776: FROM mtl_lot_numbers
777: WHERE inventory_item_id = p_inventory_item_id
778: AND organization_id = p_organization_id
779: AND lot_number = p_lot_number;
780: print_debug('In check_is_reservable_lot, Query fired');

Line 1036: FROM mtl_lot_numbers mln

1032: CURSOR is_RSV_lot( org_id IN NUMBER
1033: , item_id IN NUMBER
1034: , lot IN VARCHAR2) IS
1035: SELECT NVL(mln.reservable_type, 1)
1036: FROM mtl_lot_numbers mln
1037: WHERE mln.inventory_item_id = item_id
1038: AND mln.organization_id = org_id
1039: AND mln.lot_number = lot;
1040:

Line 5160: , mtl_lot_numbers lot

5156: , x.transaction_action_id, x.transfer_subinventory_code
5157: , x.transfer_locator_id
5158: ) x
5159: , mtl_secondary_inventories sub
5160: , mtl_lot_numbers lot
5161: WHERE
5162: x.organization_id = sub.organization_id (+)
5163: AND x.subinventory_code = sub.secondary_inventory_name (+)
5164: AND x.organization_id = lot.organization_id (+)

Line 5681: , mtl_lot_numbers lot

5677: , x.transaction_action_id, x.transfer_subinventory_code
5678: , x.transfer_locator_id
5679: ) x
5680: , mtl_secondary_inventories sub
5681: , mtl_lot_numbers lot
5682: WHERE
5683: x.organization_id = sub.organization_id (+)
5684: AND x.subinventory_code = sub.secondary_inventory_name (+)
5685: AND x.organization_id = lot.organization_id (+)

Line 6000: , mtl_lot_numbers lot

5996: , x.transaction_action_id, x.transfer_subinventory_code
5997: , x.transfer_locator_id
5998: ) x
5999: , mtl_secondary_inventories sub
6000: , mtl_lot_numbers lot
6001: WHERE
6002: x.organization_id = sub.organization_id (+)
6003: AND x.subinventory_code = sub.secondary_inventory_name (+)
6004: AND x.organization_id = lot.organization_id (+)

Line 6413: , mtl_lot_numbers lot

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
6417: x.inventory_item_id = lot.inventory_item_id (+)

Line 6769: , mtl_lot_numbers lot

6765: , x.transaction_action_id, x.transfer_subinventory_code
6766: , x.transfer_locator_id
6767: ) x
6768: , mtl_secondary_inventories sub
6769: , mtl_lot_numbers lot
6770: WHERE
6771: x.organization_id = sub.organization_id (+)
6772: AND x.subinventory_code = sub.secondary_inventory_name (+)
6773: AND x.organization_id = lot.organization_id (+)

Line 7141: , mtl_lot_numbers lot

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
7145: x.inventory_item_id = lot.inventory_item_id (+)

Line 7938: , mtl_lot_numbers lot

7934: , x.transaction_action_id, x.transfer_subinventory_code
7935: , x.transfer_locator_id
7936: ) x
7937: , mtl_secondary_inventories sub
7938: , mtl_lot_numbers lot
7939: WHERE
7940: x.organization_id = sub.organization_id (+)
7941: AND x.subinventory_code = sub.secondary_inventory_name (+)
7942: AND x.organization_id = lot.organization_id (+)

Line 8394: , mtl_lot_numbers lot

8390: , x.transaction_action_id, x.transfer_subinventory_code
8391: , x.transfer_locator_id
8392: ) x
8393: , mtl_secondary_inventories sub
8394: , mtl_lot_numbers lot
8395: WHERE
8396: x.organization_id = sub.organization_id (+)
8397: AND x.subinventory_code = sub.secondary_inventory_name (+)
8398: AND x.organization_id = lot.organization_id (+)

Line 11263: FROM mtl_lot_numbers

11259: CURSOR Get_Grade_From_Lot( org_id IN NUMBER
11260: , item_id IN NUMBER
11261: , lot IN VARCHAR2) IS
11262: SELECT grade_code
11263: FROM mtl_lot_numbers
11264: WHERE organization_id = org_id
11265: AND inventory_item_id = item_id
11266: AND lot_number = lot;
11267: