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.INV_RCV_DIR_RCPT_APIS dependencies on WMS_LPN_CONTENTS

Line 3503: FROM wms_lpn_contents wlpnc

3499: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3500: BEGIN
3501: SELECT cost_group_id
3502: INTO l_rcv_transaction_rec.cost_group_id
3503: FROM wms_lpn_contents wlpnc
3504: WHERE organization_id = p_organization_id
3505: AND parent_lpn_id = p_lpn_id
3506: AND wlpnc.inventory_item_id = p_item_id
3507: AND EXISTS(SELECT 1

Line 3517: UPDATE wms_lpn_contents wlpnc

3513: l_rcv_transaction_rec.cost_group_id := NULL;
3514: END;
3515:
3516: IF l_rcv_transaction_rec.cost_group_id IS NULL THEN
3517: UPDATE wms_lpn_contents wlpnc
3518: SET cost_group_id = NULL
3519: WHERE organization_id = p_organization_id
3520: AND parent_lpn_id = p_lpn_id
3521: AND wlpnc.inventory_item_id = p_item_id

Line 4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh

4015: , wlpnc.uom_code
4016: , wlpnc.lot_number
4017: , wlpnc.source_line_id
4018: , wlpn.organization_id lpn_org_id
4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4020: WHERE rsh.shipment_header_id = p_shipment_header_id
4021: AND (wlpn.source_header_id = rsh.shipment_header_id
4022: OR wlpn.source_name = rsh.shipment_num)
4023: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones