Product: | ICX - Oracle iProcurement |
---|---|
Description: | Invoice Adjustments View |
Implementation/DBA Data: | Not implemented in this database |
SELECT ADJ.ROWID ROW_ID
, ADJ.ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER
, PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TO_CHAR(ADJ.AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS.INVOICE_CURRENCY_CODE
, 30)) AMOUNT
, TO_CHAR(NVL(PS.AMOUNT_DUE_ORIGINAL
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_ORIGINAL
, TO_CHAR(NVL(PS.AMOUNT_DUE_REMAINING
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PS.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_REMAINING
, PS.DUE_DATE DUE_DATE
, LK_STATUS.MEANING STATUS_MEANING
, LK_TYPE.MEANING TYPE_MEANING
, ADJ.ACCTD_AMOUNT ACCTD_AMOUNT
, ADJ.ADJUSTMENT_ID ADJUSTMENT_ID
, ADJ.ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, ADJ.APPLY_DATE APPLY_DATE
, ADJ.APPROVED_BY APPROVED_BY
, ADJ.ASSOCIATED_APPLICATION_ID ASSOCIATED_APPLICATION_ID
, ADJ.ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID
, ADJ.ATTRIBUTE1 ATTRIBUTE1
, ADJ.ATTRIBUTE10 ATTRIBUTE10
, ADJ.ATTRIBUTE11 ATTRIBUTE11
, ADJ.ATTRIBUTE12 ATTRIBUTE12
, ADJ.ATTRIBUTE13 ATTRIBUTE13
, ADJ.ATTRIBUTE14 ATTRIBUTE14
, ADJ.ATTRIBUTE15 ATTRIBUTE15
, ADJ.ATTRIBUTE2 ATTRIBUTE2
, ADJ.ATTRIBUTE3 ATTRIBUTE3
, ADJ.ATTRIBUTE4 ATTRIBUTE4
, ADJ.ATTRIBUTE5 ATTRIBUTE5
, ADJ.ATTRIBUTE6 ATTRIBUTE6
, ADJ.ATTRIBUTE7 ATTRIBUTE7
, ADJ.ATTRIBUTE8 ATTRIBUTE8
, ADJ.ATTRIBUTE9 ATTRIBUTE9
, ADJ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ADJ.AUTOMATICALLY_GENERATED AUTOMATICALLY_GENERATED
, ADJ.BATCH_ID BATCH_ID
, ADJ.CHARGEBACK_CUSTOMER_TRX_ID CHARGEBACK_CUSTOMER_TRX_ID
, ADJ.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ADJ.COMMENTS COMMENTS
, ADJ.CREATED_BY CREATED_BY
, ADJ.CREATED_FROM CREATED_FROM
, ADJ.CREATION_DATE CREATION_DATE
, ADJ.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, ADJ.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, ADJ.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, ADJ.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, ADJ.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, ADJ.FREIGHT_ADJUSTED FREIGHT_ADJUSTED
, ADJ.GL_DATE GL_DATE
, ADJ.GL_POSTED_DATE GL_POSTED_DATE
, ADJ.LAST_UPDATED_BY LAST_UPDATED_BY
, ADJ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADJ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADJ.LINE_ADJUSTED LINE_ADJUSTED
, ADJ.ORG_ID ORG_ID
, ADJ.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, ADJ.POSTABLE POSTABLE
, ADJ.POSTING_CONTROL_ID POSTING_CONTROL_ID
, ADJ.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ADJ.REASON_CODE REASON_CODE
, ADJ.RECEIVABLES_CHARGES_ADJUSTED RECEIVABLES_CHARGES_ADJUSTED
, ADJ.RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, ADJ.REQUEST_ID REQUEST_ID
, ADJ.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ADJ.STATUS STATUS
, ADJ.SUBSEQUENT_TRX_ID SUBSEQUENT_TRX_ID
, ADJ.TAX_ADJUSTED TAX_ADJUSTED
, ADJ.TYPE TYPE
, ADJ.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, ADJ.USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, CT.TRX_NUMBER TRX_NUMBER
, CT.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, CT.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CT.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, CT.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, CT.SOLD_TO_CUSTOMER_ID SOLD_TO_CUSTOMER_ID
, CT.SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID
, CT.PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID
, CT.PAYING_SITE_USE_ID PAYING_SITE_USE_ID
, RAC.CUSTOMER_ID CUSTOMER_ID
, RAC.CUSTOMER_NAME CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER CUSTOMER_NUMBER
FROM AR_ADJUSTMENTS ADJ
, AR_LOOKUPS LK_STATUS
, AR_LOOKUPS LK_TYPE
, RA_CUSTOMER_TRX CT
, RA_CUSTOMERS RAC
, AR_PAYMENT_SCHEDULES PS
WHERE ( ADJ.STATUS = LK_STATUS.LOOKUP_CODE
AND LK_STATUS.LOOKUP_TYPE = 'APPROVAL_TYPE' )
AND ( ADJ.TYPE = LK_TYPE.LOOKUP_CODE(+)
AND LK_TYPE.LOOKUP_TYPE = 'ADJUSTMENT_TYPE' )
AND ADJ.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID(+)
AND PS.CUSTOMER_ID = RAC.CUSTOMER_ID(+)
AND ADJ.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID(+)