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 3607: FROM wms_lpn_contents wlpnc

3603: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
3604: BEGIN
3605: SELECT cost_group_id
3606: INTO l_rcv_transaction_rec.cost_group_id
3607: FROM wms_lpn_contents wlpnc
3608: WHERE organization_id = p_organization_id
3609: AND parent_lpn_id = p_lpn_id
3610: AND wlpnc.inventory_item_id = p_item_id
3611: AND EXISTS(SELECT 1

Line 3621: UPDATE wms_lpn_contents wlpnc

3617: l_rcv_transaction_rec.cost_group_id := NULL;
3618: END;
3619:
3620: IF l_rcv_transaction_rec.cost_group_id IS NULL THEN
3621: UPDATE wms_lpn_contents wlpnc
3622: SET cost_group_id = NULL
3623: WHERE organization_id = p_organization_id
3624: AND parent_lpn_id = p_lpn_id
3625: AND wlpnc.inventory_item_id = p_item_id

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

4157: , wlpnc.lot_number
4158: , wlpnc.source_line_id
4159: , wlpn.organization_id lpn_org_id
4160: , wlpnc.secondary_quantity --Bug 7656734
4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4162: WHERE rsh.shipment_header_id = p_shipment_header_id
4163: AND (wlpn.source_header_id = rsh.shipment_header_id
4164: OR wlpn.source_name = rsh.shipment_num)
4165: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones