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]

TABLE: GMF.GMF_TRANSACTION_VALUATION

Object Details

Object Name:	GMF_TRANSACTION_VALUATION
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GMF_TRANSACTION_VALUATION
Subobject Name:
Status:	VALID

Transaction Valuation table for process organizations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_TRANSACTION_VALUATION_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VALUATION_ID
GMF_TRANSACTION_VALUATION_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FINAL_POSTING_DATE
GMF_TRANSACTION_VALUATION_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTED_FLAG
GMF_TRANSACTION_VALUATION_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE TRANSACTION_ID
GMF_TRANSACTION_VALUATION_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID LEDGER_ID VALUATION_COST_TYPE_ID EVENT_CLASS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
VALUATION_ID	NUMBER	(15)	Yes	Valuation row identifier
HEADER_ID	NUMBER	(15)	Yes	SLA Extract header identifier
EVENT_ID	NUMBER	(15)		SLA Accounting event identifier
LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity identifier
LEDGER_CURRENCY	VARCHAR2	(15)	Yes	Ledger currency
VALUATION_COST_TYPE	VARCHAR2	(10)		Cost Type used for valuations in this ledger
VALUATION_COST_TYPE_ID	NUMBER	(15)		Cost Type identifier
REFERENCE_NO	NUMBER	(15)	Yes	Accounting pre-processor reference number
TRANSACTION_SOURCE_TYPE	VARCHAR2	(40)	Yes	Transaction Source Type
TRANSACTION_SOURCE	VARCHAR2	(40)	Yes	Transaction Source
TRANSACTION_ID	NUMBER	(15)		transaction identifier
DOC_ID	NUMBER	(15)		Source Document identifier
LINE_ID	NUMBER	(15)		Source Line identifier
ORG_ID	NUMBER	(15)		Operating Unit identifier
ORGANIZATION_ID	NUMBER	(15)		Inventory Organization identifier
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item identifier
ITEM_NUMBER	VARCHAR2	(2000)		Item Number
LOT_NUMBER	VARCHAR2	(80)		Lot Number
RESOURCES	VARCHAR2	(16)		Resource code
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
TRANSACTION_DATE	DATE			Transaction Date
TRANSACTION_SOURCE_TYPE_ID	NUMBER	(15)		Transaction Source Type
TRANSACTION_ACTION_ID	NUMBER	(15)		Transaction Action
TRANSACTION_TYPE_ID	NUMBER	(15)		Transaction Type
JOURNAL_LINE_TYPE	VARCHAR2	(40)		SLA Journal Line Type
ENTITY_CODE	VARCHAR2	(40)		SLA Entity Code
EVENT_CLASS_CODE	VARCHAR2	(40)		SLA Event Class Code
EVENT_TYPE_CODE	VARCHAR2	(40)		SLA Event Type Code
COMPONENT_CLASS_USAGE	VARCHAR2	(16)		Cost Component Usage
COST_LEVEL	NUMBER	(2)		Cost Level
TXN_BASE_VALUE_RAW	NUMBER			Transaction Raw Base Value
TXN_BASE_VALUE	NUMBER			Transaction Rounded Base Value
FINAL_POSTING_DATE	DATE			Date when transaction is final accounted in SLA
ACCOUNTED_FLAG	VARCHAR2	(2)		Accounted Flag: N = New; D = Draft Accounted; Null = Final Accounted
LINE_TYPE	NUMBER	(5)		Line Type of the document line
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Who column
PROGRAM_ID	NUMBER	(15)		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
REQUEST_ID	NUMBER	(15)		Concurrent Who column
COMPONENT_CLASS_USAGE_TYPE	NUMBER	(3)		Cost Component Class Usage Indicator

Query Text

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


SELECT VALUATION_ID
,      HEADER_ID
,      EVENT_ID
,      LEDGER_ID
,      LEGAL_ENTITY_ID
,      LEDGER_CURRENCY
,      VALUATION_COST_TYPE
,      VALUATION_COST_TYPE_ID
,      REFERENCE_NO
,      TRANSACTION_SOURCE_TYPE
,      TRANSACTION_SOURCE
,      TRANSACTION_ID
,      DOC_ID
,      LINE_ID
,      ORG_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      LOT_NUMBER
,      RESOURCES
,      SUBINVENTORY_CODE
,      TRANSACTION_DATE
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TYPE_ID
,      JOURNAL_LINE_TYPE
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      COMPONENT_CLASS_USAGE
,      COST_LEVEL
,      TXN_BASE_VALUE_RAW
,      TXN_BASE_VALUE
,      FINAL_POSTING_DATE
,      ACCOUNTED_FLAG
,      LINE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      COMPONENT_CLASS_USAGE_TYPE
FROM GMF.GMF_TRANSACTION_VALUATION;

Dependencies

[top of page]

GMF.GMF_TRANSACTION_VALUATION does not reference any database object

GMF.GMF_TRANSACTION_VALUATION is referenced by following:

GMF: GMF_TRANSACTION_VALUATION#