DBA Data[Home] [Help]

APPS.PA_ADJUSTMENTS dependencies on RCV_SHIPMENT_HEADERS

Line 5720: ' from rcv_shipment_headers rcvhead' ||

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

Line 10308: FROM rcv_shipment_headers rcv

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