[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ADJ.CUSTOMER_TRX_ID, ADJ.ADJUSTMENT_NUMBER,
ADJ.AMOUNT, ADJ.APPLY_DATE,
ADJ.GL_DATE, ADJ.SET_OF_BOOKS_ID,
ADJ.CODE_COMBINATION_ID, ADJ.TYPE,
ADJ.ADJUSTMENT_TYPE, ADJ.STATUS,
ADJ.LINE_ADJUSTED, ADJ.FREIGHT_ADJUSTED,
ADJ.TAX_ADJUSTED, TRX.INVOICE_CURRENCY_CODE,
ADJ.RECEIVABLES_CHARGES_ADJUSTED,
ADJ.ASSOCIATED_CASH_RECEIPT_ID,
ADJ.CHARGEBACK_CUSTOMER_TRX_ID,
ADJ.BATCH_ID, ADJ.CUSTOMER_TRX_LINE_ID,
ADJ.SUBSEQUENT_TRX_ID, ADJ.PAYMENT_SCHEDULE_ID,
ADJ.RECEIVABLES_TRX_ID, ADJ.DISTRIBUTION_SET_ID,
ADJ.GL_POSTED_DATE, ADJ.CREATED_FROM,
ADJ.REASON_CODE, ADJ.APPROVED_BY,
ADJ.ATTRIBUTE_CATEGORY, ADJ.ATTRIBUTE1,
ADJ.ATTRIBUTE2, ADJ.ATTRIBUTE3,
ADJ.ATTRIBUTE4, ADJ.ATTRIBUTE5,
ADJ.ATTRIBUTE6, ADJ.ATTRIBUTE7,
ADJ.ATTRIBUTE8, ADJ.ATTRIBUTE9,
ADJ.ATTRIBUTE10, ADJ.ATTRIBUTE11,
ADJ.ATTRIBUTE12, ADJ.ATTRIBUTE13,
ADJ.ATTRIBUTE14, ADJ.ATTRIBUTE15,
ADJ.POSTING_CONTROL_ID, ADJ.ACCTD_AMOUNT,
ADJ.CREATED_BY, ADJ.CREATION_DATE,
ADJ.LAST_UPDATE_DATE, ADJ.LAST_UPDATED_BY
from RA_CUSTOMER_TRX_ALL TRX,
AR_ADJUSTMENTS_ALL ADJ
where ADJ.customer_trx_id = invoice_id
and ADJ.adjustment_id = nvl(adj_id, ADJ.adjustment_id)
and TRX.customer_trx_id = ADJ.customer_trx_id
and ADJ.last_update_date between
nvl(start_date, ADJ.last_update_date)
and nvl(end_date, ADJ.last_update_date);
last_update_date out NOCOPY date,
last_updated_by out NOCOPY number,
row_to_fetch in out NOCOPY number,
error_status out NOCOPY number) is
begin
if NOT cur_ar_get_invoice_adjustments%ISOPEN then
open cur_ar_get_invoice_adjustments(start_date, end_date,
invoice_id, adj_id,
adj_number);
created_by, creation_date, last_update_date,
last_updated_by;