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_BATCH_STEP_ITEMS

Line 399: FROM gme_batch_step_items i2,

395: AND i.reservable_type = 1
396: AND d.line_no LIKE (p_line_no)
397: AND NOT EXISTS
398: (SELECT 1
399: FROM gme_batch_step_items i2,
400: gme_batch_steps s
401: WHERE i2.batch_id = d.batch_id
402: AND s.batch_id = d.batch_id
403: AND i2.material_detail_id = d.material_detail_id

Line 548: gme_batch_step_items si,

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
552: AND d.batch_id = si.batch_id

Line 583: gme_batch_step_items si,

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
586: WHERE d.batch_id = p_batch_id
587: AND d.batch_id = si.batch_id

Line 647: gme_batch_step_items si,

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
651: d.batch_id = p_batch_id

Line 724: gme_batch_step_items si,

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
728: d.batch_id = p_batch_id

Line 802: gme_batch_step_items si,

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
806: d.batch_id = p_batch_id

Line 873: gme_batch_step_items i,

869: s.batchstep_no,
870: o.oprn_desc,
871: s.batchstep_id
872: FROM gme_batch_steps s,
873: gme_batch_step_items i,
874: gmd_operations o
875: WHERE
876: i.batch_id = p_batch_id
877: AND s.batch_id = i.batch_id

Line 921: gme_batch_step_items i,

917: s.batchstep_no,
918: o.oprn_desc,
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

Line 972: gme_batch_step_items i,

968: s.batchstep_no,
969: o.oprn_desc,
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

Line 1023: gme_batch_step_items i,

1019: s.batchstep_no,
1020: o.oprn_desc,
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

Line 1496: gme_batch_step_items si,

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
1500: AND d.batch_id = si.batch_id

Line 1531: gme_batch_step_items si,

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
1534: WHERE d.batch_id = p_batch_id
1535: AND d.batch_id = si.batch_id

Line 1684: gme_batch_step_items si,

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
1688: AND d.batch_id = si.batch_id

Line 1719: gme_batch_step_items si,

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
1722: WHERE d.batch_id = p_batch_id
1723: AND d.batch_id = si.batch_id

Line 1875: gme_batch_step_items si,

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
1879: AND d.batch_id = si.batch_id

Line 1911: gme_batch_step_items si,

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
1914: WHERE d.batch_id = p_batch_id
1915: AND d.batch_id = si.batch_id

Line 2065: gme_batch_step_items si,

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
2069: AND d.batch_id = si.batch_id

Line 2101: gme_batch_step_items si,

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
2104: WHERE d.batch_id = p_batch_id
2105: AND d.batch_id = si.batch_id

Line 3525: gme_batch_step_items si,

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
3529: AND h.batch_id = p_batch_id

Line 3619: gme_batch_step_items si,

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
3623: AND h.batch_id = p_batch_id