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_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ACCTD_AMOUNT	NUMBER		Yes
ADJUSTMENT_ID	NUMBER	(15)	Yes
ADJUSTMENT_NUMBER	VARCHAR2	(20)	Yes
ADJUSTMENT_TYPE	VARCHAR2	(3)	Yes
AMOUNT	NUMBER		Yes
APPLY_DATE	DATE
APPROVED_BY	NUMBER	(15)
ASSOCIATED_APPLICATION_ID	NUMBER	(15)
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
AUTOMATICALLY_GENERATED	VARCHAR2	(1)
BATCH_ID	NUMBER	(15)
CHARGEBACK_CUSTOMER_TRX_ID	NUMBER	(15)
CODE_COMBINATION_ID	NUMBER	(15)
COMMENTS	VARCHAR2	(2000)
CREATED_BY	NUMBER	(15)	Yes
CREATED_FROM	VARCHAR2	(30)	Yes
CREATION_DATE	DATE		Yes
CUSTOMER_TRX_ID	NUMBER	(15)
CUSTOMER_TRX_LINE_ID	NUMBER	(15)
DISTRIBUTION_SET_ID	NUMBER	(15)
DOC_SEQUENCE_ID	NUMBER	(15)
DOC_SEQUENCE_VALUE	NUMBER	(15)
FREIGHT_ADJUSTED	NUMBER
GL_DATE	DATE		Yes
GL_POSTED_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LINE_ADJUSTED	NUMBER
ORG_ID	NUMBER	(15)
PAYMENT_SCHEDULE_ID	NUMBER	(15)
POSTABLE	VARCHAR2	(1)
POSTING_CONTROL_ID	NUMBER	(15)	Yes
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
REASON_CODE	VARCHAR2	(30)
RECEIVABLES_CHARGES_ADJUSTED	NUMBER
REC_CHARGES_ADJUSTED	NUMBER
RECEIVABLES_TRX_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
STATUS	VARCHAR2	(30)	Yes
SUBSEQUENT_TRX_ID	NUMBER	(15)
TAX_ADJUSTED	NUMBER
TYPE	VARCHAR2	(15)	Yes
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRANSACTION_CODE_CONTEXT	VARCHAR2	(30)
ACTIVITY_NAME	VARCHAR2	(50)	Yes
ACTIVITY_TYPE	VARCHAR2	(30)
REASON_MEANING	VARCHAR2	(80)
STATUS_MEANING	VARCHAR2	(80)	Yes
TYPE_MEANING	VARCHAR2	(80)	Yes
LINE_NUMBER	NUMBER
TRX_NUMBER	VARCHAR2	(20)
TRX_TYPE	VARCHAR2	(20)
TRX_CLASS	VARCHAR2	(20)
CREATION_SIGN	VARCHAR2	(30)
ALLOW_OVERAPPLICATION_FLAG	VARCHAR2	(1)
NATURAL_APPLICATION_ONLY_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(50)
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
DUE_DATE	DATE
TRX_GL_DATE	DATE
TRX_DATE	DATE
AMOUNT_DUE_ORIGINAL	NUMBER
TAX_ORIGINAL	NUMBER
FREIGHT_ORIGINAL	NUMBER
RECEIVABLES_CHARGES_ORIGINAL	NUMBER
AMOUNT_LINE_ITEMS_ORIGINAL	NUMBER
AMOUNT_DUE_REMAINING	NUMBER
TAX_REMAINING	NUMBER
FREIGHT_REMAINING	NUMBER
RECEIVABLES_CHARGES_REMAINING	NUMBER
AMOUNT_LINE_ITEMS_REMAINING	NUMBER
CHARGEBACK_NUMBER	VARCHAR2	(20)
SELECTED_FOR_RECEIPT_BATCH	VARCHAR2	(1)
SOURCE	VARCHAR2	(50)
CREATOR	VARCHAR2	(100)
UPDATED_BY	VARCHAR2	(100)
ATCHMT_FLAG	VARCHAR2	(4000)
GL_ACCOUNT_SOURCE	VARCHAR2	(30)
TAX_CODE_SOURCE	VARCHAR2	(30)
AMOUNT_APPROVED	NUMBER
AMOUNT_PENDING	NUMBER

Query Text

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


SELECT ROW_ID
,      ACCTD_AMOUNT
,      ADJUSTMENT_ID
,      ADJUSTMENT_NUMBER
,      ADJUSTMENT_TYPE
,      AMOUNT
,      APPLY_DATE
,      APPROVED_BY
,      ASSOCIATED_APPLICATION_ID
,      ASSOCIATED_CASH_RECEIPT_ID
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AUTOMATICALLY_GENERATED
,      BATCH_ID
,      CHARGEBACK_CUSTOMER_TRX_ID
,      CODE_COMBINATION_ID
,      COMMENTS
,      CREATED_BY
,      CREATED_FROM
,      CREATION_DATE
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      DISTRIBUTION_SET_ID
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      FREIGHT_ADJUSTED
,      GL_DATE
,      GL_POSTED_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_ADJUSTED
,      ORG_ID
,      PAYMENT_SCHEDULE_ID
,      POSTABLE
,      POSTING_CONTROL_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REASON_CODE
,      RECEIVABLES_CHARGES_ADJUSTED
,      REC_CHARGES_ADJUSTED
,      RECEIVABLES_TRX_ID
,      REQUEST_ID
,      SET_OF_BOOKS_ID
,      STATUS
,      SUBSEQUENT_TRX_ID
,      TAX_ADJUSTED
,      TYPE
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      ACTIVITY_NAME
,      ACTIVITY_TYPE
,      REASON_MEANING
,      STATUS_MEANING
,      TYPE_MEANING
,      LINE_NUMBER
,      TRX_NUMBER
,      TRX_TYPE
,      TRX_CLASS
,      CREATION_SIGN
,      ALLOW_OVERAPPLICATION_FLAG
,      NATURAL_APPLICATION_ONLY_FLAG
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      INVOICE_CURRENCY_CODE
,      DUE_DATE
,      TRX_GL_DATE
,      TRX_DATE
,      AMOUNT_DUE_ORIGINAL
,      TAX_ORIGINAL
,      FREIGHT_ORIGINAL
,      RECEIVABLES_CHARGES_ORIGINAL
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      TAX_REMAINING
,      FREIGHT_REMAINING
,      RECEIVABLES_CHARGES_REMAINING
,      AMOUNT_LINE_ITEMS_REMAINING
,      CHARGEBACK_NUMBER
,      SELECTED_FOR_RECEIPT_BATCH
,      SOURCE
,      CREATOR
,      UPDATED_BY
,      ATCHMT_FLAG
,      GL_ACCOUNT_SOURCE
,      TAX_CODE_SOURCE
,      AMOUNT_APPROVED
,      AMOUNT_PENDING
FROM APPS.AR_ADJUSTMENTS_V;

Dependencies

[top of page]

APPS.AR_ADJUSTMENTS_V references the following:

APPS: AR_ADJUSTMENTS; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLES_TRX_ALL; FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_USER; HZ_CUST_ACCOUNTS; HZ_PARTIES; RA_BATCH_SOURCES_ALL; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL

APPS.AR_ADJUSTMENTS_V is referenced by following:

APPS: OKL_BPD_AR_ADJUSTMENTS_V; OKL_BPD_AR_ADJ_LINES_V