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_STD_RCPT_APIS dependencies on WMS_LPN_CONTENTS

Line 1360: * It retrieves this info from wms_LPN_contents table

1356:
1357: /****************************************************
1358: * This procedure populates the data structure that
1359: * stores received lot quantity.
1360: * It retrieves this info from wms_LPN_contents table
1361: ****************************************************/
1362: PROCEDURE populate_lot_rec(
1363: p_lot_number IN VARCHAR2
1364: , p_primary_qty IN NUMBER

Line 4522: FROM wms_lpn_contents wlpnc

4518:
4519: BEGIN
4520: SELECT cost_group_id
4521: INTO l_rcv_transaction_rec.cost_group_id
4522: FROM wms_lpn_contents wlpnc
4523: WHERE organization_id = p_organization_id
4524: AND parent_lpn_id = p_lpn_id
4525: AND wlpnc.inventory_item_id = p_item_id
4526: AND EXISTS(SELECT 1

Line 4536: UPDATE wms_lpn_contents wlpnc

4532: l_rcv_transaction_rec.cost_group_id := NULL;
4533: END;
4534:
4535: IF l_rcv_transaction_rec.cost_group_id IS NULL THEN
4536: UPDATE wms_lpn_contents wlpnc
4537: SET cost_group_id = NULL
4538: WHERE organization_id = p_organization_id
4539: AND parent_lpn_id = p_from_lpn_id
4540: AND wlpnc.inventory_item_id = p_item_id

Line 5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh

5114: , lpn.organization_id
5115: , msi.serial_number_control_code
5116: , msi.primary_uom_code
5117: , lpnc.secondary_quantity -- Bug 7708998
5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
5119: WHERE rsh.shipment_header_id = p_shipment_header_id
5120: AND((lpn.source_header_id = rsh.shipment_header_id)
5121: OR (lpn.source_header_id IS NULL AND lpn.source_name = rsh.shipment_num)) --BUG14846625/16711363
5122: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 6947: FROM wms_lpn_contents wlpnc

6943: IF p_lpn IS NOT NULL THEN
6944: BEGIN
6945: SELECT cost_group_id
6946: INTO l_from_cost_group_id
6947: FROM wms_lpn_contents wlpnc
6948: WHERE organization_id = p_org_id
6949: AND parent_lpn_id = p_lpn
6950: AND wlpnc.inventory_item_id = p_item_id
6951: AND Nvl(wlpnc.lot_number,'@@@') = Nvl(l_lot_qty_rec_tb(i).lot_number,Nvl(wlpnc.lot_number,'@@@'))

Line 7080: FROM wms_lpn_contents wlpnc

7076: IF p_lpn IS NOT NULL THEN
7077: BEGIN
7078: SELECT cost_group_id
7079: INTO l_from_cost_group_id
7080: FROM wms_lpn_contents wlpnc
7081: WHERE organization_id = p_org_id
7082: AND parent_lpn_id = p_lpn
7083: AND wlpnc.inventory_item_id = p_item_id
7084: AND EXISTS(

Line 8509: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8505: , x_msg_data OUT NOCOPY VARCHAR2
8506: ) IS
8507: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8508: SELECT 1
8509: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8510: WHERE (lpn.source_header_id = rsh.shipment_header_id
8511: OR lpn.source_name = rsh.shipment_num)
8512: AND rsh.shipment_header_id = p_shipment_header_id
8513: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)

Line 8526: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8522:
8523: --Added for Bug 4951745
8524: CURSOR l_curs_remaining_asn_has_lpn IS
8525: SELECT 1
8526: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8527: WHERE (lpn.source_header_id = rsh.shipment_header_id
8528: OR lpn.source_name = rsh.shipment_num)
8529: AND rsh.shipment_header_id = p_shipment_header_id
8530: AND lpn.lpn_id = p_lpn_id

Line 8649: DELETE wms_lpn_contents

8645: x_return_status := fnd_api.g_ret_sts_success;
8646: SAVEPOINT rcv_remove_lpn_cont_sp;
8647:
8648: -- delete the contents of the putaway LPN
8649: DELETE wms_lpn_contents
8650: WHERE parent_lpn_id = p_lpn_id;
8651:
8652: -- clear serial numbers table
8653: UPDATE mtl_serial_numbers

Line 9228: FROM wms_lpn_contents

9224: , l_lpn_context
9225: FROM wms_license_plate_numbers
9226: WHERE lpn_id = l_lpn_id
9227: AND lpn_id IN(SELECT parent_lpn_id
9228: FROM wms_lpn_contents
9229: WHERE parent_lpn_id = l_lpn_id);
9230: END IF;
9231: IF (l_debug = 1) THEN
9232: print_debug('lpn_id: ' || TO_CHAR(l_lpn_id), 1);

Line 9365: FROM wms_lpn_contents

9361: l_lot_number VARCHAR2(80);
9362:
9363: CURSOR lpn_lot_items IS
9364: SELECT distinct inventory_item_id
9365: FROM wms_lpn_contents
9366: WHERE lot_number IS NOT NULL
9367: AND parent_lpn_id = p_lpn_id;
9368:
9369: CURSOR lpn_serial_items IS

Line 9406: UPDATE wms_lpn_contents

9402:
9403: print_debug('item id ' || l_item_id || ' lot code ' || l_lot_code );
9404:
9405: IF (l_lot_code = 1) THEN
9406: UPDATE wms_lpn_contents
9407: SET lot_number = NULL /* 3835398 */
9408: WHERE parent_lpn_id = p_lpn_id
9409: AND inventory_item_id = l_item_id;
9410: END IF;

Line 9441: UPDATE wms_lpn_contents

9437: WHERE lpn_id = p_lpn_id
9438: AND inventory_item_id = l_item_id; /* 3835398 */
9439:
9440: ELSIF (l_serial_code = 1 ) THEN
9441: UPDATE wms_lpn_contents
9442: SET serial_summary_entry = 2
9443: WHERE parent_lpn_id = p_lpn_id
9444: AND inventory_item_id = l_item_id; /* 3835398 */
9445:

Line 9458: UPDATE wms_lpn_contents

9454: END LOOP;
9455:
9456: -- bug# 2814405 end;
9457:
9458: UPDATE wms_lpn_contents
9459: SET organization_id = p_organization_id
9460: WHERE parent_lpn_id = p_lpn_id;
9461:
9462: l_progress := '40';