DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on RCV_TRANSACTIONS

Line 134: from rcv_transactions

130: select receipt_num, trunc(creation_date) receipt_date
131: from rcv_shipment_headers
132: where shipment_header_id =
133: ( select shipment_header_id
134: from rcv_transactions
135: where transaction_id = p_transaction_id);
136:
137: cursor c_get_tax_from_ap (
138: p_invoice_id number,

Line 187: from rcv_transactions

183: from JAI_RCV_LINE_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
184: where (A.shipment_header_id, A.shipment_line_id)
185: in
186: (select shipment_header_id, shipment_line_id
187: from rcv_transactions
188: where transaction_id = p_rcv_transaction_id)
189: and A.tax_id not in
190: (
191: select tax_id