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

Object Details

Object Name:	GMF_XLA_COST_RVAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_COST_RVAL_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for SLA ADR sources from Cost Revaluation

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	transaction identifier
LEDGER_ID	NUMBER	(15)	Yes	ledger identifier
VALUATION_COST_TYPE_ID	NUMBER		Yes	cost type identifier
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	event class code
LEDGER_NAME	VARCHAR2	(30)	Yes	ledger name
VALUATION_COST_TYPE	VARCHAR2	(50)		cost type
DOCUMENT_NUMBER	VARCHAR2	(40)		document number
ACCT_PERIOD_ID	VARCHAR2	(40)		Accounting period identifier
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	GL period set name
PERIOD_YEAR	VARCHAR2	(40)		GL period year
PERIOD_NUM	VARCHAR2	(40)		GL period number
PERIOD_NAME	VARCHAR2	(15)	Yes	GL period name
PERIOD_DESCRIPTION	VARCHAR2	(50)		Description - (not currently used)
PERIOD_START_DATE	DATE		Yes	Start date of accounting period
SCHEDULE_CLOSE_DATE	DATE		Yes	Scheduled close date of the accounting period
PERIOD_CLOSE_DATE	DATE			Actual close date of the accounting period
OPEN_FLAG	VARCHAR2	(1)	Yes	indicates the status of the period: 'P' if the period close is processing; 'N' if the period is closed; 'Y' if the period is either open (if period close date is NULL) or the period close has failed (if period close date is not NULL)
SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates whether this period has been summarized.
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
SUBINVENTORY_CODE	VARCHAR2	(10)		subinventory code
ITEM_NAME	VARCHAR2	(40)		item name
LOT_NUMBER	VARCHAR2	(80)		lot number
PRIMARY_QUANTITY	VARCHAR2	(44)		primary quantity
INTRANSIT_PRIMARY_QUANTITY	VARCHAR2	(40)		intransit primary quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		primary unit of measure
SECONDARY_QUANTITY	VARCHAR2	(40)		secondary quantity
INTRANSIT_SECONDARY_QUANTITY	VARCHAR2	(40)		intransit secondary quantity
SECONDARY_UOM_CODE	VARCHAR2	(3)		secondary unit of measure
TRANSACTION_DATE	DATE		Yes	transaction date

Query Text

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


SELECT TRANSACTION_ID
,      LEDGER_ID
,      VALUATION_COST_TYPE_ID
,      EVENT_CLASS_CODE
,      LEDGER_NAME
,      VALUATION_COST_TYPE
,      DOCUMENT_NUMBER
,      ACCT_PERIOD_ID
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_NAME
,      PERIOD_DESCRIPTION
,      PERIOD_START_DATE
,      SCHEDULE_CLOSE_DATE
,      PERIOD_CLOSE_DATE
,      OPEN_FLAG
,      SUMMARIZED_FLAG
,      ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      ITEM_NAME
,      LOT_NUMBER
,      PRIMARY_QUANTITY
,      INTRANSIT_PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      SECONDARY_QUANTITY
,      INTRANSIT_SECONDARY_QUANTITY
,      SECONDARY_UOM_CODE
,      TRANSACTION_DATE
FROM APPS.GMF_XLA_COST_RVAL_V;

Dependencies

[top of page]

APPS.GMF_XLA_COST_RVAL_V references the following:

APPS: GL_LEDGERS; GMF_PERIOD_BALANCES; GMF_XLA_EXTRACT_HEADERS; MTL_ITEM_FLEXFIELDS; MTL_PARAMETERS; ORG_ACCT_PERIODS

APPS.GMF_XLA_COST_RVAL_V is not referenced by any database object