APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_LOT_NUMBERS

Line 893: , mtl_lot_numbers lot';

889: , x.lot_number lot_number ';
890: l_lot_select2 := '
891: , lot.expiration_date lot_expiration_date';
892: l_lot_from := '
893: , mtl_lot_numbers lot';
894: l_lot_where := '
895: AND x.organization_id = lot.organization_id (+)
896: AND x.inventory_item_id = lot.inventory_item_id (+)
897: AND x.lot_number = lot.lot_number (+) ';

Line 2546: FROM mtl_lot_numbers mln

2542: CURSOR is_RSV_lot( org_id IN NUMBER
2543: , item_id IN NUMBER
2544: , lot IN VARCHAR2) IS
2545: SELECT NVL(mln.reservable_type, 1)
2546: FROM mtl_lot_numbers mln
2547: WHERE mln.inventory_item_id = item_id
2548: AND mln.organization_id = org_id
2549: AND mln.lot_number = lot;
2550:

Line 2557: FROM mtl_lot_numbers mln

2553: CURSOR is_RSV_lot( org_id IN NUMBER
2554: , item_id IN NUMBER
2555: , lot IN VARCHAR2) IS
2556: SELECT '1'
2557: FROM mtl_lot_numbers mln
2558: WHERE mln.status_id IN
2559: (SELECT mms.status_id
2560: FROM mtl_material_statuses mms
2561: WHERE NVL(mms.reservable_type, 1) = 1

Line 5872: , mtl_lot_numbers lot

5868: , x.transaction_action_id, x.transfer_subinventory_code
5869: , x.transfer_locator_id
5870: ) x
5871: , mtl_secondary_inventories sub
5872: , mtl_lot_numbers lot
5873: WHERE
5874: x.organization_id = sub.organization_id (+)
5875: AND x.subinventory_code = sub.secondary_inventory_name (+)
5876: AND x.organization_id = lot.organization_id (+)

Line 6208: , mtl_lot_numbers lot

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

Line 6528: , mtl_lot_numbers lot

6524: , x.transaction_action_id, x.transfer_subinventory_code
6525: , x.transfer_locator_id
6526: ) x
6527: , mtl_secondary_inventories sub
6528: , mtl_lot_numbers lot
6529: WHERE
6530: x.organization_id = sub.organization_id (+)
6531: AND x.subinventory_code = sub.secondary_inventory_name (+)
6532: AND x.organization_id = lot.organization_id (+)

Line 6863: , mtl_lot_numbers lot

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

Line 7604: , mtl_lot_numbers lot

7600: , x.transaction_action_id, x.transfer_subinventory_code
7601: , x.transfer_locator_id
7602: ) x
7603: , mtl_secondary_inventories sub
7604: , mtl_lot_numbers lot
7605: WHERE
7606: x.organization_id = sub.organization_id (+)
7607: AND x.subinventory_code = sub.secondary_inventory_name (+)
7608: AND x.organization_id = lot.organization_id (+)

Line 8024: , mtl_lot_numbers lot

8020: , x.transaction_action_id, x.transfer_subinventory_code
8021: , x.transfer_locator_id
8022: ) x
8023: , mtl_secondary_inventories sub
8024: , mtl_lot_numbers lot
8025: WHERE
8026: x.organization_id = sub.organization_id (+)
8027: AND x.subinventory_code = sub.secondary_inventory_name (+)
8028: AND x.organization_id = lot.organization_id (+)

Line 10758: FROM mtl_lot_numbers

10754: CURSOR Get_Grade_From_Lot( org_id IN NUMBER
10755: , item_id IN NUMBER
10756: , lot IN VARCHAR2) IS
10757: SELECT grade_code
10758: FROM mtl_lot_numbers
10759: WHERE organization_id = org_id
10760: AND inventory_item_id = item_id
10761: AND lot_number = lot;
10762: