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 414: mtl_system_items_kfv i

410: i.concatenated_segments,
411: i.inventory_item_id,
412: d.material_detail_id
413: FROM gme_material_details d,
414: mtl_system_items_kfv i
415: WHERE
416: d.batch_id = p_batch_id
417: AND d.line_type = -1
418: AND d.phantom_type = 0

Line 513: mtl_system_items_kfv i

509: NVL(i.grade_control_flag, 'N'),
510: NVL(i.lot_status_enabled, 'N'),
511: NVL(i.lot_divisible_flag, 'N')
512: FROM gme_material_details d,
513: mtl_system_items_kfv i
514: WHERE d.batch_id = p_batch_id
515: AND d.inventory_item_id = i.inventory_item_id
516: AND d.organization_id = i.organization_id
517: AND d.line_type = p_line_type

Line 542: mtl_system_items_kfv i

538: NVL(i.lot_divisible_flag, 'N')
539: FROM
540: gme_material_details d,
541: mtl_cross_references mcr,
542: mtl_system_items_kfv i
543: WHERE d.batch_id = p_batch_id
544: AND d.inventory_item_id = i.inventory_item_id
545: AND d.organization_id = i.organization_id
546: AND d.line_type = p_line_type

Line 577: mtl_system_items_kfv i

573: NVL(i.lot_divisible_flag, 'N')
574: FROM gme_material_details d,
575: gme_batch_step_items si,
576: gme_batch_steps s,
577: mtl_system_items_kfv i
578: WHERE d.batch_id = p_batch_id
579: AND d.batch_id = si.batch_id
580: AND si.material_detail_id = d.material_detail_id
581: AND s.batchstep_no = p_step_no

Line 612: mtl_system_items_kfv i

608: gme_material_details d,
609: mtl_cross_references mcr,
610: gme_batch_step_items si,
611: gme_batch_steps s,
612: mtl_system_items_kfv i
613: WHERE d.batch_id = p_batch_id
614: AND d.batch_id = si.batch_id
615: AND si.material_detail_id = d.material_detail_id
616: AND s.batchstep_no = p_step_no

Line 676: mtl_system_items_kfv i

672: d.material_detail_id
673: FROM gme_material_details d,
674: gme_batch_step_items si,
675: gme_batch_steps s,
676: mtl_system_items_kfv i
677: WHERE
678: d.batch_id = p_batch_id
679: AND d.batch_id = si.batch_id
680: AND si.material_detail_id = d.material_detail_id

Line 698: mtl_system_items_kfv i

694: i.concatenated_segments,
695: i.inventory_item_id,
696: d.material_detail_id
697: FROM gme_material_details d,
698: mtl_system_items_kfv i
699: WHERE
700: d.batch_id = p_batch_id
701: AND d.line_type = p_line_type
702: AND i.inventory_item_id = d.inventory_item_id

Line 753: mtl_system_items_kfv i

749: d.material_detail_id
750: FROM gme_material_details d,
751: gme_batch_step_items si,
752: gme_batch_steps s,
753: mtl_system_items_kfv i
754: WHERE
755: d.batch_id = p_batch_id
756: AND d.batch_id = si.batch_id
757: AND si.material_detail_id = d.material_detail_id

Line 776: mtl_system_items_kfv i

772: i.concatenated_segments,
773: i.inventory_item_id,
774: d.material_detail_id
775: FROM gme_material_details d,
776: mtl_system_items_kfv i
777: WHERE
778: d.batch_id = p_batch_id
779: AND d.line_type = p_line_type
780: AND i.inventory_item_id = d.inventory_item_id

Line 831: mtl_system_items_kfv i

827: d.material_detail_id
828: FROM gme_material_details d,
829: gme_batch_step_items si,
830: gme_batch_steps s,
831: mtl_system_items_kfv i
832: WHERE
833: d.batch_id = p_batch_id
834: AND d.batch_id = si.batch_id
835: AND si.material_detail_id = d.material_detail_id

Line 854: mtl_system_items_kfv i

850: i.concatenated_segments,
851: i.inventory_item_id,
852: d.material_detail_id
853: FROM gme_material_details d,
854: mtl_system_items_kfv i
855: WHERE
856: d.batch_id = p_batch_id
857: AND d.line_type = p_line_type
858: AND i.inventory_item_id = d.inventory_item_id

Line 1252: mtl_system_items_kfv i

1248: NVL(i.grade_control_flag, 'N'),
1249: NVL(i.lot_status_enabled, 'N'),
1250: NVL(i.lot_divisible_flag, 'N')
1251: FROM gme_material_details d,
1252: mtl_system_items_kfv i
1253: WHERE d.batch_id = p_batch_id
1254: AND d.inventory_item_id = i.inventory_item_id
1255: AND d.organization_id = i.organization_id
1256: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1281: mtl_system_items_kfv i

1277: NVL(i.lot_divisible_flag, 'N')
1278: FROM
1279: gme_material_details d,
1280: mtl_cross_references mcr,
1281: mtl_system_items_kfv i
1282: WHERE d.batch_id = p_batch_id
1283: AND d.inventory_item_id = i.inventory_item_id
1284: AND d.organization_id = i.organization_id
1285: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1350: mtl_system_items_kfv i

1346: NVL(i.grade_control_flag, 'N'),
1347: NVL(i.lot_status_enabled, 'N'),
1348: NVL(i.lot_divisible_flag, 'N')
1349: FROM gme_material_details d,
1350: mtl_system_items_kfv i
1351: WHERE d.batch_id = p_batch_id
1352: AND d.inventory_item_id = i.inventory_item_id
1353: AND d.organization_id = i.organization_id
1354: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1380: mtl_system_items_kfv i

1376: NVL(i.lot_divisible_flag, 'N')
1377: FROM
1378: gme_material_details d,
1379: mtl_cross_references mcr,
1380: mtl_system_items_kfv i
1381: WHERE d.batch_id = p_batch_id
1382: AND d.inventory_item_id = i.inventory_item_id
1383: AND d.organization_id = i.organization_id
1384: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1461: mtl_system_items_kfv i

1457: NVL(i.grade_control_flag, 'N'),
1458: NVL(i.lot_status_enabled, 'N'),
1459: NVL(i.lot_divisible_flag, 'N')
1460: FROM gme_material_details d,
1461: mtl_system_items_kfv i
1462: WHERE d.batch_id = p_batch_id
1463: AND d.inventory_item_id = i.inventory_item_id
1464: AND d.organization_id = i.organization_id
1465: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1490: mtl_system_items_kfv i

1486: NVL(i.lot_divisible_flag, 'N')
1487: FROM
1488: gme_material_details d,
1489: mtl_cross_references mcr,
1490: mtl_system_items_kfv i
1491: WHERE d.batch_id = p_batch_id
1492: AND d.inventory_item_id = i.inventory_item_id
1493: AND d.organization_id = i.organization_id
1494: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1525: mtl_system_items_kfv i

1521: NVL(i.lot_divisible_flag, 'N')
1522: FROM gme_material_details d,
1523: gme_batch_step_items si,
1524: gme_batch_steps s,
1525: mtl_system_items_kfv i
1526: WHERE d.batch_id = p_batch_id
1527: AND d.batch_id = si.batch_id
1528: AND si.material_detail_id = d.material_detail_id
1529: AND s.batchstep_no = p_step_no

Line 1560: mtl_system_items_kfv i

1556: gme_material_details d,
1557: mtl_cross_references mcr,
1558: gme_batch_step_items si,
1559: gme_batch_steps s,
1560: mtl_system_items_kfv i
1561: WHERE d.batch_id = p_batch_id
1562: AND d.batch_id = si.batch_id
1563: AND si.material_detail_id = d.material_detail_id
1564: AND s.batchstep_no = p_step_no

Line 1648: mtl_system_items_kfv i

1644: NVL(i.grade_control_flag, 'N'),
1645: NVL(i.lot_status_enabled, 'N'),
1646: NVL(i.lot_divisible_flag, 'N')
1647: FROM gme_material_details d,
1648: mtl_system_items_kfv i
1649: WHERE d.batch_id = p_batch_id
1650: AND d.inventory_item_id = i.inventory_item_id
1651: AND d.organization_id = i.organization_id
1652: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1677: mtl_system_items_kfv i

1673: NVL(i.lot_divisible_flag, 'N')
1674: FROM
1675: gme_material_details d,
1676: mtl_cross_references mcr,
1677: mtl_system_items_kfv i
1678: WHERE d.batch_id = p_batch_id
1679: AND d.inventory_item_id = i.inventory_item_id
1680: AND d.organization_id = i.organization_id
1681: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1713: mtl_system_items_kfv i

1709: NVL(i.lot_divisible_flag, 'N')
1710: FROM gme_material_details d,
1711: gme_batch_step_items si,
1712: gme_batch_steps s,
1713: mtl_system_items_kfv i
1714: WHERE d.batch_id = p_batch_id
1715: AND d.batch_id = si.batch_id
1716: AND si.material_detail_id = d.material_detail_id
1717: AND s.batchstep_no = p_step_no

Line 1748: mtl_system_items_kfv i

1744: gme_material_details d,
1745: mtl_cross_references mcr,
1746: gme_batch_step_items si,
1747: gme_batch_steps s,
1748: mtl_system_items_kfv i
1749: WHERE d.batch_id = p_batch_id
1750: AND d.batch_id = si.batch_id
1751: AND si.material_detail_id = d.material_detail_id
1752: AND s.batchstep_no = p_step_no

Line 1838: mtl_system_items_kfv i

1834: NVL(i.grade_control_flag, 'N'),
1835: NVL(i.lot_status_enabled, 'N'),
1836: NVL(i.lot_divisible_flag, 'N')
1837: FROM gme_material_details d,
1838: mtl_system_items_kfv i
1839: WHERE d.batch_id = p_batch_id
1840: AND d.inventory_item_id = i.inventory_item_id
1841: AND d.organization_id = i.organization_id
1842: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1868: mtl_system_items_kfv i

1864: NVL(i.lot_divisible_flag, 'N')
1865: FROM
1866: gme_material_details d,
1867: mtl_cross_references mcr,
1868: mtl_system_items_kfv i
1869: WHERE d.batch_id = p_batch_id
1870: AND d.inventory_item_id = i.inventory_item_id
1871: AND d.organization_id = i.organization_id
1872: AND d.line_no = NVL(p_line_no, d.line_no)

Line 1904: mtl_system_items_kfv i

1900: NVL(i.lot_divisible_flag, 'N')
1901: FROM gme_material_details d,
1902: gme_batch_step_items si,
1903: gme_batch_steps s,
1904: mtl_system_items_kfv i
1905: WHERE d.batch_id = p_batch_id
1906: AND d.batch_id = si.batch_id
1907: AND si.material_detail_id = d.material_detail_id
1908: AND s.batchstep_no = p_step_no

Line 1940: mtl_system_items_kfv i

1936: gme_material_details d,
1937: mtl_cross_references mcr,
1938: gme_batch_step_items si,
1939: gme_batch_steps s,
1940: mtl_system_items_kfv i
1941: WHERE d.batch_id = p_batch_id
1942: AND d.batch_id = si.batch_id
1943: AND si.material_detail_id = d.material_detail_id
1944: AND s.batchstep_no = p_step_no

Line 2029: mtl_system_items_kfv i

2025: NVL(i.grade_control_flag, 'N'),
2026: NVL(i.lot_status_enabled, 'N'),
2027: NVL(i.lot_divisible_flag, 'N')
2028: FROM gme_material_details d,
2029: mtl_system_items_kfv i
2030: WHERE d.batch_id = p_batch_id
2031: AND d.inventory_item_id = i.inventory_item_id
2032: AND d.organization_id = i.organization_id
2033: AND d.line_no = NVL(p_line_no, d.line_no)

Line 2058: mtl_system_items_kfv i

2054: NVL(i.lot_divisible_flag, 'N')
2055: FROM
2056: gme_material_details d,
2057: mtl_cross_references mcr,
2058: mtl_system_items_kfv i
2059: WHERE d.batch_id = p_batch_id
2060: AND d.inventory_item_id = i.inventory_item_id
2061: AND d.organization_id = i.organization_id
2062: AND d.line_no = NVL(p_line_no, d.line_no)

Line 2094: mtl_system_items_kfv i

2090: NVL(i.lot_divisible_flag, 'N')
2091: FROM gme_material_details d,
2092: gme_batch_step_items si,
2093: gme_batch_steps s,
2094: mtl_system_items_kfv i
2095: WHERE d.batch_id = p_batch_id
2096: AND d.batch_id = si.batch_id
2097: AND si.material_detail_id = d.material_detail_id
2098: AND s.batchstep_no = p_step_no

Line 2130: mtl_system_items_kfv i

2126: gme_material_details d,
2127: mtl_cross_references mcr,
2128: gme_batch_step_items si,
2129: gme_batch_steps s,
2130: mtl_system_items_kfv i
2131: WHERE d.batch_id = p_batch_id
2132: AND d.batch_id = si.batch_id
2133: AND si.material_detail_id = d.material_detail_id
2134: AND s.batchstep_no = p_step_no