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

Line 2478: FROM wms_lpn_contents wlpnc

2474: l_match_type := 'INTRANSIT SHIPMENT';
2475: BEGIN
2476: SELECT cost_group_id
2477: INTO l_rcv_transaction_rec.cost_group_id
2478: FROM wms_lpn_contents wlpnc
2479: WHERE organization_id = p_organization_id
2480: AND parent_lpn_id = p_lpn_id
2481: AND wlpnc.inventory_item_id = p_item_id
2482: AND exists (SELECT 1

Line 2492: UPDATE wms_lpn_contents wlpnc

2488: l_rcv_transaction_rec.cost_group_id := NULL;
2489: END;
2490:
2491: IF l_rcv_transaction_rec.cost_group_id IS NULL THEN
2492: UPDATE wms_lpn_contents wlpnc
2493: SET cost_group_id = NULL
2494: WHERE organization_id = p_organization_id
2495: AND parent_lpn_id = p_lpn_id
2496: AND wlpnc.inventory_item_id = p_item_id

Line 2799: FROM wms_lpn_contents wlpnc

2795: wlpnc.quantity,
2796: wlpnc.uom_code,
2797: wlpnc.lot_number,
2798: wlpnc.source_line_id
2799: FROM wms_lpn_contents wlpnc
2800: , wms_license_plate_numbers wlpn
2801: , mtl_system_items msi
2802: , rcv_shipment_headers rsh
2803: WHERE rsh.shipment_header_id = p_shipment_header_id