APPS.RCV_VALIDATE_PO dependencies on RCV_TRANSACTIONS

Line 42: FROM rcv_transactions_interface

38: begin
39:
40: SELECT Count(1)
41: INTO l_count
42: FROM rcv_transactions_interface
43: WHERE transaction_status_code = 'PENDING'
44: and processing_status_code <> 'ERROR'
45: AND source_document_code = 'PO'
46: AND (po_header_id = x_po_header_id OR (document_num = x_po_num AND org_id = x_Org_id))

Line 66: FROM rcv_transactions_interface

62: begin
63:
64: SELECT Count(1)
65: INTO l_count
66: FROM rcv_transactions_interface
67: WHERE transaction_status_code = 'PENDING'
68: and processing_status_code <> 'ERROR'
69: AND source_document_code = 'PO'
70: AND ( po_header_id = nvl(x_po_header_id,po_header_id)

Line 93: FROM rcv_transactions_interface

89: begin
90:
91: SELECT Count(1)
92: INTO l_count
93: FROM rcv_transactions_interface
94: WHERE transaction_status_code = 'PENDING'
95: and processing_status_code <> 'ERROR'
96: AND source_document_code = 'PO'
97: AND ( po_header_id = nvl(x_po_header_id,po_header_id)

Line 153: FROM rcv_transactions rt,

149: CURSOR c_rt_invioce (p_po_header_id IN NUMBER) IS
150: SELECT DISTINCT shipment_header_id
151: FROM (
152: SELECT rsl.shipment_header_id, rsl.shipment_line_id, rsl.quantity_received
153: FROM rcv_transactions rt,
154: rcv_shipment_lines rsl,
155: po_line_locations_all poll
156: WHERE rt.transaction_type IN ('RECEIVE', 'MATCH')
157: AND rt.shipment_line_id = rsl.shipment_line_id

Line 170: FROM rcv_transactions rt,

166: GROUP BY rsl.shipment_header_id, rsl.shipment_line_id, rsl.quantity_received
167: HAVING rsl.quantity_received > Sum(Nvl(rt.quantity_billed, 0))
168: UNION
169: SELECT rsl.shipment_header_id, rsl.shipment_line_id, rsl.amount_received
170: FROM rcv_transactions rt,
171: rcv_shipment_lines rsl,
172: po_line_locations_all poll
173: WHERE rt.transaction_type IN ('RECEIVE', 'MATCH')
174: AND rt.shipment_line_id = rsl.shipment_line_id

Line 191: FROM rcv_transactions rt,

187: CURSOR c_rt_novation (p_po_header_id IN NUMBER, p_date IN DATE) IS
188: SELECT rsh.shipment_header_id,
189: rsh.receipt_num,
190: Min(rt.transaction_date)
191: FROM rcv_transactions rt,
192: rcv_shipment_headers rsh
193: WHERE rt.shipment_header_id = rsh.shipment_header_id
194: AND rt.po_header_id = p_po_header_id
195: AND rt.source_document_code = 'PO'

Line 204: l_receipt_date rcv_transactions.transaction_date%TYPE;

200:
201:
202: l_po_header_id po_headers_all.po_header_id%TYPE;
203: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
204: l_receipt_date rcv_transactions.transaction_date%TYPE;
205: l_receipt_number rcv_shipment_headers.receipt_num%TYPE;
206: l_multi_mod_val_result_id NUMBER;
207: l_receipt_amount NUMBER;
208: l_exception_type VARCHAR2(200) := NULL ;

Line 241: rcv_transactions rt

237: l_progress := '030';
238: SELECT rsh.receipt_num, Min(rt.transaction_date)
239: INTO l_receipt_number, l_receipt_date
240: FROM rcv_shipment_headers rsh,
241: rcv_transactions rt
242: WHERE rt.shipment_header_id = rsh.shipment_header_id
243: AND rt.transaction_type IN ('RECEIVE', 'MATCH')
244: AND rsh.shipment_header_id = l_shipment_header_id
245: GROUP BY rsh.receipt_num;

Line 304: FROM rcv_transactions_interface rti

300: l_message_name := NULL;
301:
302: SELECT count(*)
303: INTO l_rti_count
304: FROM rcv_transactions_interface rti
305: WHERE rti.po_header_id = l_po_header_id
306: OR ( (rti.receipt_source_code = 'VENDOR' OR rti.source_document_code = 'PO')
307: AND EXISTS
308: ( SELECT 1