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 4034: AND WMS_RETURN_SV.GET_LPN_MARKED_STATUS(wlpn.lpn_id, wlpn.organization_id)='FULL'

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

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

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