View: AR_ADJUSTMENTS_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_ADJUSTMENTS_V

View Text

SELECT ADJ.ROWID ROW_ID
, ADJ.ACCTD_AMOUNT ACCTD_AMOUNT
, ADJ.ADJUSTMENT_ID ADJUSTMENT_ID
, ADJ.ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER
, ADJ.ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, ADJ.AMOUNT AMOUNT
, 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_CHARGES_ADJUSTED REC_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
, RT.NAME ACTIVITY_NAME
, RT.TYPE ACTIVITY_TYPE /* 20-APR-2000 J RAUTIAINEN BR IMPLEMENTATION */
, LK_REASON.MEANING REASON_MEANING
, LK_STATUS.MEANING STATUS_MEANING
, LK_TYPE.MEANING TYPE_MEANING
, CTL_LINENUM.LINE_NUMBER LINE_NUMBER
, CT.TRX_NUMBER TRX_NUMBER
, CTT.NAME TRX_TYPE
, CTT.TYPE TRX_CLASS
, CTT.CREATION_SIGN CREATION_SIGN
, CTT.ALLOW_OVERAPPLICATION_FLAG ALLOW_OVERAPPLICATION_FLAG
, CTT.NATURAL_APPLICATION_ONLY_FLAG NATURAL_APPLICATION_ONLY_FLAG
, RAC.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, RAC.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PS.DUE_DATE DUE_DATE
, PS.GL_DATE TRX_GL_DATE
, PS.TRX_DATE TRX_DATE
, NVL(PS.AMOUNT_DUE_ORIGINAL
, 0) AMOUNT_DUE_ORIGINAL
, NVL(PS.TAX_ORIGINAL
, 0) TAX_ORIGINAL
, NVL(PS.FREIGHT_ORIGINAL
, 0) FREIGHT_ORIGINAL
, NVL(PS.RECEIVABLES_CHARGES_CHARGED
, 0) RECEIVABLES_CHARGES_ORIGINAL
, NVL(PS.AMOUNT_LINE_ITEMS_ORIGINAL
, 0) AMOUNT_LINE_ITEMS_ORIGINAL
, NVL(PS.AMOUNT_DUE_REMAINING
, 0) AMOUNT_DUE_REMAINING
, NVL(PS.TAX_REMAINING
, 0) TAX_REMAINING
, NVL(PS.FREIGHT_REMAINING
, 0) FREIGHT_REMAINING
, NVL(PS.RECEIVABLES_CHARGES_REMAINING
, 0) RECEIVABLES_CHARGES_REMAINING
, NVL(PS.AMOUNT_LINE_ITEMS_REMAINING
, 0) AMOUNT_LINE_ITEMS_REMAINING
, CT_CHARGE.TRX_NUMBER CHARGEBACK_NUMBER
, DECODE(PS.SELECTED_FOR_RECEIPT_BATCH_ID
, NULL
, 'N'
, 'Y') SELECTED_FOR_RECEIPT_BATCH
, BS.NAME SOURCE
, FU1.USER_NAME CREATOR
, FU2.USER_NAME UPDATED_BY
, FND_ATTACHMENT_UTIL_PKG.GET_ATCHMT_EXISTS('AR_ADJUSTMENTS'
, ADJ.ADJUSTMENT_ID) ATCHMT_FLAG
, RT.GL_ACCOUNT_SOURCE GL_ACCOUNT_SOURCE
, RT.TAX_CODE_SOURCE TAX_CODE_SOURCE
, DECODE( ADJ.STATUS
, 'A'
, ADJ.AMOUNT
, NULL)
, TO_NUMBER(DECODE( ADJ.STATUS
, 'A'
, NULL
, ADJ.AMOUNT))
FROM AR_RECEIVABLES_TRX_ALL RT
, AR_LOOKUPS LK_REASON
, AR_LOOKUPS LK_STATUS
, AR_LOOKUPS LK_TYPE
, RA_CUSTOMER_TRX_LINES_ALL CTL_LINENUM
, RA_CUSTOMER_TRX_ALL CT
, RA_CUSTOMER_TRX_ALL CT_CHARGE
, RA_CUST_TRX_TYPES_ALL CTT
, HZ_CUST_ACCOUNTS RAC
, HZ_PARTIES PARTY
, AR_PAYMENT_SCHEDULES_ALL PS
, RA_BATCH_SOURCES_ALL BS
, FND_USER FU1
, FND_USER FU2
, AR_ADJUSTMENTS ADJ
WHERE ADJ.RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID
AND ADJ.ORG_ID = RT.ORG_ID
AND RT.RECEIVABLES_TRX_ID <> -15
AND /* 20-APR-2000 J RAUTIAINEN BR IMPLEMENTATION */ (ADJ.REASON_CODE = LK_REASON.LOOKUP_CODE(+)
AND LK_REASON.LOOKUP_TYPE(+) = 'ADJUST_REASON')
AND 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_LINE_ID = CTL_LINENUM.CUSTOMER_TRX_LINE_ID(+)
AND ADJ.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID(+)
AND ADJ.ORG_ID = CT.ORG_ID(+)
AND ADJ.CHARGEBACK_CUSTOMER_TRX_ID = CT_CHARGE.CUSTOMER_TRX_ID(+)
AND ADJ.ORG_ID = CT_CHARGE.ORG_ID(+)
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID(+)
AND CT.ORG_ID = CTT.ORG_ID(+)
AND PS.CUSTOMER_ID = RAC.CUST_ACCOUNT_ID
AND RAC.PARTY_ID = PARTY.PARTY_ID
AND ADJ.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID(+)
AND ADJ.ORG_ID = PS.ORG_ID(+)
AND CT.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID(+)
AND CT.ORG_ID = BS.ORG_ID(+)
AND ADJ.CREATED_BY = FU1.USER_ID(+)
AND ADJ.LAST_UPDATED_BY = FU2.USER_ID(+)

Columns