View: AR_ADJUSTMENTS_ALL_MRC_V

Product:	AR - Receivables
Description:	- Retrofitted
Implementation/DBA Data:	APPS.AR_ADJUSTMENTS_ALL_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
, AMOUNT
, APPLY_DATE
, GL_DATE
, CODE_COMBINATION_ID
, TYPE
, ADJUSTMENT_TYPE
, STATUS
, LINE_ADJUSTED
, FREIGHT_ADJUSTED
, TAX_ADJUSTED
, RECEIVABLES_CHARGES_ADJUSTED
, ASSOCIATED_CASH_RECEIPT_ID
, CHARGEBACK_CUSTOMER_TRX_ID
, BATCH_ID
, CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, SUBSEQUENT_TRX_ID
, PAYMENT_SCHEDULE_ID
, RECEIVABLES_TRX_ID
, DISTRIBUTION_SET_ID
, COMMENTS
, AUTOMATICALLY_GENERATED
, CREATED_FROM
, REASON_CODE
, POSTABLE
, APPROVED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ADJUSTMENT_NUMBER
, ORG_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, DOC_SEQUENCE_VALUE
, DOC_SEQUENCE_ID
, ASSOCIATED_APPLICATION_ID
, CONS_INV_ID
, MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT
, ADJ_TAX_ACCT_RULE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, LINK_TO_TRX_HIST_ID
FROM AR_ADJUSTMENTS_ALL PRIMARY
, AR_MC_ADJUSTMENTS MC
WHERE PRIMARY.ADJUSTMENT_ID = MC.ADJUSTMENT_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)

Columns