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.GME_MOBILE_LOVS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 387: mtl_system_items_kfv i

383: i.concatenated_segments,
384: i.inventory_item_id,
385: d.material_detail_id
386: FROM gme_material_details d,
387: mtl_system_items_kfv i
388: WHERE
389: d.batch_id = p_batch_id
390: AND d.line_type = -1
391: AND d.phantom_type = 0

Line 486: mtl_system_items_kfv i

482: NVL(i.grade_control_flag, 'N'),
483: NVL(i.lot_status_enabled, 'N'),
484: NVL(i.lot_divisible_flag, 'N')
485: FROM gme_material_details d,
486: mtl_system_items_kfv i
487: WHERE d.batch_id = p_batch_id
488: AND d.inventory_item_id = i.inventory_item_id
489: AND d.organization_id = i.organization_id
490: AND d.line_type = p_line_type

Line 515: mtl_system_items_kfv i

511: NVL(i.lot_divisible_flag, 'N')
512: FROM
513: gme_material_details d,
514: mtl_cross_references mcr,
515: mtl_system_items_kfv i
516: WHERE d.batch_id = p_batch_id
517: AND d.inventory_item_id = i.inventory_item_id
518: AND d.organization_id = i.organization_id
519: AND d.line_type = p_line_type

Line 550: mtl_system_items_kfv i

546: NVL(i.lot_divisible_flag, 'N')
547: FROM gme_material_details d,
548: gme_batch_step_items si,
549: gme_batch_steps s,
550: mtl_system_items_kfv i
551: WHERE d.batch_id = p_batch_id
552: AND d.batch_id = si.batch_id
553: AND si.material_detail_id = d.material_detail_id
554: AND s.batchstep_no = p_step_no

Line 585: mtl_system_items_kfv i

581: gme_material_details d,
582: mtl_cross_references mcr,
583: gme_batch_step_items si,
584: gme_batch_steps s,
585: mtl_system_items_kfv i
586: WHERE d.batch_id = p_batch_id
587: AND d.batch_id = si.batch_id
588: AND si.material_detail_id = d.material_detail_id
589: AND s.batchstep_no = p_step_no

Line 649: mtl_system_items_kfv i

645: d.material_detail_id
646: FROM gme_material_details d,
647: gme_batch_step_items si,
648: gme_batch_steps s,
649: mtl_system_items_kfv i
650: WHERE
651: d.batch_id = p_batch_id
652: AND d.batch_id = si.batch_id
653: AND si.material_detail_id = d.material_detail_id

Line 671: mtl_system_items_kfv i

667: i.concatenated_segments,
668: i.inventory_item_id,
669: d.material_detail_id
670: FROM gme_material_details d,
671: mtl_system_items_kfv i
672: WHERE
673: d.batch_id = p_batch_id
674: AND d.line_type = p_line_type
675: AND i.inventory_item_id = d.inventory_item_id

Line 726: mtl_system_items_kfv i

722: d.material_detail_id
723: FROM gme_material_details d,
724: gme_batch_step_items si,
725: gme_batch_steps s,
726: mtl_system_items_kfv i
727: WHERE
728: d.batch_id = p_batch_id
729: AND d.batch_id = si.batch_id
730: AND si.material_detail_id = d.material_detail_id

Line 749: mtl_system_items_kfv i

745: i.concatenated_segments,
746: i.inventory_item_id,
747: d.material_detail_id
748: FROM gme_material_details d,
749: mtl_system_items_kfv i
750: WHERE
751: d.batch_id = p_batch_id
752: AND d.line_type = p_line_type
753: AND i.inventory_item_id = d.inventory_item_id

Line 804: mtl_system_items_kfv i

800: d.material_detail_id
801: FROM gme_material_details d,
802: gme_batch_step_items si,
803: gme_batch_steps s,
804: mtl_system_items_kfv i
805: WHERE
806: d.batch_id = p_batch_id
807: AND d.batch_id = si.batch_id
808: AND si.material_detail_id = d.material_detail_id

Line 827: mtl_system_items_kfv i

823: i.concatenated_segments,
824: i.inventory_item_id,
825: d.material_detail_id
826: FROM gme_material_details d,
827: mtl_system_items_kfv i
828: WHERE
829: d.batch_id = p_batch_id
830: AND d.line_type = p_line_type
831: AND i.inventory_item_id = d.inventory_item_id

Line 1225: mtl_system_items_kfv i

1221: NVL(i.grade_control_flag, 'N'),
1222: NVL(i.lot_status_enabled, 'N'),
1223: NVL(i.lot_divisible_flag, 'N')
1224: FROM gme_material_details d,
1225: mtl_system_items_kfv i
1226: WHERE d.batch_id = p_batch_id
1227: AND d.inventory_item_id = i.inventory_item_id
1228: AND d.organization_id = i.organization_id
1229: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1254: mtl_system_items_kfv i

1250: NVL(i.lot_divisible_flag, 'N')
1251: FROM
1252: gme_material_details d,
1253: mtl_cross_references mcr,
1254: mtl_system_items_kfv i
1255: WHERE d.batch_id = p_batch_id
1256: AND d.inventory_item_id = i.inventory_item_id
1257: AND d.organization_id = i.organization_id
1258: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1323: mtl_system_items_kfv i

1319: NVL(i.grade_control_flag, 'N'),
1320: NVL(i.lot_status_enabled, 'N'),
1321: NVL(i.lot_divisible_flag, 'N')
1322: FROM gme_material_details d,
1323: mtl_system_items_kfv i
1324: WHERE d.batch_id = p_batch_id
1325: AND d.inventory_item_id = i.inventory_item_id
1326: AND d.organization_id = i.organization_id
1327: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1353: mtl_system_items_kfv i

1349: NVL(i.lot_divisible_flag, 'N')
1350: FROM
1351: gme_material_details d,
1352: mtl_cross_references mcr,
1353: mtl_system_items_kfv i
1354: WHERE d.batch_id = p_batch_id
1355: AND d.inventory_item_id = i.inventory_item_id
1356: AND d.organization_id = i.organization_id
1357: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1434: mtl_system_items_kfv i

1430: NVL(i.grade_control_flag, 'N'),
1431: NVL(i.lot_status_enabled, 'N'),
1432: NVL(i.lot_divisible_flag, 'N')
1433: FROM gme_material_details d,
1434: mtl_system_items_kfv i
1435: WHERE d.batch_id = p_batch_id
1436: AND d.inventory_item_id = i.inventory_item_id
1437: AND d.organization_id = i.organization_id
1438: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1463: mtl_system_items_kfv i

1459: NVL(i.lot_divisible_flag, 'N')
1460: FROM
1461: gme_material_details d,
1462: mtl_cross_references mcr,
1463: mtl_system_items_kfv i
1464: WHERE d.batch_id = p_batch_id
1465: AND d.inventory_item_id = i.inventory_item_id
1466: AND d.organization_id = i.organization_id
1467: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1498: mtl_system_items_kfv i

1494: NVL(i.lot_divisible_flag, 'N')
1495: FROM gme_material_details d,
1496: gme_batch_step_items si,
1497: gme_batch_steps s,
1498: mtl_system_items_kfv i
1499: WHERE d.batch_id = p_batch_id
1500: AND d.batch_id = si.batch_id
1501: AND si.material_detail_id = d.material_detail_id
1502: AND s.batchstep_no = p_step_no

Line 1533: mtl_system_items_kfv i

1529: gme_material_details d,
1530: mtl_cross_references mcr,
1531: gme_batch_step_items si,
1532: gme_batch_steps s,
1533: mtl_system_items_kfv i
1534: WHERE d.batch_id = p_batch_id
1535: AND d.batch_id = si.batch_id
1536: AND si.material_detail_id = d.material_detail_id
1537: AND s.batchstep_no = p_step_no

Line 1621: mtl_system_items_kfv i

1617: NVL(i.grade_control_flag, 'N'),
1618: NVL(i.lot_status_enabled, 'N'),
1619: NVL(i.lot_divisible_flag, 'N')
1620: FROM gme_material_details d,
1621: mtl_system_items_kfv i
1622: WHERE d.batch_id = p_batch_id
1623: AND d.inventory_item_id = i.inventory_item_id
1624: AND d.organization_id = i.organization_id
1625: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1650: mtl_system_items_kfv i

1646: NVL(i.lot_divisible_flag, 'N')
1647: FROM
1648: gme_material_details d,
1649: mtl_cross_references mcr,
1650: mtl_system_items_kfv i
1651: WHERE d.batch_id = p_batch_id
1652: AND d.inventory_item_id = i.inventory_item_id
1653: AND d.organization_id = i.organization_id
1654: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1686: mtl_system_items_kfv i

1682: NVL(i.lot_divisible_flag, 'N')
1683: FROM gme_material_details d,
1684: gme_batch_step_items si,
1685: gme_batch_steps s,
1686: mtl_system_items_kfv i
1687: WHERE d.batch_id = p_batch_id
1688: AND d.batch_id = si.batch_id
1689: AND si.material_detail_id = d.material_detail_id
1690: AND s.batchstep_no = p_step_no

Line 1721: mtl_system_items_kfv i

1717: gme_material_details d,
1718: mtl_cross_references mcr,
1719: gme_batch_step_items si,
1720: gme_batch_steps s,
1721: mtl_system_items_kfv i
1722: WHERE d.batch_id = p_batch_id
1723: AND d.batch_id = si.batch_id
1724: AND si.material_detail_id = d.material_detail_id
1725: AND s.batchstep_no = p_step_no

Line 1811: mtl_system_items_kfv i

1807: NVL(i.grade_control_flag, 'N'),
1808: NVL(i.lot_status_enabled, 'N'),
1809: NVL(i.lot_divisible_flag, 'N')
1810: FROM gme_material_details d,
1811: mtl_system_items_kfv i
1812: WHERE d.batch_id = p_batch_id
1813: AND d.inventory_item_id = i.inventory_item_id
1814: AND d.organization_id = i.organization_id
1815: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1841: mtl_system_items_kfv i

1837: NVL(i.lot_divisible_flag, 'N')
1838: FROM
1839: gme_material_details d,
1840: mtl_cross_references mcr,
1841: mtl_system_items_kfv i
1842: WHERE d.batch_id = p_batch_id
1843: AND d.inventory_item_id = i.inventory_item_id
1844: AND d.organization_id = i.organization_id
1845: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1877: mtl_system_items_kfv i

1873: NVL(i.lot_divisible_flag, 'N')
1874: FROM gme_material_details d,
1875: gme_batch_step_items si,
1876: gme_batch_steps s,
1877: mtl_system_items_kfv i
1878: WHERE d.batch_id = p_batch_id
1879: AND d.batch_id = si.batch_id
1880: AND si.material_detail_id = d.material_detail_id
1881: AND s.batchstep_no = p_step_no

Line 1913: mtl_system_items_kfv i

1909: gme_material_details d,
1910: mtl_cross_references mcr,
1911: gme_batch_step_items si,
1912: gme_batch_steps s,
1913: mtl_system_items_kfv i
1914: WHERE d.batch_id = p_batch_id
1915: AND d.batch_id = si.batch_id
1916: AND si.material_detail_id = d.material_detail_id
1917: AND s.batchstep_no = p_step_no

Line 2002: mtl_system_items_kfv i

1998: NVL(i.grade_control_flag, 'N'),
1999: NVL(i.lot_status_enabled, 'N'),
2000: NVL(i.lot_divisible_flag, 'N')
2001: FROM gme_material_details d,
2002: mtl_system_items_kfv i
2003: WHERE d.batch_id = p_batch_id
2004: AND d.inventory_item_id = i.inventory_item_id
2005: AND d.organization_id = i.organization_id
2006: AND d.line_no = NVL(p_line_no, d.line_no)

Line 2031: mtl_system_items_kfv i

2027: NVL(i.lot_divisible_flag, 'N')
2028: FROM
2029: gme_material_details d,
2030: mtl_cross_references mcr,
2031: mtl_system_items_kfv i
2032: WHERE d.batch_id = p_batch_id
2033: AND d.inventory_item_id = i.inventory_item_id
2034: AND d.organization_id = i.organization_id
2035: AND d.line_no = NVL(p_line_no, d.line_no)

Line 2067: mtl_system_items_kfv i

2063: NVL(i.lot_divisible_flag, 'N')
2064: FROM gme_material_details d,
2065: gme_batch_step_items si,
2066: gme_batch_steps s,
2067: mtl_system_items_kfv i
2068: WHERE d.batch_id = p_batch_id
2069: AND d.batch_id = si.batch_id
2070: AND si.material_detail_id = d.material_detail_id
2071: AND s.batchstep_no = p_step_no

Line 2103: mtl_system_items_kfv i

2099: gme_material_details d,
2100: mtl_cross_references mcr,
2101: gme_batch_step_items si,
2102: gme_batch_steps s,
2103: mtl_system_items_kfv i
2104: WHERE d.batch_id = p_batch_id
2105: AND d.batch_id = si.batch_id
2106: AND si.material_detail_id = d.material_detail_id
2107: AND s.batchstep_no = p_step_no