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_ACTCOST_ADJS_V

Object Details

Object Name:	GMF_XLA_ACTCOST_ADJS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_ACTCOST_ADJS_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 Actual Cost Adjustments

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER		Yes	Ledger Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier from MTL_MATERIAL_TRANSACTIONS table
VALUATION_COST_TYPE_ID	NUMBER		Yes	Valuation Cost Type Identifier
VALUATION_COST_TYPE	VARCHAR2	(50)		Valuation Cost Type Code
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	Event Class Code
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	legal entiry name
ITEM_NAME	VARCHAR2	(40)		Item name
ITEM_DESCRIPTION	VARCHAR2	(240)		item description
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
ADJUSTMENT_DATE	DATE			Adjustment Date
PRIMARY_QUANTITY	VARCHAR2	(44)		Primary Quantity
TRANSACTION_UOM	VARCHAR2	(50)	Yes	Transaction Unit of measure
PRIMARY_UOM_CODE	VARCHAR2	(3)		primary Unit of measure
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary Unit of measure
REASON_CODE	VARCHAR2	(4)	Yes	Reason code
REASON_DESCRIPTION	VARCHAR2	(40)	Yes	Reason Description
CALENDAR_CODE	VARCHAR2	(10)	Yes	Cost calendar code
PERIOD_CODE	VARCHAR2	(10)	Yes	Cost period code
ADJUSTMENT_COST	NUMBER		Yes	Adjustment cost
PERIOD_STATUS	VARCHAR2	(6)		cost period status
ADJUSTMENT_STATUS	VARCHAR2	(11)		Adjustment status
ADJUSTMENT_INDICATOR	VARCHAR2	(18)		Adjustment indicator

Query Text

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


SELECT LEDGER_ID
,      TRANSACTION_ID
,      VALUATION_COST_TYPE_ID
,      VALUATION_COST_TYPE
,      EVENT_CLASS_CODE
,      LEGAL_ENTITY_NAME
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      ORGANIZATION_CODE
,      ADJUSTMENT_DATE
,      PRIMARY_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_UOM_CODE
,      SECONDARY_UOM_CODE
,      REASON_CODE
,      REASON_DESCRIPTION
,      CALENDAR_CODE
,      PERIOD_CODE
,      ADJUSTMENT_COST
,      PERIOD_STATUS
,      ADJUSTMENT_STATUS
,      ADJUSTMENT_INDICATOR
FROM APPS.GMF_XLA_ACTCOST_ADJS_V;

Dependencies

[top of page]

APPS.GMF_XLA_ACTCOST_ADJS_V references the following:

APPS: CM_ADJS_DTL; CM_REAS_CDS; GMF_PERIOD_STATUSES; GMF_XLA_EXTRACT_HEADERS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV; XLE_ENTITY_PROFILES

APPS.GMF_XLA_ACTCOST_ADJS_V is not referenced by any database object