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_MATERIAL_STATUSES_VL

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 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 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 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 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 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 1353: , (select status_code from mtl_material_statuses_vl where status_id = mln.status_id) status_code

1349: , mln.inventory_item_id
1350: , msik.concatenated_segments concatenated_segments
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

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 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