APPS.PA_ADJUSTMENTS dependencies on RCV_TRANSACTIONS

Line 5721: ' , rcv_transactions rcvtxn' ||

5717: where_clause := where_clause ||
5718: ' and ei.document_distribution_id in' ||
5719: ' (select rcvtxn.transaction_id' ||
5720: ' from rcv_shipment_headers rcvhead' ||
5721: ' , rcv_transactions rcvtxn' ||
5722: ' where rcvhead.shipment_header_id =' ||
5723: ' rcvtxn.shipment_header_id' ||
5724: ' and rcvhead.receipt_num = :receipt_number)';
5725: END IF;

Line 10309: , rcv_transactions rcvtxn

10305: SELECT rcv.receipt_num
10306: , rcvtxn.transaction_date
10307: , rcvtxn.transaction_type
10308: FROM rcv_shipment_headers rcv
10309: , rcv_transactions rcvtxn
10310: WHERE rcv.shipment_header_id = rcvtxn.shipment_header_id
10311: AND rcvtxn.transaction_id = p_rcv_transaction_id;
10312:
10313: BEGIN

Line 10727: FROM rcv_transactions rcv1

10723: ,'AP DISCOUNTS','INTERCOMPANY_AP_INVOICES','INTERPROJECT_AP_INVOICES'
10724: ,'AP NRTAX','AP EXPENSE','AP ERV') /* Bug 5235354 */
10725: UNION ALL
10726: SELECT rcv2.po_header_id, rcv2.transaction_id
10727: FROM rcv_transactions rcv1
10728: , rcv_transactions rcv2
10729: WHERE rcv1.transaction_id = p_document_distribution_id
10730: AND rcv1.transaction_type in ('RETURN TO RECEIVING','RETURN TO VENDOR','CORRECT')
10731: AND rcv1.parent_transaction_id = rcv2.transaction_id

Line 10728: , rcv_transactions rcv2

10724: ,'AP NRTAX','AP EXPENSE','AP ERV') /* Bug 5235354 */
10725: UNION ALL
10726: SELECT rcv2.po_header_id, rcv2.transaction_id
10727: FROM rcv_transactions rcv1
10728: , rcv_transactions rcv2
10729: WHERE rcv1.transaction_id = p_document_distribution_id
10730: AND rcv1.transaction_type in ('RETURN TO RECEIVING','RETURN TO VENDOR','CORRECT')
10731: AND rcv1.parent_transaction_id = rcv2.transaction_id
10732: AND p_transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX',