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.WMS_LPN_LOVS dependencies on WMS_RETURN_SV

Line 4035: AND WMS_RETURN_SV.GET_LPN_MARKED_STATUS(wlpn.lpn_id, wlpn.organization_id)='FULL'

4031: NVL(wlpn.content_volume, 0)
4032: FROM wms_license_plate_numbers wlpn
4033: WHERE wlpn.license_plate_number LIKE (p_lpn)
4034: AND wlpn.organization_id = p_org_id
4035: AND WMS_RETURN_SV.GET_LPN_MARKED_STATUS(wlpn.lpn_id, wlpn.organization_id)='FULL'
4036: UNION ALL
4037: SELECT wlpn.license_plate_number,
4038: wlpn.lpn_id,
4039: NVL(wlpn.inventory_item_id, 0),

Line 4055: AND WMS_RETURN_SV.GET_LPN_MARKED_STATUS(wlpn.lpn_id, wlpn.organization_id)='PARTIAL'

4051: NVL(wlpn.content_volume, 0)
4052: FROM wms_license_plate_numbers wlpn
4053: WHERE wlpn.license_plate_number LIKE (p_lpn)
4054: AND wlpn.organization_id = p_org_id
4055: AND WMS_RETURN_SV.GET_LPN_MARKED_STATUS(wlpn.lpn_id, wlpn.organization_id)='PARTIAL'
4056: ORDER BY 1;
4057:
4058: END GET_RETURN_LPN;
4059: --"Returns"