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 386: FROM gme_material_details d,

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

Line 485: FROM gme_material_details d,

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

Line 513: gme_material_details d,

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

Line 547: FROM gme_material_details d,

543: NVL(i.restrict_locators_code, 2),
544: NVL(i.grade_control_flag, 'N'),
545: NVL(i.lot_status_enabled, 'N'),
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

Line 581: gme_material_details d,

577: NVL(i.grade_control_flag, 'N'),
578: NVL(i.lot_status_enabled, 'N'),
579: NVL(i.lot_divisible_flag, 'N')
580: FROM
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

Line 646: FROM gme_material_details d,

642: SELECT d.line_no,
643: i.concatenated_segments,
644: i.inventory_item_id,
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

Line 670: FROM gme_material_details d,

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

Line 723: FROM gme_material_details d,

719: SELECT d.line_no,
720: i.concatenated_segments,
721: i.inventory_item_id,
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

Line 748: FROM gme_material_details d,

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

Line 801: FROM gme_material_details d,

797: SELECT d.line_no,
798: i.concatenated_segments,
799: i.inventory_item_id,
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

Line 826: FROM gme_material_details d,

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

Line 923: gme_material_details d

919: s.batchstep_id
920: FROM gme_batch_steps s,
921: gme_batch_step_items i,
922: gmd_operations o,
923: gme_material_details d
924: WHERE
925: i.batch_id = p_batch_id
926: AND s.batch_id = i.batch_id
927: AND i.batchstep_id = s.batchstep_id

Line 974: gme_material_details d

970: s.batchstep_id
971: FROM gme_batch_steps s,
972: gme_batch_step_items i,
973: gmd_operations o,
974: gme_material_details d
975: WHERE
976: i.batch_id = p_batch_id
977: AND s.batch_id = i.batch_id
978: AND i.batchstep_id = s.batchstep_id

Line 1025: gme_material_details d

1021: s.batchstep_id
1022: FROM gme_batch_steps s,
1023: gme_batch_step_items i,
1024: gmd_operations o,
1025: gme_material_details d
1026: WHERE
1027: i.batch_id = p_batch_id
1028: AND s.batch_id = i.batch_id
1029: AND i.batchstep_id = s.batchstep_id

Line 1224: FROM gme_material_details d,

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

Line 1252: gme_material_details d,

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

Line 1322: FROM gme_material_details d,

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

Line 1351: gme_material_details d,

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

Line 1433: FROM gme_material_details d,

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

Line 1461: gme_material_details d,

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

Line 1495: FROM gme_material_details d,

1491: NVL(i.restrict_locators_code, 2),
1492: NVL(i.grade_control_flag, 'N'),
1493: NVL(i.lot_status_enabled, 'N'),
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

Line 1529: gme_material_details d,

1525: NVL(i.grade_control_flag, 'N'),
1526: NVL(i.lot_status_enabled, 'N'),
1527: NVL(i.lot_divisible_flag, 'N')
1528: FROM
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

Line 1620: FROM gme_material_details d,

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

Line 1648: gme_material_details d,

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

Line 1683: FROM gme_material_details d,

1679: NVL(i.restrict_locators_code, 2),
1680: NVL(i.grade_control_flag, 'N'),
1681: NVL(i.lot_status_enabled, 'N'),
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

Line 1717: gme_material_details d,

1713: NVL(i.grade_control_flag, 'N'),
1714: NVL(i.lot_status_enabled, 'N'),
1715: NVL(i.lot_divisible_flag, 'N')
1716: FROM
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

Line 1810: FROM gme_material_details d,

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

Line 1839: gme_material_details d,

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

Line 1874: FROM gme_material_details d,

1870: NVL(i.restrict_locators_code, 2),
1871: NVL(i.grade_control_flag, 'N'),
1872: NVL(i.lot_status_enabled, 'N'),
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

Line 1909: gme_material_details d,

1905: NVL(i.grade_control_flag, 'N'),
1906: NVL(i.lot_status_enabled, 'N'),
1907: NVL(i.lot_divisible_flag, 'N')
1908: FROM
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

Line 2001: FROM gme_material_details d,

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

Line 2029: gme_material_details d,

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

Line 2064: FROM gme_material_details d,

2060: NVL(i.restrict_locators_code, 2),
2061: NVL(i.grade_control_flag, 'N'),
2062: NVL(i.lot_status_enabled, 'N'),
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

Line 2099: gme_material_details d,

2095: NVL(i.grade_control_flag, 'N'),
2096: NVL(i.lot_status_enabled, 'N'),
2097: NVL(i.lot_divisible_flag, 'N')
2098: FROM
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

Line 3272: FROM gme_material_details m,

3268: lo.lot_number,
3269: NVL(quantity, 0),
3270: lo.pending_product_lot_id,
3271: NVL(m.locator_id,-1)
3272: FROM gme_material_details m,
3273: gme_pending_product_lots lo,
3274: wms_item_locations_kfv loc,
3275: mtl_lot_numbers mln
3276: WHERE m.batch_id = lo.batch_id

Line 3377: FROM mtl_lot_numbers l, gme_material_details d

3373: BEGIN
3374:
3375: OPEN x_lot_num_lov FOR
3376: SELECT lot_number
3377: FROM mtl_lot_numbers l, gme_material_details d
3378: WHERE l.inventory_item_id = d.inventory_item_id
3379: AND l.organization_id = d.organization_id
3380: AND d.material_detail_id = p_material_detail_id
3381: AND l.lot_number LIKE (p_lot_number)

Line 3384: FROM mtl_lot_numbers l, gme_material_details d

3380: AND d.material_detail_id = p_material_detail_id
3381: AND l.lot_number LIKE (p_lot_number)
3382: UNION
3383: SELECT parent_lot_number
3384: FROM mtl_lot_numbers l, gme_material_details d
3385: WHERE l.inventory_item_id = d.inventory_item_id
3386: AND l.organization_id = d.organization_id
3387: AND d.material_detail_id = p_material_detail_id
3388: AND l.parent_lot_number LIKE (p_lot_number)

Line 3524: gme_material_details d,

3520: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3521: meaning,
3522: d.line_type
3523: FROM gme_batch_header h,
3524: gme_material_details d,
3525: gme_batch_step_items si,
3526: gme_batch_steps s,
3527: gem_lookups lkup
3528: WHERE h.organization_id = p_organization_id

Line 3551: gme_material_details d,

3547: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3548: meaning,
3549: d.line_type
3550: FROM gme_batch_header h,
3551: gme_material_details d,
3552: gem_lookups lkup
3553: WHERE h.organization_id = p_organization_id
3554: AND h.batch_id = p_batch_id
3555: AND h.batch_id = d.batch_id

Line 3618: gme_material_details d,

3614: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3615: meaning,
3616: d.line_type
3617: FROM gme_batch_header h,
3618: gme_material_details d,
3619: gme_batch_step_items si,
3620: gme_batch_steps s,
3621: gem_lookups lkup
3622: WHERE h.organization_id = p_organization_id

Line 3646: gme_material_details d,

3642: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3643: meaning,
3644: d.line_type
3645: FROM gme_batch_header h,
3646: gme_material_details d,
3647: gem_lookups lkup
3648: WHERE h.organization_id = p_organization_id
3649: AND h.batch_id = p_batch_id
3650: AND h.batch_id = d.batch_id