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 GME_MATERIAL_DETAILS

Line 413: FROM gme_material_details d,

409: SELECT d.line_no,
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

Line 512: FROM gme_material_details d,

508: NVL(i.restrict_locators_code, 2),
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

Line 540: gme_material_details d,

536: NVL(i.grade_control_flag, 'N'),
537: NVL(i.lot_status_enabled, 'N'),
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

Line 574: FROM gme_material_details d,

570: NVL(i.restrict_locators_code, 2),
571: NVL(i.grade_control_flag, 'N'),
572: NVL(i.lot_status_enabled, 'N'),
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

Line 608: gme_material_details d,

604: NVL(i.grade_control_flag, 'N'),
605: NVL(i.lot_status_enabled, 'N'),
606: NVL(i.lot_divisible_flag, 'N')
607: FROM
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

Line 673: FROM gme_material_details d,

669: SELECT d.line_no,
670: i.concatenated_segments,
671: i.inventory_item_id,
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

Line 697: FROM gme_material_details d,

693: SELECT d.line_no,
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

Line 750: FROM gme_material_details d,

746: SELECT d.line_no,
747: i.concatenated_segments,
748: i.inventory_item_id,
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

Line 775: FROM gme_material_details d,

771: SELECT d.line_no,
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

Line 828: FROM gme_material_details d,

824: SELECT d.line_no,
825: i.concatenated_segments,
826: i.inventory_item_id,
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

Line 853: FROM gme_material_details d,

849: SELECT d.line_no,
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

Line 950: gme_material_details d

946: s.batchstep_id
947: FROM gme_batch_steps s,
948: gme_batch_step_items i,
949: gmd_operations o,
950: gme_material_details d
951: WHERE
952: i.batch_id = p_batch_id
953: AND s.batch_id = i.batch_id
954: AND i.batchstep_id = s.batchstep_id

Line 1001: gme_material_details d

997: s.batchstep_id
998: FROM gme_batch_steps s,
999: gme_batch_step_items i,
1000: gmd_operations o,
1001: gme_material_details d
1002: WHERE
1003: i.batch_id = p_batch_id
1004: AND s.batch_id = i.batch_id
1005: AND i.batchstep_id = s.batchstep_id

Line 1052: gme_material_details d

1048: s.batchstep_id
1049: FROM gme_batch_steps s,
1050: gme_batch_step_items i,
1051: gmd_operations o,
1052: gme_material_details d
1053: WHERE
1054: i.batch_id = p_batch_id
1055: AND s.batch_id = i.batch_id
1056: AND i.batchstep_id = s.batchstep_id

Line 1251: FROM gme_material_details d,

1247: NVL(i.restrict_locators_code, 2),
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

Line 1279: gme_material_details d,

1275: NVL(i.grade_control_flag, 'N'),
1276: NVL(i.lot_status_enabled, 'N'),
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

Line 1349: FROM gme_material_details d,

1345: NVL(i.restrict_locators_code, 2),
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

Line 1378: gme_material_details d,

1374: NVL(i.grade_control_flag, 'N'),
1375: NVL(i.lot_status_enabled, 'N'),
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

Line 1460: FROM gme_material_details d,

1456: NVL(i.restrict_locators_code, 2),
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

Line 1488: gme_material_details d,

1484: NVL(i.grade_control_flag, 'N'),
1485: NVL(i.lot_status_enabled, 'N'),
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

Line 1522: FROM gme_material_details d,

1518: NVL(i.restrict_locators_code, 2),
1519: NVL(i.grade_control_flag, 'N'),
1520: NVL(i.lot_status_enabled, 'N'),
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

Line 1556: gme_material_details d,

1552: NVL(i.grade_control_flag, 'N'),
1553: NVL(i.lot_status_enabled, 'N'),
1554: NVL(i.lot_divisible_flag, 'N')
1555: FROM
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

Line 1647: FROM gme_material_details d,

1643: NVL(i.restrict_locators_code, 2),
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

Line 1675: gme_material_details d,

1671: NVL(i.grade_control_flag, 'N'),
1672: NVL(i.lot_status_enabled, 'N'),
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

Line 1710: FROM gme_material_details d,

1706: NVL(i.restrict_locators_code, 2),
1707: NVL(i.grade_control_flag, 'N'),
1708: NVL(i.lot_status_enabled, 'N'),
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

Line 1744: gme_material_details d,

1740: NVL(i.grade_control_flag, 'N'),
1741: NVL(i.lot_status_enabled, 'N'),
1742: NVL(i.lot_divisible_flag, 'N')
1743: FROM
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

Line 1837: FROM gme_material_details d,

1833: NVL(i.restrict_locators_code, 2),
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

Line 1866: gme_material_details d,

1862: NVL(i.grade_control_flag, 'N'),
1863: NVL(i.lot_status_enabled, 'N'),
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

Line 1901: FROM gme_material_details d,

1897: NVL(i.restrict_locators_code, 2),
1898: NVL(i.grade_control_flag, 'N'),
1899: NVL(i.lot_status_enabled, 'N'),
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

Line 1936: gme_material_details d,

1932: NVL(i.grade_control_flag, 'N'),
1933: NVL(i.lot_status_enabled, 'N'),
1934: NVL(i.lot_divisible_flag, 'N')
1935: FROM
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

Line 2028: FROM gme_material_details d,

2024: NVL(i.restrict_locators_code, 2),
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

Line 2056: gme_material_details d,

2052: NVL(i.grade_control_flag, 'N'),
2053: NVL(i.lot_status_enabled, 'N'),
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

Line 2091: FROM gme_material_details d,

2087: NVL(i.restrict_locators_code, 2),
2088: NVL(i.grade_control_flag, 'N'),
2089: NVL(i.lot_status_enabled, 'N'),
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

Line 2126: gme_material_details d,

2122: NVL(i.grade_control_flag, 'N'),
2123: NVL(i.lot_status_enabled, 'N'),
2124: NVL(i.lot_divisible_flag, 'N')
2125: FROM
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

Line 3356: FROM gme_material_details m,

3352: lo.lot_number,
3353: NVL(quantity, 0),
3354: lo.pending_product_lot_id,
3355: NVL(m.locator_id,-1)
3356: FROM gme_material_details m,
3357: gme_pending_product_lots lo,
3358: wms_item_locations_kfv loc,
3359: mtl_lot_numbers mln
3360: WHERE m.batch_id = lo.batch_id

Line 3461: FROM mtl_lot_numbers l, gme_material_details d

3457: BEGIN
3458:
3459: OPEN x_lot_num_lov FOR
3460: SELECT lot_number
3461: FROM mtl_lot_numbers l, gme_material_details d
3462: WHERE l.inventory_item_id = d.inventory_item_id
3463: AND l.organization_id = d.organization_id
3464: AND d.material_detail_id = p_material_detail_id
3465: AND l.lot_number LIKE (p_lot_number)

Line 3468: FROM mtl_lot_numbers l, gme_material_details d

3464: AND d.material_detail_id = p_material_detail_id
3465: AND l.lot_number LIKE (p_lot_number)
3466: UNION
3467: SELECT parent_lot_number
3468: FROM mtl_lot_numbers l, gme_material_details d
3469: WHERE l.inventory_item_id = d.inventory_item_id
3470: AND l.organization_id = d.organization_id
3471: AND d.material_detail_id = p_material_detail_id
3472: AND l.parent_lot_number LIKE (p_lot_number)

Line 3608: gme_material_details d,

3604: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3605: meaning,
3606: d.line_type
3607: FROM gme_batch_header h,
3608: gme_material_details d,
3609: gme_batch_step_items si,
3610: gme_batch_steps s,
3611: gem_lookups lkup
3612: WHERE h.organization_id = p_organization_id

Line 3635: gme_material_details d,

3631: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3632: meaning,
3633: d.line_type
3634: FROM gme_batch_header h,
3635: gme_material_details d,
3636: gem_lookups lkup
3637: WHERE h.organization_id = p_organization_id
3638: AND h.batch_id = p_batch_id
3639: AND h.batch_id = d.batch_id

Line 3702: gme_material_details d,

3698: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3699: meaning,
3700: d.line_type
3701: FROM gme_batch_header h,
3702: gme_material_details d,
3703: gme_batch_step_items si,
3704: gme_batch_steps s,
3705: gem_lookups lkup
3706: WHERE h.organization_id = p_organization_id

Line 3730: gme_material_details d,

3726: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3727: meaning,
3728: d.line_type
3729: FROM gme_batch_header h,
3730: gme_material_details d,
3731: gem_lookups lkup
3732: WHERE h.organization_id = p_organization_id
3733: AND h.batch_id = p_batch_id
3734: AND h.batch_id = d.batch_id