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 706: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 755: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 805: FROM mtl_system_items_b msik, mtl_lot_numbers mln

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

Line 1044: FROM mtl_lot_numbers

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

Line 1103: FROM mtl_lot_numbers

1099: IF (p_st_lot_num_tbl (1) <> p_rs_lot_num_tbl (1))
1100: THEN
1101: SELECT COUNT (1)
1102: INTO l_lot_count
1103: FROM mtl_lot_numbers
1104: WHERE inventory_item_id <> p_inventory_item_id
1105: AND organization_id = p_organization_id
1106: AND lot_number = p_rs_lot_num_tbl (1);
1107:

Line 1141: FROM mtl_lot_numbers

1137: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_merge)
1138: THEN
1139: SELECT COUNT (1)
1140: INTO l_lot_count
1141: FROM mtl_lot_numbers
1142: WHERE inventory_item_id <> p_inventory_item_id
1143: AND organization_id = p_organization_id
1144: AND lot_number = p_rs_lot_num_tbl (1);
1145:

Line 1187: FROM mtl_lot_numbers

1183: FOR i IN 1 .. p_rs_lot_num_tbl.COUNT
1184: LOOP
1185: SELECT COUNT (1)
1186: INTO l_lot_count
1187: FROM mtl_lot_numbers
1188: WHERE inventory_item_id = p_inventory_item_id
1189: AND organization_id = p_organization_id
1190: AND lot_number = p_rs_lot_num_tbl (i);
1191:

Line 1273: FROM mtl_lot_numbers

1269: IF (p_st_lot_num_tbl (1) <> p_rs_lot_num_tbl (1))
1270: THEN
1271: SELECT COUNT (1)
1272: INTO l_lot_count
1273: FROM mtl_lot_numbers
1274: WHERE inventory_item_id = p_inventory_item_id
1275: AND organization_id = p_organization_id
1276: AND lot_number = p_rs_lot_num_tbl (1);
1277:

Line 1354: FROM mtl_lot_numbers

1350: END IF;
1351:
1352: SELECT count(1)
1353: INTO l_lot_count
1354: FROM mtl_lot_numbers
1355: WHERE inventory_item_id = p_inventory_item_id
1356: AND organization_id = p_organization_id
1357: AND lot_number = p_rs_lot_num_tbl(1);
1358:

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

1357: AND lot_number = p_rs_lot_num_tbl(1);
1358:
1359: if( l_lot_count = 0 ) then
1360: IF (l_debug = 1) THEN
1361: print_debug('after validating against mtl_lot_numbers', 'validate_result_lot');
1362: END IF;
1363: SELECT count(1)
1364: INTO l_lot_count
1365: FROM WIP_ENTITIES

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

1702: * return missing required parameter error *
1703: * end if; *
1704: * *
1705: * if( p_status_id is null ) then *
1706: * retrieve the status from mtl_lot_numbers for the lot number into l_status_id *
1707: * If not found then *
1708: * Return invalid lot number error *
1709: * End if; *
1710: * Else *

Line 1806: FROM mtl_lot_numbers

1802: THEN
1803: BEGIN
1804: SELECT status_id
1805: INTO l_status_id
1806: FROM mtl_lot_numbers
1807: WHERE organization_id = p_organization_id
1808: AND inventory_item_id = p_inventory_item_id
1809: AND lot_number = p_lot_number;
1810: EXCEPTION

Line 2535: , p_table_name => 'MTL_LOT_NUMBERS'

2531: , x_attributes_default_count => l_attributes_default_count
2532: , x_return_status => l_return_status
2533: , x_msg_count => l_msg_count
2534: , x_msg_data => x_msg_data
2535: , p_table_name => 'MTL_LOT_NUMBERS'
2536: , p_attributes_name => 'Lot Attributes'
2537: , p_inventory_item_id => p_inventory_item_id
2538: , p_organization_id => p_organization_id
2539: , p_lot_serial_number => p_lot_number

Line 5081: FROM mtl_lot_numbers

5077: THEN
5078: BEGIN
5079: SELECT fnd_date.date_to_canonical (expiration_date)
5080: INTO l_lotexpdate
5081: FROM mtl_lot_numbers
5082: WHERE inventory_item_id = p_item_id
5083: AND organization_id = p_organization_id
5084: AND lot_number = p_st_lot_num;
5085: EXCEPTION

Line 5148: FROM mtl_lot_numbers

5144: -- expiration DATE of that lot from the table. pass both in this case.
5145: BEGIN
5146: SELECT fnd_date.date_to_canonical (expiration_date)
5147: INTO l_lotexpdate
5148: FROM mtl_lot_numbers
5149: WHERE inventory_item_id = p_item_id
5150: AND organization_id = p_organization_id
5151: AND lot_number = p_rs_lot_num_tbl (1);
5152: EXCEPTION

Line 5158: FROM mtl_lot_numbers

5154: THEN -- then get the exp date of the lot
5155: --either WITH the highet qty OR the rep. lot
5156: SELECT fnd_date.date_to_canonical (expiration_date)
5157: INTO l_lotexpdate
5158: FROM mtl_lot_numbers
5159: WHERE inventory_item_id = p_item_id
5160: AND organization_id = p_organization_id
5161: AND lot_number = p_st_lot_num; -- We only pass one
5162: -- lot here based on the highest qty or the rep. lot.

Line 5211: FROM mtl_lot_numbers

5207: THEN
5208: BEGIN
5209: SELECT fnd_date.date_to_canonical (expiration_date)
5210: INTO l_lotexpdate
5211: FROM mtl_lot_numbers
5212: WHERE inventory_item_id = p_item_id
5213: AND organization_id = p_organization_id
5214: AND lot_number = p_st_lot_num;
5215: EXCEPTION

Line 5269: FROM mtl_lot_numbers

5265: -- from the starting lot.
5266: BEGIN
5267: SELECT fnd_date.date_to_canonical (expiration_date)
5268: INTO l_lotexpdate
5269: FROM mtl_lot_numbers
5270: WHERE inventory_item_id = p_item_id
5271: AND organization_id = p_organization_id
5272: AND lot_number = p_st_lot_num;
5273: EXCEPTION

Line 5340: FROM mtl_lot_numbers

5336:
5337: BEGIN
5338: SELECT fnd_date.date_to_canonical (expiration_date)
5339: INTO l_lotexpdate
5340: FROM mtl_lot_numbers
5341: WHERE inventory_item_id = p_item_id
5342: AND organization_id = p_organization_id
5343: AND lot_number = p_rs_lot_num_tbl (1);
5344: EXCEPTION

Line 5356: FROM mtl_lot_numbers

5352: THEN
5353: BEGIN
5354: SELECT fnd_date.date_to_canonical (expiration_date)
5355: INTO l_lotexpdate
5356: FROM mtl_lot_numbers
5357: WHERE inventory_item_id = p_item_id
5358: AND organization_id = p_organization_id
5359: AND lot_number = p_st_lot_num;
5360: EXCEPTION

Line 5430: FROM mtl_lot_numbers

5426: THEN
5427: BEGIN
5428: SELECT fnd_date.date_to_canonical (expiration_date)
5429: INTO l_lotexpdate
5430: FROM mtl_lot_numbers
5431: WHERE inventory_item_id = p_item_id
5432: AND organization_id = p_organization_id
5433: AND lot_number = p_st_lot_num;
5434: EXCEPTION