eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AR_ADJUSTMENTS_MRC_V

Object Details

Object Name:	AR_ADJUSTMENTS_MRC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_ADJUSTMENTS_MRC_V
Subobject Name:
Status:	VALID

View Type

A multiple reporting currency view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER	(15)	Yes	Adjustment identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
GL_POSTED_DATE	DATE			Date this record was transferred to the General Ledger
POSTING_CONTROL_ID	NUMBER	(15)	Yes	Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted
ACCTD_AMOUNT	NUMBER		Yes	Adjustment amount in functional currency
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
AMOUNT	NUMBER		Yes	Adjustment amount
APPLY_DATE	DATE			Date adjustment applied to payment
GL_DATE	DATE		Yes	General Ledger date
CODE_COMBINATION_ID	NUMBER	(15)		General Ledger account code combination
TYPE	VARCHAR2	(15)	Yes	Lookup code for adjustment type in AR_LOOKUPS
ADJUSTMENT_TYPE	VARCHAR2	(3)	Yes	Lookup code for adjustment creation type. Values exist in AR_LOOKUPS and are CHARGES, FREIGHT, INVOICE, LINE and TAX.
STATUS	VARCHAR2	(30)	Yes	Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved
LINE_ADJUSTED	NUMBER			Line amount adjusted as part of this adjustment
FREIGHT_ADJUSTED	NUMBER			Freight amount adjusted as part of this adjustment
TAX_ADJUSTED	NUMBER			Tax amount adjusted as part of this adjustment
RECEIVABLES_CHARGES_ADJUSTED	NUMBER			Charges adjusted as part of this adjustment
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)		Identifier of cash receipt associated with this adjustment
CHARGEBACK_CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of chargeback transaction associated with this adjustment
BATCH_ID	NUMBER	(15)		Identifier of batch associated with this adjustment
CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of customer transaction associated with this adjustment
CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Identifier of customer transaction line associated with this adjustment
SUBSEQUENT_TRX_ID	NUMBER	(15)		CUSTOMER_TRX_ID of the invoice against the guarantee
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Identifier of payment schedule associated with this adjustment
RECEIVABLES_TRX_ID	NUMBER	(15)		Identifier of receivables transaction associated with this adjustment
DISTRIBUTION_SET_ID	NUMBER	(15)		Identifier of distribution set associated with this adjustment
COMMENTS	VARCHAR2	(2000)		Comments
AUTOMATICALLY_GENERATED	VARCHAR2	(1)		Y or N. No longer used.
CREATED_FROM	VARCHAR2	(30)	Yes	Form or concurrent program name that this adjustment was created from
REASON_CODE	VARCHAR2	(30)		Identifier of reason for this adjustment
POSTABLE	VARCHAR2	(1)		Y or null indicates whether this adjustment is postable or not.
APPROVED_BY	NUMBER	(15)		Identifier of user approving the adjustment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ADJUSTMENT_NUMBER	VARCHAR2	(20)	Yes	Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S
ORG_ID	NUMBER	(15)		Organization identifier
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Value for the USSGL Transaction Code Flexfield
USSGL_TRANSACTION_CODE_CONTEXT	VARCHAR2	(30)		Context value for the USSGL Transaction Code Flexfield
DOC_SEQUENCE_VALUE	NUMBER	(15)		Document sequence number
DOC_SEQUENCE_ID	NUMBER	(15)		Document sequence identifier
ASSOCIATED_APPLICATION_ID	NUMBER	(15)		Identifier of the receipt application associated with this adjustment
CONS_INV_ID	NUMBER	(15)		Consolidated invoice number on which this transaction appeared
ADJ_TAX_ACCT_RULE	VARCHAR2	(3)		Numeric code that identifies the tax accounting rule used to create the accounting
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
LINK_TO_TRX_HIST_ID	NUMBER	(15)		Transaction history record identifier, associated with movement of deferred tax due to maturity date event or subsequent reversal event

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADJUSTMENT_ID
,      SET_OF_BOOKS_ID
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      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
,      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 APPS.AR_ADJUSTMENTS_MRC_V;

Dependencies

[top of page]

APPS.AR_ADJUSTMENTS_MRC_V references the following:

APPS: AR_ADJUSTMENTS_ALL; AR_MC_ADJUSTMENTS

APPS.AR_ADJUSTMENTS_MRC_V is not referenced by any database object