APPS.PA_ADJUSTMENTS dependencies on RCV_TRANSACTIONS

Line 5865: ' , rcv_transactions rcvtxn' ||

5861: where_clause := where_clause ||
5862: ' and ei.document_distribution_id in' ||
5863: ' (select rcvtxn.transaction_id' ||
5864: ' from rcv_shipment_headers rcvhead' ||
5865: ' , rcv_transactions rcvtxn' ||
5866: ' where rcvhead.shipment_header_id =' ||
5867: ' rcvtxn.shipment_header_id' ||
5868: ' and rcvhead.receipt_num = :receipt_number)';
5869: END IF;

Line 10597: , rcv_transactions rcvtxn

10593: SELECT rcv.receipt_num
10594: , rcvtxn.transaction_date
10595: , rcvtxn.transaction_type
10596: FROM rcv_shipment_headers rcv
10597: , rcv_transactions rcvtxn
10598: WHERE rcv.shipment_header_id = rcvtxn.shipment_header_id
10599: AND rcvtxn.transaction_id = p_rcv_transaction_id;
10600:
10601: BEGIN

Line 11056: FROM rcv_transactions rcv1

11052: ,'AP DISCOUNTS','INTERCOMPANY_AP_INVOICES','INTERPROJECT_AP_INVOICES'
11053: ,'AP NRTAX','AP EXPENSE','AP ERV')
11054: UNION ALL
11055: SELECT rcv2.po_header_id, rcv2.transaction_id
11056: FROM rcv_transactions rcv1
11057: , rcv_transactions rcv2
11058: WHERE rcv1.transaction_id = p_document_distribution_id
11059: AND rcv1.transaction_type in ('RETURN TO RECEIVING','RETURN TO VENDOR','CORRECT')
11060: AND rcv1.parent_transaction_id = rcv2.transaction_id

Line 11057: , rcv_transactions rcv2

11053: ,'AP NRTAX','AP EXPENSE','AP ERV')
11054: UNION ALL
11055: SELECT rcv2.po_header_id, rcv2.transaction_id
11056: FROM rcv_transactions rcv1
11057: , rcv_transactions rcv2
11058: WHERE rcv1.transaction_id = p_document_distribution_id
11059: AND rcv1.transaction_type in ('RETURN TO RECEIVING','RETURN TO VENDOR','CORRECT')
11060: AND rcv1.parent_transaction_id = rcv2.transaction_id
11061: AND p_transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX',