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_LOT_TRX_VALIDATION_PUB dependencies on MTL_LOT_NUMBERS

Line 709: FROM mtl_system_items_b msik, mtl_lot_numbers mln

705:
706: BEGIN
707: SELECT msik.lot_split_enabled
708: INTO l_validation_status
709: FROM mtl_system_items_b msik, mtl_lot_numbers mln
710: WHERE mln.organization_id = p_organization_id
711: AND mln.inventory_item_id = p_inventory_item_id
712: AND mln.lot_number = p_lot_number
713: AND mln.organization_id = msik.organization_id

Line 758: FROM mtl_system_items_b msik, mtl_lot_numbers mln

754:
755: BEGIN
756: SELECT msik.lot_merge_enabled
757: INTO l_validation_status
758: FROM mtl_system_items_b msik, mtl_lot_numbers mln
759: WHERE mln.organization_id = p_organization_id
760: AND mln.inventory_item_id = p_inventory_item_id
761: AND mln.lot_number = p_lot_number
762: AND mln.organization_id = msik.organization_id

Line 808: FROM mtl_system_items_b msik, mtl_lot_numbers mln

804:
805: BEGIN
806: SELECT DECODE (msik.lot_control_code, 2, 'Y', 'N')
807: INTO l_validation_status
808: FROM mtl_system_items_b msik, mtl_lot_numbers mln
809: WHERE mln.organization_id = p_organization_id
810: AND mln.inventory_item_id = p_inventory_item_id
811: AND mln.lot_number = p_lot_number
812: AND mln.organization_id = msik.organization_id

Line 1047: FROM mtl_lot_numbers

1043: FOR i IN 1 .. p_rs_lot_num_tbl.COUNT
1044: LOOP
1045: SELECT COUNT (1)
1046: INTO l_lot_count
1047: FROM mtl_lot_numbers
1048: WHERE inventory_item_id <> p_inventory_item_id
1049: AND organization_id = p_organization_id
1050: AND lot_number = p_rs_lot_num_tbl (i);
1051:

Line 1110: FROM mtl_lot_numbers

1106: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_merge)
1107: THEN
1108: SELECT COUNT (1)
1109: INTO l_lot_count
1110: FROM mtl_lot_numbers
1111: WHERE inventory_item_id <> p_inventory_item_id
1112: AND organization_id = p_organization_id
1113: AND lot_number = p_rs_lot_num_tbl (1);
1114:

Line 1156: FROM mtl_lot_numbers

1152: FOR i IN 1 .. p_rs_lot_num_tbl.COUNT
1153: LOOP
1154: SELECT COUNT (1)
1155: INTO l_lot_count
1156: FROM mtl_lot_numbers
1157: WHERE inventory_item_id = p_inventory_item_id
1158: AND organization_id = p_organization_id
1159: AND lot_number = p_rs_lot_num_tbl (i);
1160:

Line 1290: FROM mtl_lot_numbers

1286: END IF;
1287:
1288: SELECT count(1)
1289: INTO l_lot_count
1290: FROM mtl_lot_numbers
1291: WHERE inventory_item_id = p_inventory_item_id
1292: AND organization_id = p_organization_id
1293: AND lot_number = p_rs_lot_num_tbl(1);
1294:

Line 1297: print_debug('after validating against mtl_lot_numbers', 'validate_result_lot');

1293: AND lot_number = p_rs_lot_num_tbl(1);
1294:
1295: if( l_lot_count = 0 ) then
1296: IF (l_debug = 1) THEN
1297: print_debug('after validating against mtl_lot_numbers', 'validate_result_lot');
1298: END IF;
1299: SELECT count(1)
1300: INTO l_lot_count
1301: FROM WIP_ENTITIES

Line 1642: * retrieve the status from mtl_lot_numbers for the lot number into l_status_id *

1638: * return missing required parameter error *
1639: * end if; *
1640: * *
1641: * if( p_status_id is null ) then *
1642: * retrieve the status from mtl_lot_numbers for the lot number into l_status_id *
1643: * If not found then *
1644: * Return invalid lot number error *
1645: * End if; *
1646: * Else *

Line 1743: FROM mtl_lot_numbers

1739: THEN
1740: BEGIN
1741: SELECT status_id
1742: INTO l_status_id
1743: FROM mtl_lot_numbers
1744: WHERE organization_id = p_organization_id
1745: AND inventory_item_id = p_inventory_item_id
1746: AND lot_number = p_lot_number;
1747: EXCEPTION

Line 2484: , p_table_name => 'MTL_LOT_NUMBERS'

2480: , x_attributes_default_count => l_attributes_default_count
2481: , x_return_status => l_return_status
2482: , x_msg_count => l_msg_count
2483: , x_msg_data => x_msg_data
2484: , p_table_name => 'MTL_LOT_NUMBERS'
2485: , p_attributes_name => 'Lot Attributes'
2486: , p_inventory_item_id => p_inventory_item_id
2487: , p_organization_id => p_organization_id
2488: , p_lot_serial_number => p_lot_number

Line 5052: FROM mtl_lot_numbers

5048: THEN
5049: BEGIN
5050: SELECT fnd_date.date_to_canonical (expiration_date)
5051: INTO l_lotexpdate
5052: FROM mtl_lot_numbers
5053: WHERE inventory_item_id = p_item_id
5054: AND organization_id = p_organization_id
5055: AND lot_number = p_st_lot_num;
5056: EXCEPTION

Line 5119: FROM mtl_lot_numbers

5115: -- expiration DATE of that lot from the table. pass both in this case.
5116: BEGIN
5117: SELECT fnd_date.date_to_canonical (expiration_date)
5118: INTO l_lotexpdate
5119: FROM mtl_lot_numbers
5120: WHERE inventory_item_id = p_item_id
5121: AND organization_id = p_organization_id
5122: AND lot_number = p_rs_lot_num_tbl (1);
5123: EXCEPTION

Line 5129: FROM mtl_lot_numbers

5125: THEN -- then get the exp date of the lot
5126: --either WITH the highet qty OR the rep. lot
5127: SELECT fnd_date.date_to_canonical (expiration_date)
5128: INTO l_lotexpdate
5129: FROM mtl_lot_numbers
5130: WHERE inventory_item_id = p_item_id
5131: AND organization_id = p_organization_id
5132: AND lot_number = p_st_lot_num; -- We only pass one
5133: -- lot here based on the highest qty or the rep. lot.

Line 5182: FROM mtl_lot_numbers

5178: THEN
5179: BEGIN
5180: SELECT fnd_date.date_to_canonical (expiration_date)
5181: INTO l_lotexpdate
5182: FROM mtl_lot_numbers
5183: WHERE inventory_item_id = p_item_id
5184: AND organization_id = p_organization_id
5185: AND lot_number = p_st_lot_num;
5186: EXCEPTION

Line 5240: FROM mtl_lot_numbers

5236: -- from the starting lot.
5237: BEGIN
5238: SELECT fnd_date.date_to_canonical (expiration_date)
5239: INTO l_lotexpdate
5240: FROM mtl_lot_numbers
5241: WHERE inventory_item_id = p_item_id
5242: AND organization_id = p_organization_id
5243: AND lot_number = p_st_lot_num;
5244: EXCEPTION

Line 5311: FROM mtl_lot_numbers

5307:
5308: BEGIN
5309: SELECT fnd_date.date_to_canonical (expiration_date)
5310: INTO l_lotexpdate
5311: FROM mtl_lot_numbers
5312: WHERE inventory_item_id = p_item_id
5313: AND organization_id = p_organization_id
5314: AND lot_number = p_rs_lot_num_tbl (1);
5315: EXCEPTION

Line 5327: FROM mtl_lot_numbers

5323: THEN
5324: BEGIN
5325: SELECT fnd_date.date_to_canonical (expiration_date)
5326: INTO l_lotexpdate
5327: FROM mtl_lot_numbers
5328: WHERE inventory_item_id = p_item_id
5329: AND organization_id = p_organization_id
5330: AND lot_number = p_st_lot_num;
5331: EXCEPTION

Line 5401: FROM mtl_lot_numbers

5397: THEN
5398: BEGIN
5399: SELECT fnd_date.date_to_canonical (expiration_date)
5400: INTO l_lotexpdate
5401: FROM mtl_lot_numbers
5402: WHERE inventory_item_id = p_item_id
5403: AND organization_id = p_organization_id
5404: AND lot_number = p_st_lot_num;
5405: EXCEPTION