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.CST_RCV_RRSL_V

Object Details

Object Name:	CST_RCV_RRSL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_RCV_RRSL_V
Subobject Name:
Status:	VALID

View on the Receiving Subledger table. Selects details of the receipt accounting.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique Row Identifier
ACCOUNTING_EVENT_ID	NUMBER			Accounting Event Unique Identifier
RCV_TRANSACTION_ID	NUMBER		Yes	Receiving Transaction Unique Identifier
ACCOUNTING_DATE	DATE		Yes	Effective transaction date
ACCOUNTED_DR	NUMBER			Debit amount in base currency
ACCOUNTED_CR	NUMBER			Credit amount in base currency
ENTERED_DR	NUMBER			Debit amount in entered currency
ENTERED_CR	NUMBER			Credit amount in entered currency
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_RATE	NUMBER			Currency exchange rate
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Base currency unique identifier
CHART_OF_ACCOUNTS_ID	NUMBER			Chart of accounts unique identifier
ACCOUNTING_LINE_TYPE	VARCHAR2	(30)		Accounting Line Type
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency unique identifier
CODE_COMBINATION_ID	NUMBER			GL account unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT ROW_ID
,      ACCOUNTING_EVENT_ID
,      RCV_TRANSACTION_ID
,      ACCOUNTING_DATE
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENTERED_DR
,      ENTERED_CR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      FUNCTIONAL_CURRENCY_CODE
,      CHART_OF_ACCOUNTS_ID
,      ACCOUNTING_LINE_TYPE
,      CURRENCY_CODE
,      CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.CST_RCV_RRSL_V;

Dependencies

[top of page]

APPS.CST_RCV_RRSL_V references the following:

APPS: RCV_RECEIVING_SUB_LEDGER

APPS.CST_RCV_RRSL_V is not referenced by any database object