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_LOTCOST_ADJS_V

Object Details

Object Name:	GMF_XLA_LOTCOST_ADJS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_LOTCOST_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 Lot Cost Adjustments View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_NO	NUMBER		Yes	Reference Number
LEDGER_ID	NUMBER		Yes	Ledger Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Id
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	Event Class Code
OPERATING_UNIT	NUMBER			Operating Unit
ADJUSTMENT_ID	NUMBER	(15)	Yes	Surrogate ID for Lot Cost Adjustment
ADJUSTMENT_DATE	DATE		Yes	Date on which adjustment is applicable
PRIMARY_QUANTITY	VARCHAR2	(44)		Transaction Quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure code
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary Unit of Measure
TRANSACTION_UOM	VARCHAR2	(50)	Yes	Transaction Unit Of Measure
SOURCE_DOCUMENT_ID	NUMBER			Source Document Id
SOURCE_LINE_ID	NUMBER			Source Document Line Level Id
LOT_NUMBER	VARCHAR2	(80)		Lot Number
INVENTORY_ITEM_ID	NUMBER	(15)		Item identifier
ITEM_NUMBER	VARCHAR2	(40)		Key flexfield segment
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description is maintained in the installation base language only. Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions in multiple languages
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
ORGANIZATION_ID	NUMBER	(15)		Organization Id
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
VALUATION_COST_TYPE_ID	NUMBER		Yes	Valuation Cost Type Id
VALUATION_COST_TYPE	VARCHAR2	(50)		Valuation Cost Type
REASON_CODE	VARCHAR2	(4)	Yes	Reason Code
APPLIED_IND	VARCHAR2	(11)		Applied Indicator
GL_POSTED_IND	VARCHAR2	(16)		GL Posted Indicator

Query Text

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


SELECT REFERENCE_NO
,      LEDGER_ID
,      TRANSACTION_ID
,      EVENT_CLASS_CODE
,      OPERATING_UNIT
,      ADJUSTMENT_ID
,      ADJUSTMENT_DATE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      SECONDARY_UOM_CODE
,      TRANSACTION_UOM
,      SOURCE_DOCUMENT_ID
,      SOURCE_LINE_ID
,      LOT_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      VALUATION_COST_TYPE_ID
,      VALUATION_COST_TYPE
,      REASON_CODE
,      APPLIED_IND
,      GL_POSTED_IND
FROM APPS.GMF_XLA_LOTCOST_ADJS_V;

Dependencies

[top of page]

APPS.GMF_XLA_LOTCOST_ADJS_V references the following:

APPS: GMF_LOT_COST_ADJUSTMENTS; GMF_XLA_EXTRACT_HEADERS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV; XLE_ENTITY_PROFILES

APPS.GMF_XLA_LOTCOST_ADJS_V is not referenced by any database object