View: AR_ADJUSTMENTS_MRC_V

Product:	AR - Receivables
Description:	- Retrofitted
Implementation/DBA Data:	APPS.AR_ADJUSTMENTS_MRC_V

View Text

SELECT PRIMARY.ADJUSTMENT_ID
, MC.SET_OF_BOOKS_ID
, MC.GL_POSTED_DATE
, MC.POSTING_CONTROL_ID
, MC.ACCTD_AMOUNT
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.AMOUNT
, PRIMARY.APPLY_DATE
, PRIMARY.GL_DATE
, PRIMARY.CODE_COMBINATION_ID
, PRIMARY.TYPE
, PRIMARY.ADJUSTMENT_TYPE
, PRIMARY.STATUS
, PRIMARY.LINE_ADJUSTED
, PRIMARY.FREIGHT_ADJUSTED
, PRIMARY.TAX_ADJUSTED
, PRIMARY.RECEIVABLES_CHARGES_ADJUSTED
, PRIMARY.ASSOCIATED_CASH_RECEIPT_ID
, PRIMARY.CHARGEBACK_CUSTOMER_TRX_ID
, PRIMARY.BATCH_ID
, PRIMARY.CUSTOMER_TRX_ID
, PRIMARY.CUSTOMER_TRX_LINE_ID
, PRIMARY.SUBSEQUENT_TRX_ID
, PRIMARY.PAYMENT_SCHEDULE_ID
, PRIMARY.RECEIVABLES_TRX_ID
, PRIMARY.DISTRIBUTION_SET_ID
, PRIMARY.COMMENTS
, PRIMARY.AUTOMATICALLY_GENERATED
, PRIMARY.CREATED_FROM
, PRIMARY.REASON_CODE
, PRIMARY.POSTABLE
, PRIMARY.APPROVED_BY
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.REQUEST_ID
, PRIMARY.ADJUSTMENT_NUMBER
, PRIMARY.ORG_ID
, PRIMARY.USSGL_TRANSACTION_CODE
, PRIMARY.USSGL_TRANSACTION_CODE_CONTEXT
, PRIMARY.DOC_SEQUENCE_VALUE
, PRIMARY.DOC_SEQUENCE_ID
, PRIMARY.ASSOCIATED_APPLICATION_ID
, PRIMARY.CONS_INV_ID
, PRIMARY.ADJ_TAX_ACCT_RULE
, PRIMARY.GLOBAL_ATTRIBUTE_CATEGORY
, PRIMARY.GLOBAL_ATTRIBUTE1
, PRIMARY.GLOBAL_ATTRIBUTE2
, PRIMARY.GLOBAL_ATTRIBUTE3
, PRIMARY.GLOBAL_ATTRIBUTE4
, PRIMARY.GLOBAL_ATTRIBUTE5
, PRIMARY.GLOBAL_ATTRIBUTE6
, PRIMARY.GLOBAL_ATTRIBUTE7
, PRIMARY.GLOBAL_ATTRIBUTE8
, PRIMARY.GLOBAL_ATTRIBUTE9
, PRIMARY.GLOBAL_ATTRIBUTE10
, PRIMARY.GLOBAL_ATTRIBUTE11
, PRIMARY.GLOBAL_ATTRIBUTE12
, PRIMARY.GLOBAL_ATTRIBUTE13
, PRIMARY.GLOBAL_ATTRIBUTE14
, PRIMARY.GLOBAL_ATTRIBUTE15
, PRIMARY.GLOBAL_ATTRIBUTE16
, PRIMARY.GLOBAL_ATTRIBUTE17
, PRIMARY.GLOBAL_ATTRIBUTE18
, PRIMARY.GLOBAL_ATTRIBUTE19
, PRIMARY.GLOBAL_ATTRIBUTE20
, PRIMARY.LINK_TO_TRX_HIST_ID
FROM AR_ADJUSTMENTS_ALL PRIMARY
, AR_MC_ADJUSTMENTS MC
WHERE PRIMARY.ADJUSTMENT_ID = MC.ADJUSTMENT_ID
AND NVL(PRIMARY.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)

Columns