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 1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt

1127: , wlpnc.COST_GROUP_ID cg_id
1128: , rt.destination_type_code
1129: , rt.quantity rt_quantity
1130: , rt.parent_transaction_id
1131: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlpnc, rcv_transactions rt
1132: WHERE rt.group_id = p_group_id
1133: AND (((( rt.transaction_type = 'RETURN TO VENDOR'
1134: AND rt.lpn_id IS NOT NULL -- 3603808
1135: )

Line 1145: FROM rcv_transactions rt2

1141: -- to eliminate the row being selected for a rtv
1142: -- from inventory as pack unpack for that is already
1143: -- taken care of in inventory tm.
1144: AND NOT exists (SELECT 1
1145: FROM rcv_transactions rt2
1146: WHERE rt2.interface_transaction_id = rt.interface_transaction_id
1147: AND rt2.transaction_type = 'RETURN TO RECEIVING'
1148: AND rt2.group_id = p_group_id))
1149: OR (rt.transaction_type = 'CORRECT')

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

1161: msn.inventory_item_id, msn.revision, msn.lot_number,
1162: msn.serial_number, to_number(null) quantity, wlpnc.uom_code uom_code, rt.transaction_type,
1163: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1164: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1165: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions rt
1166: WHERE msn.last_txn_source_name = rt.transaction_type
1167: AND msn.last_txn_source_id = rt.interface_transaction_id
1168: AND rt.group_id = p_group_id
1169: AND (((( rt.transaction_type = 'RETURN TO VENDOR' -- 3603808

Line 1178: FROM rcv_transactions rt2

1174: -- AND rt.transfer_lpn_id IS NOT NULL fix for 4389811
1175: AND rt.lpn_id IS NOT NULL
1176: ))
1177: AND NOT exists (SELECT 1
1178: FROM rcv_transactions rt2
1179: WHERE rt2.interface_transaction_id = rt.interface_transaction_id
1180: AND rt2.transaction_type = 'RETURN TO RECEIVING'
1181: AND rt2.group_id = p_group_id))
1182: OR (rt.transaction_type = 'CORRECT') OR (rt.transaction_type = 'RETURN TO RECEIVING'

Line 1194: FROM rcv_transactions_interface rti

1190: -- Also select for the item_id column in RTI so we can use
1191: -- this in looking up the values in MSN.
1192: CURSOR c_failure IS
1193: SELECT transaction_type, interface_transaction_id, item_id
1194: FROM rcv_transactions_interface rti
1195: WHERE rti.group_id = p_group_id
1196: AND rti.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER','RETURN TO RECEIVING','CORRECT');
1197:
1198: CURSOR c_newly_packed IS

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

1209: , rti.interface_transaction_id
1210: , rti.destination_type_code
1211: , rti.quantity rti_quantity
1212: , rti.parent_transaction_id
1213: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1214: WHERE rti.group_id = p_group_id
1215: AND rti.transaction_type = 'CORRECT'
1216: AND rt.transaction_id = rti.parent_transaction_id
1217: AND ((rt.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER') AND rti.quantity < 0) OR

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

1233: , rti.interface_transaction_id
1234: , rti.destination_type_code
1235: , rti.quantity rti_quantity
1236: , rti.parent_transaction_id
1237: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1238: WHERE msn.last_txn_source_name = rti.transaction_type
1239: AND msn.last_txn_source_id = rti.interface_transaction_id
1240: AND rti.group_id = p_group_id
1241: AND rti.transaction_type = 'CORRECT'

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

1251: msn.inventory_item_id, msn.revision, msn.lot_number,
1252: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1253: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1254: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1255: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1256: WHERE rt.group_id = p_group_id
1257: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1258: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1259: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))

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

1264: AND rsl.shipment_line_id = rt.shipment_line_id
1265: AND msn.inventory_item_id = rsl.item_id
1266: AND rt.user_entered_flag = 'Y'
1267: AND msn.current_status = 4
1268: AND exists (SELECT '1' FROM rcv_transactions rt2
1269: WHERE rt2.transaction_id = rt.parent_transaction_id
1270: AND rt2.transaction_type = 'DELIVER');
1271:
1272: CURSOR c_neg_deliver_ser_lpng IS

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

1275: msn.inventory_item_id, msn.revision, msn.lot_number,
1276: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1277: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1278: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1279: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1280: WHERE rt.transaction_date >= (Sysdate - 1)
1281: AND rt.lpn_group_id = p_group_id
1282: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1283: OR (rt.transaction_type = 'RETURN TO RECEIVING'

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

1289: AND rsl.shipment_line_id = rt.shipment_line_id
1290: AND msn.inventory_item_id = rsl.item_id
1291: AND rt.user_entered_flag = 'Y'
1292: AND msn.current_status = 4
1293: AND exists (SELECT '1' FROM rcv_transactions rt2
1294: WHERE rt2.transaction_id = rt.parent_transaction_id
1295: AND rt2.transaction_type = 'DELIVER');
1296:
1297: -- Added new cursor to address the Bug 4489361

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

1301: msn.inventory_item_id, msn.revision, msn.lot_number,
1302: msn.serial_number, to_number(NULL) quantity, rt.transaction_type,
1303: rt.interface_transaction_id, msn.COST_GROUP_ID cg_id,
1304: rt.destination_type_code, rt.quantity rt_quantity, rt.parent_transaction_id
1305: FROM mtl_serial_numbers msn, rcv_transactions rt, rcv_shipment_lines rsl
1306: WHERE rt.group_id = p_group_id
1307: AND ((rt.transaction_type = 'CORRECT' AND Nvl(msn.lpn_id,-1) = Nvl(rt.lpn_id,-1))
1308: OR (rt.transaction_type = 'RETURN TO RECEIVING'
1309: AND Nvl(msn.lpn_id,-1) = Nvl(rt.transfer_lpn_id,-1)))

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

1314: AND rsl.shipment_line_id = rt.shipment_line_id
1315: AND msn.inventory_item_id = rsl.item_id
1316: AND rt.user_entered_flag = 'Y'
1317: AND msn.current_status = 4
1318: AND exists (SELECT '1' FROM rcv_transactions rt2
1319: WHERE rt2.transaction_id = rt.parent_transaction_id
1320: AND rt2.transaction_type = 'DELIVER');
1321:
1322: ret boolean;

Line 1357: FROM rcv_transactions rt, rcv_shipment_lines rsl

1353: rt.from_subinventory,
1354: rt.from_locator_id,
1355: rt.lpn_id,
1356: rt.quantity
1357: FROM rcv_transactions rt, rcv_shipment_lines rsl
1358: WHERE rt.group_id = p_group_id
1359: AND p_txn_mode <> 'LPN_GROUP'
1360: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')
1361: AND rt.shipment_line_id = rsl.shipment_line_id;

Line 1373: FROM rcv_transactions rt, rcv_shipment_lines rsl

1369: rt.from_subinventory,
1370: rt.from_locator_id,
1371: rt.lpn_id,
1372: rt.quantity
1373: FROM rcv_transactions rt, rcv_shipment_lines rsl
1374: WHERE rt.transaction_date >= (SYSDATE-1)
1375: AND rt.lpn_group_id = p_group_id
1376: AND p_txn_mode = 'LPN_GROUP'
1377: AND rt.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING', 'RETURN TO CUSTOMER')

Line 1393: FROM rcv_transactions

1389: -- Bug# 3281512 - Performance Fixes
1390: -- Cursor to get rid of the hash join problem
1391: CURSOR c_interface_txn_id IS
1392: SELECT interface_transaction_id
1393: FROM rcv_transactions
1394: WHERE group_id = p_group_id;
1395: l_interface_txn_id NUMBER;
1396: BEGIN
1397:

Line 1486: FROM rcv_transactions

1482:
1483: BEGIN
1484: SELECT transaction_type, routing_header_id
1485: INTO l_parent_transaction_type, l_routing_header_id
1486: FROM rcv_transactions
1487: WHERE transaction_id = i.parent_transaction_id;
1488: IF (l_debug = 1) THEN
1489: print_debug('l_parent_transaction_type=' || l_parent_transaction_type);
1490: END IF;

Line 2448: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI

2444: ELSE
2445:
2446: l_position := '0050';
2447: open c_ref for SELECT NULL , NULL , NULL , rti.quantity, wlpnc.cost_group_id
2448: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI
2449: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id
2450: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2451: AND WLPNC.INVENTORY_ITEM_ID = RTI.ITEM_ID
2452: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 2695: FROM RCV_TRANSACTIONS_INTERFACE RTI

2691:
2692: ELSE
2693: l_position := '0050';
2694: open c_ref for SELECT NULL , NULL , NULL , rti.quantity
2695: FROM RCV_TRANSACTIONS_INTERFACE RTI
2696: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id;
2697:
2698: END IF;
2699: l_position := '0060';

Line 2839: UPDATE RCV_TRANSACTIONS_INTERFACE

2835: IF (l_debug = 1) THEN
2836: print_debug('l_rtiid =>' || l_rtiid);
2837: END IF;
2838:
2839: UPDATE RCV_TRANSACTIONS_INTERFACE
2840: SET GROUP_ID = p_group_id,
2841: PROCESSING_MODE_CODE = p_txn_proc_mode,
2842: MOBILE_TXN = 'Y'
2843: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 2865: UPDATE RCV_TRANSACTIONS_INTERFACE

2861: IF (l_debug = 1) THEN
2862: print_debug('l_rtiid =>' || l_rtiid);
2863: END IF;
2864:
2865: UPDATE RCV_TRANSACTIONS_INTERFACE
2866: SET GROUP_ID = p_group_id,
2867: PROCESSING_MODE_CODE = p_txn_proc_mode,
2868: MOBILE_TXN = 'Y'
2869: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 3051: UPDATE RCV_TRANSACTIONS_INTERFACE

3047: IF (l_debug = 1) THEN
3048: print_debug('l_rtiid =>' || l_rtiid);
3049: END IF;
3050:
3051: UPDATE RCV_TRANSACTIONS_INTERFACE
3052: SET GROUP_ID = p_group_id,
3053: PROCESSING_MODE_CODE = p_txn_proc_mode,
3054: MOBILE_TXN = 'Y'
3055: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;

Line 3064: UPDATE RCV_TRANSACTIONS_INTERFACE

3060: IF p_to_lpn_id <> 0 THEN
3061: IF (l_debug = 1) THEN
3062: print_debug('yes, p_to_lpn_id not zero ' || to_char(p_to_lpn_id));
3063: END IF;
3064: UPDATE RCV_TRANSACTIONS_INTERFACE
3065: SET TRANSFER_LPN_ID = p_to_lpn_id
3066: WHERE INTERFACE_TRANSACTION_ID = l_rtiid
3067: AND NVL(TRANSACTION_TYPE, '@@@') = 'RETURN TO RECEIVING';
3068: END IF;

Line 3236: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti

3232: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3233: BEGIN
3234: OPEN x_lpn_lov FOR
3235: select distinct wlpnc.license_plate_number
3236: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
3237: where rti.lpn_id = p_lpn_id
3238: and rti.item_id = p_item_id
3239: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
3240: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'