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 1318: * It retrieves this info from wms_LPN_contents table

1314:
1315: /****************************************************
1316: * This procedure populates the data structure that
1317: * stores received lot quantity.
1318: * It retrieves this info from wms_LPN_contents table
1319: ****************************************************/
1320: PROCEDURE populate_lot_rec(
1321: p_lot_number IN VARCHAR2
1322: , p_primary_qty IN NUMBER

Line 4266: FROM wms_lpn_contents wlpnc

4262:
4263: BEGIN
4264: SELECT cost_group_id
4265: INTO l_rcv_transaction_rec.cost_group_id
4266: FROM wms_lpn_contents wlpnc
4267: WHERE organization_id = p_organization_id
4268: AND parent_lpn_id = p_lpn_id
4269: AND wlpnc.inventory_item_id = p_item_id
4270: AND EXISTS(SELECT 1

Line 4280: UPDATE wms_lpn_contents wlpnc

4276: l_rcv_transaction_rec.cost_group_id := NULL;
4277: END;
4278:
4279: IF l_rcv_transaction_rec.cost_group_id IS NULL THEN
4280: UPDATE wms_lpn_contents wlpnc
4281: SET cost_group_id = NULL
4282: WHERE organization_id = p_organization_id
4283: AND parent_lpn_id = p_from_lpn_id
4284: AND wlpnc.inventory_item_id = p_item_id

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

4846: , lpnc.lot_number
4847: , lpn.organization_id
4848: , msi.serial_number_control_code
4849: , msi.primary_uom_code
4850: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
4851: WHERE rsh.shipment_header_id = p_shipment_header_id
4852: AND(lpn.source_header_id = rsh.shipment_header_id
4853: OR lpn.source_name = rsh.shipment_num)
4854: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 6592: FROM wms_lpn_contents wlpnc

6588: IF p_lpn IS NOT NULL THEN
6589: BEGIN
6590: SELECT cost_group_id
6591: INTO l_from_cost_group_id
6592: FROM wms_lpn_contents wlpnc
6593: WHERE organization_id = p_org_id
6594: AND parent_lpn_id = p_lpn
6595: AND wlpnc.inventory_item_id = p_item_id
6596: AND Nvl(wlpnc.lot_number,'@@@') = Nvl(l_lot_qty_rec_tb(i).lot_number,Nvl(wlpnc.lot_number,'@@@'))

Line 6725: FROM wms_lpn_contents wlpnc

6721: IF p_lpn IS NOT NULL THEN
6722: BEGIN
6723: SELECT cost_group_id
6724: INTO l_from_cost_group_id
6725: FROM wms_lpn_contents wlpnc
6726: WHERE organization_id = p_org_id
6727: AND parent_lpn_id = p_lpn
6728: AND wlpnc.inventory_item_id = p_item_id
6729: AND EXISTS(

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

8109: , x_msg_data OUT NOCOPY VARCHAR2
8110: ) IS
8111: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8112: SELECT 1
8113: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8114: WHERE (lpn.source_header_id = rsh.shipment_header_id
8115: OR lpn.source_name = rsh.shipment_num)
8116: AND rsh.shipment_header_id = p_shipment_header_id
8117: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)

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

8126:
8127: --Added for Bug 4951745
8128: CURSOR l_curs_remaining_asn_has_lpn IS
8129: SELECT 1
8130: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8131: WHERE (lpn.source_header_id = rsh.shipment_header_id
8132: OR lpn.source_name = rsh.shipment_num)
8133: AND rsh.shipment_header_id = p_shipment_header_id
8134: AND lpn.lpn_id = p_lpn_id

Line 8253: DELETE wms_lpn_contents

8249: x_return_status := fnd_api.g_ret_sts_success;
8250: SAVEPOINT rcv_remove_lpn_cont_sp;
8251:
8252: -- delete the contents of the putaway LPN
8253: DELETE wms_lpn_contents
8254: WHERE parent_lpn_id = p_lpn_id;
8255:
8256: -- clear serial numbers table
8257: UPDATE mtl_serial_numbers

Line 8832: FROM wms_lpn_contents

8828: , l_lpn_context
8829: FROM wms_license_plate_numbers
8830: WHERE lpn_id = l_lpn_id
8831: AND lpn_id IN(SELECT parent_lpn_id
8832: FROM wms_lpn_contents
8833: WHERE parent_lpn_id = l_lpn_id);
8834: END IF;
8835: IF (l_debug = 1) THEN
8836: print_debug('lpn_id: ' || TO_CHAR(l_lpn_id), 1);

Line 8969: FROM wms_lpn_contents

8965: l_lot_number VARCHAR2(80);
8966:
8967: CURSOR lpn_lot_items IS
8968: SELECT distinct inventory_item_id
8969: FROM wms_lpn_contents
8970: WHERE lot_number IS NOT NULL
8971: AND parent_lpn_id = p_lpn_id;
8972:
8973: CURSOR lpn_serial_items IS

Line 9010: UPDATE wms_lpn_contents

9006:
9007: print_debug('item id ' || l_item_id || ' lot code ' || l_lot_code );
9008:
9009: IF (l_lot_code = 1) THEN
9010: UPDATE wms_lpn_contents
9011: SET lot_number = NULL /* 3835398 */
9012: WHERE parent_lpn_id = p_lpn_id
9013: AND inventory_item_id = l_item_id;
9014: END IF;

Line 9045: UPDATE wms_lpn_contents

9041: WHERE lpn_id = p_lpn_id
9042: AND inventory_item_id = l_item_id; /* 3835398 */
9043:
9044: ELSIF (l_serial_code = 1 ) THEN
9045: UPDATE wms_lpn_contents
9046: SET serial_summary_entry = 2
9047: WHERE parent_lpn_id = p_lpn_id
9048: AND inventory_item_id = l_item_id; /* 3835398 */
9049:

Line 9062: UPDATE wms_lpn_contents

9058: END LOOP;
9059:
9060: -- bug# 2814405 end;
9061:
9062: UPDATE wms_lpn_contents
9063: SET organization_id = p_organization_id
9064: WHERE parent_lpn_id = p_lpn_id;
9065:
9066: l_progress := '40';