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 937: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

933: , msik.description
934: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
935: , mms.status_code status_code
936: , mms.status_id
937: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
938: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
939: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
940: AND mln.organization_id = p_organization_id
941: AND mln.organization_id = msik.organization_id

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

973: , msik.description
974: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
975: , mms.status_code
976: , mms.status_id
977: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
978: WHERE moq.organization_id = p_organization_id
979: AND moq.lot_number IS NOT NULL
980: AND moq.organization_id = mil.organization_id
981: AND moq.organization_id = mln.organization_id

Line 1006: 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: , msik.description
1003: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1004: , NULL status_code
1005: , msik.default_lot_status_id -- Bug#2267947
1006: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1007: WHERE moq.organization_id = p_organization_id
1008: AND moq.lot_number IS NOT NULL
1009: AND moq.organization_id = mil.organization_id
1010: AND moq.organization_id = mln.organization_id

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

1032: , msik.description
1033: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1034: , mms.status_code
1035: , mms.status_id
1036: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1037: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1038: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1039: AND mln.organization_id = p_organization_id
1040: AND mln.organization_id = msik.organization_id

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

1074: , msik.description
1075: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1076: , mms.status_code
1077: , mms.status_id
1078: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1079: WHERE mms.status_id = msik.default_lot_status_id
1080: AND msik.default_lot_status_id IS NOT NULL
1081: AND mln.organization_id = p_organization_id
1082: AND mln.organization_id = msik.organization_id

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

1113: , msik.description
1114: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1115: , mms.status_code
1116: , mms.status_id
1117: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1118: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1119: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1120: AND mln.organization_id = p_organization_id
1121: AND mln.organization_id = msik.organization_id

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

1208: , msik.description
1209: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1210: , mms.status_code status_code
1211: , mms.status_id
1212: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1213: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1214: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1215: AND mln.organization_id = p_organization_id
1216: AND mln.organization_id = msik.organization_id

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

1247: , msik.description
1248: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1249: , mms.status_code
1250: , mms.status_id
1251: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1252: WHERE moq.organization_id = p_organization_id
1253: AND moq.lot_number IS NOT NULL
1254: AND moq.organization_id = mil.organization_id
1255: AND moq.organization_id = mln.organization_id

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

1277: , msik.description
1278: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1279: , NULL status_code
1280: , msik.default_lot_status_id -- Bug#2267947
1281: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1282: WHERE moq.organization_id = p_organization_id
1283: AND moq.lot_number IS NOT NULL
1284: AND moq.organization_id = mil.organization_id
1285: AND moq.organization_id = mln.organization_id

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

1308: , msik.description
1309: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1310: , mms.status_code
1311: , mms.status_id
1312: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1313: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1314: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1315: AND mln.organization_id = p_organization_id
1316: AND mln.organization_id = msik.organization_id

Line 1329: , (select status_code from mtl_material_statuses_vl where status_id = mln.status_id) status_code

1325: , mln.inventory_item_id
1326: , msik.concatenated_segments concatenated_segments
1327: , msik.description
1328: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1329: , (select status_code from mtl_material_statuses_vl where status_id = mln.status_id) status_code
1330: , mln.status_id -- Bug#2347381
1331: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1332: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1333: AND mln.organization_id = p_organization_id

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

1350: , msik.description
1351: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1352: , mms.status_code
1353: , mms.status_id
1354: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1355: WHERE mms.status_id = msik.default_lot_status_id
1356: AND msik.default_lot_status_id IS NOT NULL
1357: AND mln.organization_id = p_organization_id
1358: AND mln.organization_id = msik.organization_id

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

1388: , msik.description
1389: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1390: , mms.status_code
1391: , mms.status_id
1392: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1393: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1394: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1395: AND mln.organization_id = p_organization_id
1396: AND mln.organization_id = msik.organization_id