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_LPN_MOBILE_TXN dependencies on GME_MATERIAL_DETAILS

Line 422: FROM gme_material_details

418:
419: BEGIN
420:
421: SELECT COUNT(material_detail_id) INTO x_prod_count
422: FROM gme_material_details
423: WHERE batch_id = p_batch_id
424: AND organization_id = p_org_id
425: AND line_type IN (1, 2);
426:

Line 465: FROM gme_material_details gmd, mtl_item_locations_kfv mil, gme_batch_header gbh, mtl_system_items_kfv msi

461: IS
462:
463: CURSOR Cur_sub_loc IS
464: SELECT gbh.batch_no, msi.concatenated_segments, gmd.subinventory, mil.concatenated_segments, inventory_location_id
465: FROM gme_material_details gmd, mtl_item_locations_kfv mil, gme_batch_header gbh, mtl_system_items_kfv msi
466: WHERE gmd.organization_id = p_org_id
467: AND gmd.batch_id = p_batch_id
468: AND gmd.material_detail_id = p_material_dtl_id
469: AND gmd.locator_id = mil.inventory_location_id