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.WMS_RETURN_SV dependencies on RCV_TRANSACTIONS

Line 44: , rcv_transactions rt

40: , rsl.from_organization_id
41: , rsl.asn_line_flag
42: FROM rcv_shipment_lines rsl
43: , mtl_system_items msi
44: , rcv_transactions rt
45: WHERE rt.group_id = p_group_id
46: AND (rt.transaction_type = 'CORRECT'
47: -- return to receiving is also created for a rtv/rtc txn.
48: -- from inventory. But for that we dont want to create

Line 82: , rcv_transactions rt

78: , rsl.asn_line_flag
79: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
80: FROM mtl_transaction_lots_temp mtlt
81: , rcv_shipment_lines rsl
82: , rcv_transactions rt
83: , mtl_system_items msi
84: WHERE rt.group_id = p_group_id
85: AND (mtlt.transaction_temp_id (+) = rt.interface_transaction_id
86: -- Since mtlt is deleted for a correction record for a

Line 94: FROM rcv_transactions rt1

90: AND NOT (rt.quantity > 0
91: AND rt.transaction_type = 'CORRECT'
92: AND msi.lot_control_code = 2
93: AND exists (SELECT 1
94: FROM rcv_transactions rt1
95: WHERE rt1.transaction_id = rt.parent_transaction_id
96: AND rt1.transaction_type = 'DELIVER')))
97: AND (rt.transaction_type = 'CORRECT'
98: -- select the return_to_receiving txn created for the

Line 110: FROM rcv_transactions rt2

106: -- to eliminate the row being selected for a rtv
107: -- from inventory as for those we dont need to update
108: -- the move order line.
109: AND NOT exists (SELECT 1
110: FROM rcv_transactions rt2
111: WHERE rt2.interface_transaction_id = rt.interface_transaction_id
112: AND rt2.transaction_type = 'RETURN TO RECEIVING'
113: AND rt2.group_id = p_group_id)))
114: AND rt.user_entered_flag = 'Y'

Line 140: , rcv_transactions rt

136: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
137: FROM mtl_material_transactions mmt
138: , mtl_transaction_lot_numbers mtln
139: , rcv_shipment_lines rsl
140: , rcv_transactions rt
141: , mtl_system_items msi
142: WHERE rt.group_id = p_group_id
143: AND mmt.rcv_transaction_id = rt.transaction_id
144: AND mmt.transaction_id = mtln.transaction_id

Line 152: FROM rcv_transactions rt1

148: AND rt.quantity > 0
149: AND rt.transaction_type = 'CORRECT'
150: AND msi.lot_control_code = 2
151: AND exists (SELECT 1
152: FROM rcv_transactions rt1
153: WHERE rt1.transaction_id = rt.parent_transaction_id
154: AND rt1.transaction_type = 'DELIVER')
155: AND rt.user_entered_flag = 'Y'
156: AND rsl.shipment_line_id = rt.shipment_line_id

Line 184: FROM mtl_txn_request_lines mol, rcv_transactions rt

180: , rt.quantity rt_quantity
181: , rt.primary_unit_of_measure
182: , rt.unit_of_measure
183: , rt.organization_id
184: FROM mtl_txn_request_lines mol, rcv_transactions rt
185: WHERE rt.transaction_id = l_transaction_id
186: AND mol.organization_id = v_organization_id
187: AND rt.organization_id = v_organization_id
188: AND mol.reference_id = v_reference_id

Line 248: FROM rcv_transactions

244: l_lpn_id := i.transfer_lpn_id;
245: -- Bug #1939258
246: SELECT transaction_type
247: INTO l_rtr_parent_txn_type
248: FROM rcv_transactions
249: WHERE transaction_id = i.parent_transaction_id;
250: IF (l_debug = 1) THEN
251: print_debug('parent transaction_type for return to receiving='|| l_rtr_parent_txn_type);
252: END IF;

Line 258: FROM rcv_transactions

254: ELSIF i.transaction_type = 'CORRECT' THEN
255:
256: l_progress := '30';
257: SELECT transaction_type into l_parent_transaction_type
258: FROM rcv_transactions
259: WHERE transaction_id = i.parent_transaction_id;
260:
261: IF (l_debug = 1) THEN
262: print_debug('correction parent transaction_type='|| l_parent_transaction_type);

Line 387: FROM rcv_transactions rt

383: BEGIN
384: l_progress := '130';
385: SELECT transaction_type
386: INTO l_grand_parent_txn_type
387: FROM rcv_transactions rt
388: WHERE transaction_id = (SELECT rt2.parent_transaction_id
389: FROM rcv_transactions rt2
390: WHERE rt2.transaction_id = i.parent_transaction_id);
391: EXCEPTION

Line 389: FROM rcv_transactions rt2

385: SELECT transaction_type
386: INTO l_grand_parent_txn_type
387: FROM rcv_transactions rt
388: WHERE transaction_id = (SELECT rt2.parent_transaction_id
389: FROM rcv_transactions rt2
390: WHERE rt2.transaction_id = i.parent_transaction_id);
391: EXCEPTION
392: WHEN OTHERS THEN
393: IF (l_debug = 1) THEN

Line 530: FROM rcv_transactions

526:
527: l_lpn_id := i.lpn_id;
528:
529: SELECT transaction_type INTO l_rtv_parent_txn_type
530: FROM rcv_transactions
531: WHERE transaction_id = i.parent_transaction_id;
532: l_progress := '210';
533: IF (l_debug = 1) THEN
534: print_debug('RTV parent txn type='|| l_rtv_parent_txn_type);

Line 554: FROM rcv_transactions

550: ELSIF i.transaction_type = 'CORRECT' THEN
551:
552: l_progress := '250';
553: SELECT transaction_type into l_parent_transaction_type
554: FROM rcv_transactions
555: WHERE transaction_id = i.parent_transaction_id;
556: l_progress := '260';
557: IF (l_debug = 1) THEN
558: print_debug('parent transaction_type='|| l_parent_transaction_type);

Line 720: FROM rcv_transactions rt

716: BEGIN
717: l_progress := '380';
718: SELECT transaction_type
719: INTO l_grand_parent_txn_type
720: FROM rcv_transactions rt
721: WHERE transaction_id = (SELECT rt2.parent_transaction_id
722: FROM rcv_transactions rt2
723: WHERE rt2.transaction_id = i.parent_transaction_id);
724: EXCEPTION

Line 722: FROM rcv_transactions rt2

718: SELECT transaction_type
719: INTO l_grand_parent_txn_type
720: FROM rcv_transactions rt
721: WHERE transaction_id = (SELECT rt2.parent_transaction_id
722: FROM rcv_transactions rt2
723: WHERE rt2.transaction_id = i.parent_transaction_id);
724: EXCEPTION
725: WHEN OTHERS THEN
726: IF (l_debug = 1) THEN

Line 1150: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt

1146: , wlpnc.COST_GROUP_ID cg_id
1147: , rt.destination_type_code
1148: , rt.quantity rt_quantity
1149: , rt.parent_transaction_id
1150: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt
1151: WHERE rt.group_id = p_group_id
1152: AND (((( rt.transaction_type = 'RETURN TO VENDOR'
1153: AND rt.lpn_id IS NOT NULL -- 3603808
1154: )

Line 1164: FROM rcv_transactions rt2

1160: -- to eliminate the row being selected for a rtv
1161: -- from inventory as pack unpack for that is already
1162: -- taken care of in inventory tm.
1163: AND NOT exists (SELECT 1
1164: FROM rcv_transactions rt2
1165: WHERE rt2.interface_transaction_id = rt.interface_transaction_id
1166: AND rt2.transaction_type = 'RETURN TO RECEIVING'
1167: AND rt2.group_id = p_group_id))
1168: OR (rt.transaction_type = 'CORRECT')

Line 1184: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions rt

1180: msn.inventory_item_id, msn.revision, msn.lot_number,
1181: msn.serial_number, to_number(null) quantity, wlpnc.uom_code uom_code, rt.transaction_type,
1182: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1183: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1184: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions rt
1185: WHERE msn.last_txn_source_name = rt.transaction_type
1186: AND msn.last_txn_source_id = rt.interface_transaction_id
1187: AND rt.group_id = p_group_id
1188: AND (((( rt.transaction_type = 'RETURN TO VENDOR' -- 3603808

Line 1197: FROM rcv_transactions rt2

1193: -- AND rt.transfer_lpn_id IS NOT NULL fix for 4389811
1194: AND rt.lpn_id IS NOT NULL
1195: ))
1196: AND NOT exists (SELECT 1
1197: FROM rcv_transactions rt2
1198: WHERE rt2.interface_transaction_id = rt.interface_transaction_id
1199: AND rt2.transaction_type = 'RETURN TO RECEIVING'
1200: AND rt2.group_id = p_group_id))
1201: OR (rt.transaction_type = 'CORRECT') OR (rt.transaction_type = 'RETURN TO RECEIVING'

Line 1213: FROM rcv_transactions_interface rti

1209: -- Also select for the item_id column in RTI so we can use
1210: -- this in looking up the values in MSN.
1211: CURSOR c_failure IS
1212: SELECT transaction_type, interface_transaction_id, item_id
1213: FROM rcv_transactions_interface rti
1214: WHERE rti.group_id = p_group_id
1215: AND rti.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER','RETURN TO RECEIVING','CORRECT');
1216:
1217: CURSOR c_newly_packed IS

Line 1232: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt

1228: , rti.interface_transaction_id
1229: , rti.destination_type_code
1230: , rti.quantity rti_quantity
1231: , rti.parent_transaction_id
1232: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1233: WHERE rti.group_id = p_group_id
1234: AND rti.transaction_type = 'CORRECT'
1235: AND rt.transaction_id = rti.parent_transaction_id
1236: AND ((rt.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER') AND rti.quantity < 0) OR

Line 1256: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt

1252: , rti.interface_transaction_id
1253: , rti.destination_type_code
1254: , rti.quantity rti_quantity
1255: , rti.parent_transaction_id
1256: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1257: WHERE msn.last_txn_source_name = rti.transaction_type
1258: AND msn.last_txn_source_id = rti.interface_transaction_id
1259: AND rti.group_id = p_group_id
1260: AND rti.transaction_type = 'CORRECT'

Line 1274: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl

1270: msn.inventory_item_id, msn.revision, msn.lot_number,
1271: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1272: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1273: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1274: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1275: WHERE rt.group_id = p_group_id
1276: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1277: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1278: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))

Line 1287: AND exists (SELECT '1' FROM rcv_transactions rt2

1283: AND rsl.shipment_line_id = rt.shipment_line_id
1284: AND msn.inventory_item_id = rsl.item_id
1285: AND rt.user_entered_flag = 'Y'
1286: AND msn.current_status = 4
1287: AND exists (SELECT '1' FROM rcv_transactions rt2
1288: WHERE rt2.transaction_id = rt.parent_transaction_id
1289: AND rt2.transaction_type = 'DELIVER');
1290:
1291: CURSOR c_neg_deliver_ser_lpng IS

Line 1298: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl

1294: msn.inventory_item_id, msn.revision, msn.lot_number,
1295: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1296: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1297: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1298: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1299: WHERE rt.transaction_date >= (Sysdate - 1)
1300: AND rt.lpn_group_id = p_group_id
1301: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1302: OR (rt.transaction_type = 'RETURN TO RECEIVING'

Line 1312: AND exists (SELECT '1' FROM rcv_transactions rt2

1308: AND rsl.shipment_line_id = rt.shipment_line_id
1309: AND msn.inventory_item_id = rsl.item_id
1310: AND rt.user_entered_flag = 'Y'
1311: AND msn.current_status = 4
1312: AND exists (SELECT '1' FROM rcv_transactions rt2
1313: WHERE rt2.transaction_id = rt.parent_transaction_id
1314: AND rt2.transaction_type = 'DELIVER');
1315:
1316: -- Added new cursor to address the Bug 4489361

Line 1324: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl

1320: msn.inventory_item_id, msn.revision, msn.lot_number,
1321: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1322: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1323: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1324: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1325: WHERE rt.group_id = p_group_id
1326: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1327: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1328: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))

Line 1337: AND exists (SELECT '1' FROM rcv_transactions rt2

1333: AND rsl.shipment_line_id = rt.shipment_line_id
1334: AND msn.inventory_item_id = rsl.item_id
1335: AND rt.user_entered_flag = 'Y'
1336: AND msn.current_status = 4
1337: AND exists (SELECT '1' FROM rcv_transactions rt2
1338: WHERE rt2.transaction_id = rt.parent_transaction_id
1339: AND rt2.transaction_type = 'DELIVER');
1340:
1341: ret boolean;

Line 1376: FROM rcv_transactions rt, rcv_shipment_lines rsl

1372: rt.from_subinventory,
1373: rt.from_locator_id,
1374: rt.lpn_id,
1375: rt.quantity
1376: FROM rcv_transactions rt, rcv_shipment_lines rsl
1377: WHERE rt.group_id = p_group_id
1378: AND p_txn_mode <> 'LPN_GROUP'
1379: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')
1380: AND rt.shipment_line_id = rsl.shipment_line_id;

Line 1392: FROM rcv_transactions rt, rcv_shipment_lines rsl

1388: rt.from_subinventory,
1389: rt.from_locator_id,
1390: rt.lpn_id,
1391: rt.quantity
1392: FROM rcv_transactions rt, rcv_shipment_lines rsl
1393: WHERE rt.transaction_date >= (SYSDATE-1)
1394: AND rt.lpn_group_id = p_group_id
1395: AND p_txn_mode = 'LPN_GROUP'
1396: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')

Line 1412: FROM rcv_transactions

1408: -- Bug# 3281512 - Performance Fixes
1409: -- Cursor to get rid of the hash join problem
1410: CURSOR c_interface_txn_id IS
1411: SELECT interface_transaction_id
1412: FROM rcv_transactions
1413: WHERE group_id = p_group_id;
1414: l_interface_txn_id NUMBER;
1415: BEGIN
1416:

Line 1505: FROM rcv_transactions

1501:
1502: BEGIN
1503: SELECT transaction_type, routing_header_id
1504: INTO l_parent_transaction_type, l_routing_header_id
1505: FROM rcv_transactions
1506: WHERE transaction_id = i.parent_transaction_id;
1507: IF (l_debug = 1) THEN
1508: print_debug('l_parent_transaction_type=' || l_parent_transaction_type);
1509: END IF;

Line 2241: rcv_transactions_interface rti,wms_lpn_contents wlc

2237:
2238: BEGIN
2239:
2240: SELECT '1' INTO v_dummy FROM
2241: rcv_transactions_interface rti,wms_lpn_contents wlc
2242: WHERE rti.interface_transaction_id = wlc.source_header_id
2243: AND rti.processing_status_code = 'WSH_INTERFACED'
2244: AND rti.to_organization_id = wlc.organization_id
2245: AND wlc.parent_lpn_id = p_lpn_id

Line 2545: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI

2541: ELSE
2542:
2543: l_position := '0050';
2544: open c_ref for SELECT NULL , NULL , NULL , rti.quantity, wlpnc.cost_group_id, RTI.secondary_quantity sec_qty--13399743
2545: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI
2546: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id
2547: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2548: AND WLPNC.INVENTORY_ITEM_ID = RTI.ITEM_ID
2549: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 2832: SELECT transfer_lpn_id INTO l_lpn_id FROM rcv_transactions_interface

2828:
2829: l_position := '0010';
2830: x_return_status := FND_API.G_RET_STS_SUCCESS;
2831:
2832: SELECT transfer_lpn_id INTO l_lpn_id FROM rcv_transactions_interface
2833: WHERE interface_transaction_id = p_interface_txn_id;
2834:
2835: OPEN c_lpn_exist(l_lpn_id);
2836: FETCH c_lpn_exist INTO l_wdd_exists;

Line 3085: FROM rcv_transactions_interface rti,wms_license_plate_numbers wlpn

3081:
3082: BEGIN
3083:
3084: SELECT 1 INTO v_dummy
3085: FROM rcv_transactions_interface rti,wms_license_plate_numbers wlpn
3086: WHERE rti.interface_transaction_id = p_rcv_trx_interface_id
3087: AND rti.processing_status_code = 'WSH_INTERFACED'
3088: AND rti.transfer_lpn_id = wlpn.lpn_id
3089: AND wlpn.lpn_context = 5

Line 3109: UPDATE rcv_transactions_interface SET transfer_lpn_id = l_lpn_id

3105: END IF;
3106:
3107: l_position := '0012';
3108:
3109: UPDATE rcv_transactions_interface SET transfer_lpn_id = l_lpn_id
3110: WHERE
3111: interface_transaction_id = p_rcv_trx_interface_id
3112: AND processing_status_code = 'WSH_INTERFACED' ;
3113:

Line 3403: FROM rcv_transactions_interface

3399: CURSOR c_get_lpnrti
3400: IS
3401: SELECT transfer_lpn_id,
3402: SUM(quantity) rti_qty
3403: FROM rcv_transactions_interface
3404: WHERE group_id = p_rtv_order
3405: AND PROCESSING_STATUS_CODE = 'WSH_INTERFACED'
3406: AND transfer_lpn_id IS NOT NULL
3407: GROUP BY transfer_lpn_id;

Line 3607: FROM RCV_TRANSACTIONS_INTERFACE RTI

3603:
3604: ELSE
3605: l_position := '0050';
3606: open c_ref for SELECT NULL , NULL , NULL , rti.quantity
3607: FROM RCV_TRANSACTIONS_INTERFACE RTI
3608: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id;
3609:
3610: END IF;
3611: l_position := '0060';

Line 3751: UPDATE RCV_TRANSACTIONS_INTERFACE

3747: IF (l_debug = 1) THEN
3748: print_debug('l_rtiid =>' || l_rtiid);
3749: END IF;
3750:
3751: UPDATE RCV_TRANSACTIONS_INTERFACE
3752: SET GROUP_ID = p_group_id,
3753: PROCESSING_MODE_CODE = p_txn_proc_mode,
3754: MOBILE_TXN = 'Y'
3755: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 3777: UPDATE RCV_TRANSACTIONS_INTERFACE

3773: IF (l_debug = 1) THEN
3774: print_debug('l_rtiid =>' || l_rtiid);
3775: END IF;
3776:
3777: UPDATE RCV_TRANSACTIONS_INTERFACE
3778: SET GROUP_ID = p_group_id,
3779: PROCESSING_MODE_CODE = p_txn_proc_mode,
3780: MOBILE_TXN = 'Y'
3781: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 3963: UPDATE RCV_TRANSACTIONS_INTERFACE

3959: IF (l_debug = 1) THEN
3960: print_debug('l_rtiid =>' || l_rtiid);
3961: END IF;
3962:
3963: UPDATE RCV_TRANSACTIONS_INTERFACE
3964: SET GROUP_ID = p_group_id,
3965: PROCESSING_MODE_CODE = p_txn_proc_mode,
3966: MOBILE_TXN = 'Y'
3967: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 3976: UPDATE RCV_TRANSACTIONS_INTERFACE

3972: IF p_to_lpn_id <> 0 THEN
3973: IF (l_debug = 1) THEN
3974: print_debug('yes, p_to_lpn_id not zero ' || to_char(p_to_lpn_id));
3975: END IF;
3976: UPDATE RCV_TRANSACTIONS_INTERFACE
3977: SET TRANSFER_LPN_ID = p_to_lpn_id
3978: WHERE INTERFACE_TRANSACTION_ID = l_rtiid
3979: AND NVL(TRANSACTION_TYPE, '@@@') = 'RETURN TO RECEIVING';
3980: END IF;

Line 4148: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti

4144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4145: BEGIN
4146: OPEN x_lpn_lov FOR
4147: select distinct wlpnc.license_plate_number
4148: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
4149: where rti.lpn_id = p_lpn_id
4150: and rti.item_id = p_item_id
4151: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
4152: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'