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

Line 36: rcv_transactions rt

32: CURSOR get_rcv_headers_1(l_trx_date_from DATE, l_trx_date_to DATE) IS
33: SELECT distinct rsh.shipment_header_id
34: FROM rcv_shipment_headers rsh,
35: rcv_shipment_lines rsl,
36: rcv_transactions rt
37: WHERE rsh.ship_to_org_id = p_org_id
38: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code
39: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
40: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)

Line 47: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

43: AND Nvl(rt.xml_document_id,-99) = nvl(p_xml_doc_id,-99)
44: AND Nvl(rt.receipt_confirmation_extracted,'N') not in ('Y','P')
45: AND (rt.transaction_type IN ('DELIVER') OR
46: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
47: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
48: WHERE rt.parent_transaction_id = rt2.transaction_id
49: AND rt2.transaction_type = 'DELIVER')
50: ) OR
51: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 52: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

48: WHERE rt.parent_transaction_id = rt2.transaction_id
49: AND rt2.transaction_type = 'DELIVER')
50: ) OR
51: (rt.TRANSACTION_TYPE IN ('CORRECT')
52: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
53: WHERE rt.parent_transaction_id = rt3.transaction_id
54: AND rt3.transaction_type = 'RETURN TO RECEIVING')
55: )
56: ) order by shipment_header_id asc;

Line 62: rcv_transactions rt

58: CURSOR get_rcv_headers_2(l_trx_date_from DATE, l_trx_date_to DATE) IS
59: SELECT distinct rsh.shipment_header_id
60: FROM rcv_shipment_headers rsh,
61: rcv_shipment_lines rsl,
62: rcv_transactions rt
63: WHERE rsh.ship_to_org_id = p_org_id
64: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code
65: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
66: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)

Line 73: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

69: AND rt.shipment_line_id = rsl.shipment_line_id
70: AND Nvl(rt.receipt_confirmation_extracted,'N') in ('Y')
71: AND (rt.transaction_type IN ('DELIVER') OR
72: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
73: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
74: WHERE rt.parent_transaction_id = rt2.transaction_id
75: AND rt2.transaction_type = 'DELIVER')
76: ) OR
77: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 78: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

74: WHERE rt.parent_transaction_id = rt2.transaction_id
75: AND rt2.transaction_type = 'DELIVER')
76: ) OR
77: (rt.TRANSACTION_TYPE IN ('CORRECT')
78: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
79: WHERE rt.parent_transaction_id = rt3.transaction_id
80: AND rt3.transaction_type = 'RETURN TO RECEIVING')
81: )
82: ) order by shipment_header_id asc;

Line 87: rcv_transactions rt

83:
84: CURSOR get_rcv_headers_3(l_trx_date_from DATE, l_trx_date_to DATE) IS
85: SELECT distinct rsh.shipment_header_id
86: FROM rcv_shipment_headers rsh,
87: rcv_transactions rt
88: WHERE rsh.ship_to_org_id = p_org_id
89: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
90: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)
91: AND rsh.shipment_header_id = rt.shipment_header_id

Line 96: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

92: AND Nvl(rt.xml_document_id,-99) = nvl(p_xml_doc_id,-99)
93: AND Nvl(rt.receipt_confirmation_extracted,'N') not in ('Y','P')
94: AND (rt.transaction_type IN ('DELIVER') OR
95: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
96: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
97: WHERE rt.parent_transaction_id = rt2.transaction_id
98: AND rt2.transaction_type = 'DELIVER')
99: ) OR
100: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 101: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

97: WHERE rt.parent_transaction_id = rt2.transaction_id
98: AND rt2.transaction_type = 'DELIVER')
99: ) OR
100: (rt.TRANSACTION_TYPE IN ('CORRECT')
101: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
102: WHERE rt.parent_transaction_id = rt3.transaction_id
103: AND rt3.transaction_type = 'RETURN TO RECEIVING')
104: )
105: ) order by shipment_header_id asc;

Line 110: rcv_transactions rt

106:
107: CURSOR get_rcv_headers_4(l_trx_date_from DATE, l_trx_date_to DATE) IS
108: SELECT distinct rsh.shipment_header_id
109: FROM rcv_shipment_headers rsh,
110: rcv_transactions rt
111: WHERE rsh.ship_to_org_id = p_org_id
112: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
113: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)
114: AND rsh.shipment_header_id = rt.shipment_header_id

Line 119: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

115: AND rt.xml_document_id = p_xml_doc_id
116: AND Nvl(rt.receipt_confirmation_extracted,'N') in ('Y')
117: AND (rt.transaction_type IN ('DELIVER') OR
118: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
119: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
120: WHERE rt.parent_transaction_id = rt2.transaction_id
121: AND rt2.transaction_type = 'DELIVER')
122: ) OR
123: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 124: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

120: WHERE rt.parent_transaction_id = rt2.transaction_id
121: AND rt2.transaction_type = 'DELIVER')
122: ) OR
123: (rt.TRANSACTION_TYPE IN ('CORRECT')
124: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
125: WHERE rt.parent_transaction_id = rt3.transaction_id
126: AND rt3.transaction_type = 'RETURN TO RECEIVING')
127: )
128: ) order by shipment_header_id asc;

Line 322: UPDATE rcv_transactions rt

318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
320: END IF;
321:
322: UPDATE rcv_transactions rt
323: SET rt.receipt_confirmation_extracted = 'P'
324: WHERE rt.shipment_header_id = grh.shipment_header_id
325: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'N'
326: AND (rt.transaction_type IN ('DELIVER') OR

Line 328: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

324: WHERE rt.shipment_header_id = grh.shipment_header_id
325: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'N'
326: AND (rt.transaction_type IN ('DELIVER') OR
327: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
328: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
329: WHERE rt.parent_transaction_id = rt2.transaction_id
330: AND rt2.transaction_type = 'DELIVER')
331: ) OR
332: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 333: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

329: WHERE rt.parent_transaction_id = rt2.transaction_id
330: AND rt2.transaction_type = 'DELIVER')
331: ) OR
332: (rt.TRANSACTION_TYPE IN ('CORRECT')
333: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
334: WHERE rt.parent_transaction_id = rt3.transaction_id
335: AND rt3.transaction_type = 'RETURN TO RECEIVING')
336: )
337: )

Line 350: UPDATE rcv_transactions rt

346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
347: END IF;
348:
349:
350: UPDATE rcv_transactions rt
351: SET rt.receipt_confirmation_extracted = 'P'
352: WHERE rt.shipment_header_id = grh.shipment_header_id
353: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'N'
354: AND (rt.transaction_type IN ('DELIVER') OR

Line 356: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

352: WHERE rt.shipment_header_id = grh.shipment_header_id
353: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'N'
354: AND (rt.transaction_type IN ('DELIVER') OR
355: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
356: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
357: WHERE rt.parent_transaction_id = rt2.transaction_id
358: AND rt2.transaction_type = 'DELIVER')
359: ) OR
360: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 361: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

357: WHERE rt.parent_transaction_id = rt2.transaction_id
358: AND rt2.transaction_type = 'DELIVER')
359: ) OR
360: (rt.TRANSACTION_TYPE IN ('CORRECT')
361: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
362: WHERE rt.parent_transaction_id = rt3.transaction_id
363: AND rt3.transaction_type = 'RETURN TO RECEIVING')
364: )
365: );

Line 374: RCV_TRANSACTIONS_UTIL2.Send_Document(

370:
371: END IF;
372:
373:
374: RCV_TRANSACTIONS_UTIL2.Send_Document(
375: p_entity_id => grh.shipment_header_id,
376: p_entity_type => 'RCPT',
377: p_action_type => 'A',
378: p_document_type => 'RC',

Line 399: UPDATE rcv_transactions rt

395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
397: END IF;
398:
399: UPDATE rcv_transactions rt
400: SET rt.receipt_confirmation_extracted = null,
401: rt.xml_document_id = null
402: WHERE rt.shipment_header_id = grh.shipment_header_id
403: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'

Line 406: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

402: WHERE rt.shipment_header_id = grh.shipment_header_id
403: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'
404: AND (rt.transaction_type IN ('DELIVER') OR
405: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
406: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
407: WHERE rt.parent_transaction_id = rt2.transaction_id
408: AND rt2.transaction_type = 'DELIVER')
409: ) OR
410: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 411: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

407: WHERE rt.parent_transaction_id = rt2.transaction_id
408: AND rt2.transaction_type = 'DELIVER')
409: ) OR
410: (rt.TRANSACTION_TYPE IN ('CORRECT')
411: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
412: WHERE rt.parent_transaction_id = rt3.transaction_id
413: AND rt3.transaction_type = 'RETURN TO RECEIVING')
414: )
415: )

Line 427: UPDATE rcv_transactions rt

423: asn_debug.put_line('WMS Deploy Mode is Distributed');
424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
425: END IF;
426:
427: UPDATE rcv_transactions rt
428: SET rt.receipt_confirmation_extracted = null,
429: rt.xml_document_id = null
430: WHERE rt.shipment_header_id = grh.shipment_header_id
431: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'

Line 434: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

430: WHERE rt.shipment_header_id = grh.shipment_header_id
431: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'
432: AND (rt.transaction_type IN ('DELIVER') OR
433: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
434: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
435: WHERE rt.parent_transaction_id = rt2.transaction_id
436: AND rt2.transaction_type = 'DELIVER')
437: ) OR
438: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 439: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

435: WHERE rt.parent_transaction_id = rt2.transaction_id
436: AND rt2.transaction_type = 'DELIVER')
437: ) OR
438: (rt.TRANSACTION_TYPE IN ('CORRECT')
439: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
440: WHERE rt.parent_transaction_id = rt3.transaction_id
441: AND rt3.transaction_type = 'RETURN TO RECEIVING')
442: )
443: );