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_ADJ_DIST_UPG_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
LINE_ID	NUMBER		Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger
SOURCE_ID	NUMBER	(15)	Identifier for record in SOURCE_TABLE that created this distribution.
SOURCE_TABLE	VARCHAR2	(10)	Possible values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table.
SOURCE_TYPE	VARCHAR2	(30)	Account type of transaction for which distribution is posted.
CODE_COMBINATION_ID	NUMBER	(15)	Foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. It is the account to create the journals for.
AMOUNT_DR	NUMBER		Journal entry debit amount
AMOUNT_CR	NUMBER		Journal entry credit amount
ACCTD_AMOUNT_DR	NUMBER		Journal entry accounted debit amount
ACCTD_AMOUNT_CR	NUMBER		Journal entry accounted credit amount
ORG_ID	NUMBER	(15)	Organization identifier
SOURCE_TABLE_SECONDARY	VARCHAR2	(10)	Abbreviation that represents another table
SOURCE_ID_SECONDARY	NUMBER		Foreign key for entity in the SOURCE_TABLE_SECONDARY column
CURRENCY_CODE	VARCHAR2	(15)	Code defined for a currency
CURRENCY_CONVERSION_RATE	NUMBER		Exchange rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Supports multiple currency exchange rates for the same date
CURRENCY_CONVERSION_DATE	DATE		Date the currency was converted using the given exchange rate
TAXABLE_ENTERED_DR	NUMBER		Taxable debit that lines of type Tax apply to
TAXABLE_ENTERED_CR	NUMBER		Taxable credit that lines of type Tax apply to
TAXABLE_ACCOUNTED_DR	NUMBER		Accounted taxable debit amount
TAXABLE_ACCOUNTED_CR	NUMBER		Accounted taxable credit amount
TAX_LINK_ID	NUMBER		Links tax and taxable lines within the AR_DISTRIBUTIONS table
THIRD_PARTY_ID	NUMBER		Bill-to customer ID for transactions, paid-from customer ID for receipts
THIRD_PARTY_SUB_ID	NUMBER		Bill-to site use ID for transactions, customer site use ID for receipts
REVERSED_SOURCE_ID	NUMBER		The source ID that the reversal record was created from. Used for receipt application (APP) records to get the debit/credit for the gain/loss account.
TAX_CODE_ID	NUMBER		Foreign key to the AR_VAT_TAX table
LOCATION_SEGMENT_ID	NUMBER		Foreign key to the AR_LOCATION_VALUES table
SOURCE_TYPE_SECONDARY	VARCHAR2	(30)	Source Type Secondary
TAX_GROUP_CODE_ID	NUMBER		Foreign key to the AR_TAX_GROUP_CODES table to identify the tax code's tax group
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)	transaction line identifyer
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)	transaction line distribution identifyer
REF_LINE_ID	NUMBER		Reference to another distribution created via an adjustment
REF_ACCOUNT_CLASS	VARCHAR2	(30)	Account Class to each this distribution is affected
ACTIVITY_BUCKET	VARCHAR2	(30)	Amount bucket to each this distribution is associated
FROM_AMOUNT_DR	NUMBER		Debit amount in the currency of the cash receipt
FROM_AMOUNT_CR	NUMBER		credit amount in the currency of the cash receipt
FROM_ACCTD_AMOUNT_DR	NUMBER		debit amount in the functional currency based on the receipt
FROM_ACCTD_AMOUNT_CR	NUMBER		credit amount in the functional currency based on the receipt
REF_DIST_CCID	NUMBER	(15)	Maintains accounting code combination ID at time of application. Optimizes performance when CCID comes from distribution outside AR, such as PSA multi-funded CCID.
ORIGIN_EXTRACT_TABLE	VARCHAR2	(19)
REF_MF_DIST_FLAG	VARCHAR2	(1)

Query Text

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


SELECT LINE_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_TYPE
,      CODE_COMBINATION_ID
,      AMOUNT_DR
,      AMOUNT_CR
,      ACCTD_AMOUNT_DR
,      ACCTD_AMOUNT_CR
,      ORG_ID
,      SOURCE_TABLE_SECONDARY
,      SOURCE_ID_SECONDARY
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_LINK_ID
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      REVERSED_SOURCE_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      SOURCE_TYPE_SECONDARY
,      TAX_GROUP_CODE_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_LINE_ID
,      REF_ACCOUNT_CLASS
,      ACTIVITY_BUCKET
,      FROM_AMOUNT_DR
,      FROM_AMOUNT_CR
,      FROM_ACCTD_AMOUNT_DR
,      FROM_ACCTD_AMOUNT_CR
,      REF_DIST_CCID
,      ORIGIN_EXTRACT_TABLE
,      REF_MF_DIST_FLAG
FROM APPS.AR_ADJ_DIST_UPG_V;

Dependencies

[top of page]

APPS.AR_ADJ_DIST_UPG_V references the following:

APPS: AR_ADJUSTMENTS_ALL; AR_DISTRIBUTIONS_ALL; AR_NUM_RAN_PKG - show dependent code; PSA_MF_ADJ_DIST_ALL; RA_CUSTOMER_TRX_ALL; RA_CUST_TRX_LINE_GL_DIST_ALL

APPS.AR_ADJ_DIST_UPG_V is not referenced by any database object