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_INV_LOVS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 314: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

310: BEGIN
311: BEGIN
312: SELECT msik.lot_control_code
313: INTO l_lot_control_code
314: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
315: WHERE msik.inventory_item_id = p_item_id
316: AND msik.inventory_item_id = rsl.item_id --Bug 4235750
317: AND rsl.shipment_header_id = p_shipment_header_id
318: AND rsl.to_organization_id = p_organization_id

Line 961: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

957: , msik.description
958: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
959: , mms.status_code status_code
960: , mms.status_id
961: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
962: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
963: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
964: AND mln.organization_id = p_organization_id
965: AND mln.organization_id = msik.organization_id

Line 980: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

976: , msik.description
977: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
978: , NULL status_code
979: , msik.default_lot_status_id -- Bug#2267947
980: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
981: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
982: AND mln.organization_id = p_organization_id
983: AND mln.organization_id = msik.organization_id
984: AND mln.inventory_item_id = msik.inventory_item_id

Line 1001: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

997: , msik.description
998: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
999: , mms.status_code
1000: , mms.status_id
1001: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1002: WHERE moq.organization_id = p_organization_id
1003: AND moq.lot_number IS NOT NULL
1004: AND moq.organization_id = mil.organization_id
1005: AND moq.organization_id = mln.organization_id

Line 1030: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1026: , msik.description
1027: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1028: , NULL status_code
1029: , msik.default_lot_status_id -- Bug#2267947
1030: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1031: WHERE moq.organization_id = p_organization_id
1032: AND moq.lot_number IS NOT NULL
1033: AND moq.organization_id = mil.organization_id
1034: AND moq.organization_id = mln.organization_id

Line 1060: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1056: , msik.description
1057: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1058: , mms.status_code
1059: , mms.status_id
1060: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1061: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1062: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1063: AND mln.organization_id = p_organization_id
1064: AND mln.organization_id = msik.organization_id

Line 1079: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1075: , msik.description
1076: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1077: , NULL status_code
1078: , msik.default_lot_status_id -- Bug#2267947
1079: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1080: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1081: AND mln.organization_id = p_organization_id
1082: AND mln.organization_id = msik.organization_id
1083: AND mln.inventory_item_id = msik.inventory_item_id

Line 1102: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1098: , msik.description
1099: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1100: , mms.status_code
1101: , mms.status_id
1102: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1103: WHERE mms.status_id = msik.default_lot_status_id
1104: AND msik.default_lot_status_id IS NOT NULL
1105: AND mln.organization_id = p_organization_id
1106: AND mln.organization_id = msik.organization_id

Line 1122: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1118: , msik.description
1119: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1120: , NULL status_code
1121: , msik.default_lot_status_id -- Bug#2267947
1122: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1123: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1124: AND mln.organization_id = p_organization_id
1125: AND mln.organization_id = msik.organization_id
1126: AND mln.inventory_item_id = msik.inventory_item_id

Line 1141: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1137: , msik.description
1138: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1139: , mms.status_code
1140: , mms.status_id
1141: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1142: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1143: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1144: AND mln.organization_id = p_organization_id
1145: AND mln.organization_id = msik.organization_id

Line 1160: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1156: , msik.description
1157: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1158: , NULL status_code
1159: , msik.default_lot_status_id -- Bug#2267947
1160: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1161: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1162: AND mln.organization_id = p_organization_id
1163: AND mln.organization_id = msik.organization_id
1164: AND mln.inventory_item_id = msik.inventory_item_id

Line 1236: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1232: , msik.description
1233: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1234: , mms.status_code status_code
1235: , mms.status_id
1236: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1237: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1238: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1239: AND mln.organization_id = p_organization_id
1240: AND mln.organization_id = msik.organization_id

Line 1254: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1250: , msik.description
1251: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1252: , NULL status_code
1253: , msik.default_lot_status_id -- Bug#2267947
1254: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1255: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1256: AND mln.organization_id = p_organization_id
1257: AND mln.organization_id = msik.organization_id
1258: AND mln.inventory_item_id = msik.inventory_item_id

Line 1275: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1271: , msik.description
1272: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1273: , mms.status_code
1274: , mms.status_id
1275: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1276: WHERE moq.organization_id = p_organization_id
1277: AND moq.lot_number IS NOT NULL
1278: AND moq.organization_id = mil.organization_id
1279: AND moq.organization_id = mln.organization_id

Line 1305: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1301: , msik.description
1302: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1303: , NULL status_code
1304: , msik.default_lot_status_id -- Bug#2267947
1305: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1306: WHERE moq.organization_id = p_organization_id
1307: AND moq.lot_number IS NOT NULL
1308: AND moq.organization_id = mil.organization_id
1309: AND moq.organization_id = mln.organization_id

Line 1336: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1332: , msik.description
1333: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1334: , mms.status_code
1335: , mms.status_id
1336: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1337: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1338: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1339: AND mln.organization_id = p_organization_id
1340: AND mln.organization_id = msik.organization_id

Line 1355: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1351: , msik.description
1352: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1353: , (select status_code from mtl_material_statuses_vl where status_id = mln.status_id) status_code
1354: , mln.status_id -- Bug#2347381
1355: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1356: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1357: AND mln.organization_id = p_organization_id
1358: AND mln.organization_id = msik.organization_id
1359: AND mln.inventory_item_id = msik.inventory_item_id

Line 1378: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1374: , msik.description
1375: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1376: , mms.status_code
1377: , mms.status_id
1378: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1379: WHERE mms.status_id = msik.default_lot_status_id
1380: AND msik.default_lot_status_id IS NOT NULL
1381: AND mln.organization_id = p_organization_id
1382: AND mln.organization_id = msik.organization_id

Line 1397: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1393: , msik.description
1394: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1395: , NULL status_code
1396: , msik.default_lot_status_id -- Bug#2267947
1397: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1398: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1399: AND mln.organization_id = p_organization_id
1400: AND mln.organization_id = msik.organization_id
1401: AND mln.inventory_item_id = msik.inventory_item_id

Line 1416: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1412: , msik.description
1413: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1414: , mms.status_code
1415: , mms.status_id
1416: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1417: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1418: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1419: AND mln.organization_id = p_organization_id
1420: AND mln.organization_id = msik.organization_id

Line 1434: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1430: , msik.description
1431: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1432: , NULL status_code
1433: , msik.default_lot_status_id -- Bug#2267947
1434: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1435: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1436: AND mln.organization_id = p_organization_id
1437: AND mln.organization_id = msik.organization_id
1438: AND mln.inventory_item_id = msik.inventory_item_id

Line 2274: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

2270: SELECT msik.lot_control_code
2271: , rsl.from_organization_id
2272: INTO x_lot_control_code
2273: , x_from_org_id
2274: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
2275: WHERE msik.inventory_item_id = p_item_id
2276: AND rsl.shipment_header_id = p_shipment_header_id
2277: AND rsl.to_organization_id = p_organization_id
2278: AND rsl.from_organization_id = msik.organization_id