DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on RCV_TRANSACTIONS

Line 129: from rcv_transactions

125: select receipt_num, trunc(creation_date) receipt_date
126: from rcv_shipment_headers
127: where shipment_header_id =
128: ( select shipment_header_id
129: from rcv_transactions
130: where transaction_id = p_transaction_id);
131:
132: cursor c_get_tax_from_ap (
133: p_invoice_id number,

Line 182: from rcv_transactions

178: from JAI_RCV_LINE_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
179: where (A.shipment_header_id, A.shipment_line_id)
180: in
181: (select shipment_header_id, shipment_line_id
182: from rcv_transactions
183: where transaction_id = p_rcv_transaction_id)
184: and A.tax_id not in
185: (
186: select tax_id