DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on RCV_SHIPMENT_HEADERS

Line 5864: ' from rcv_shipment_headers rcvhead' ||

5860: END IF;
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)';

Line 10596: FROM rcv_shipment_headers rcv

10592: CURSOR C_Rcv_Info_Cur IS
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: