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: FEM.FEM_TRANS_COMMERCIAL

Object Details

Object Name:	FEM_TRANS_COMMERCIAL
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

Commercial Transactions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period
COST	NUMBER			Cost
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Created by Object
CREATED_BY_REQUEST_ID	NUMBER		Yes	Created by Request
DATASET_CODE	NUMBER		Yes	Dataset Code
ID_NUMBER	NUMBER		Yes	ID Number
LAST_UPDATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Last Updated by Object
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Last Updated by Request
LEDGER_ID	NUMBER		Yes	Ledger ID
SOURCE_SYSTEM_CODE	NUMBER		Yes	Source System Code
VOLUME	NUMBER		Yes	Volume
ACTIVITY_ID	NUMBER			Activity
CHANNEL_ID	NUMBER			Channel
COMPANY_COST_CENTER_ORG_ID	NUMBER			Company Cost Center Organization
COST_OBJECT_ID	NUMBER			Cost Object
CURRENCY_CODE	VARCHAR2	(15)		Currency
CUSTOMER_ID	NUMBER			Customer
ENTITY_ID	NUMBER			Entity
FINANCIAL_ELEM_ID	NUMBER			Financial Element
GEOGRAPHY_ID	NUMBER			Geography
INTERCOMPANY_ID	NUMBER			Inter Company
LINE_ITEM_ID	NUMBER			Line Item
NATURAL_ACCOUNT_ID	NUMBER			Natural Account
PRODUCT_ID	NUMBER			Product
PROJECT_ID	NUMBER			Project
TASK_ID	NUMBER			Task
USER_DIM10_ID	NUMBER			User Defined Dimension #10
USER_DIM1_ID	NUMBER			User Defined Dimension #1
USER_DIM2_ID	NUMBER			User Defined Dimension #2
USER_DIM3_ID	NUMBER			User Defined Dimension #3
USER_DIM4_ID	NUMBER			User Defined Dimension #4
USER_DIM5_ID	NUMBER			User Defined Dimension #5
USER_DIM6_ID	NUMBER			User Defined Dimension #6
USER_DIM7_ID	NUMBER			User Defined Dimension #7
USER_DIM8_ID	NUMBER			User Defined Dimension #8
USER_DIM9_ID	NUMBER			User Defined Dimension #9

Query Text

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


SELECT CAL_PERIOD_ID
,      COST
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      DATASET_CODE
,      ID_NUMBER
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      SOURCE_SYSTEM_CODE
,      VOLUME
,      ACTIVITY_ID
,      CHANNEL_ID
,      COMPANY_COST_CENTER_ORG_ID
,      COST_OBJECT_ID
,      CURRENCY_CODE
,      CUSTOMER_ID
,      ENTITY_ID
,      FINANCIAL_ELEM_ID
,      GEOGRAPHY_ID
,      INTERCOMPANY_ID
,      LINE_ITEM_ID
,      NATURAL_ACCOUNT_ID
,      PRODUCT_ID
,      PROJECT_ID
,      TASK_ID
,      USER_DIM10_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      USER_DIM3_ID
,      USER_DIM4_ID
,      USER_DIM5_ID
,      USER_DIM6_ID
,      USER_DIM7_ID
,      USER_DIM8_ID
,      USER_DIM9_ID
FROM FEM.FEM_TRANS_COMMERCIAL;

Dependencies

[top of page]

FEM.FEM_TRANS_COMMERCIAL does not reference any database object

FEM.FEM_TRANS_COMMERCIAL is referenced by following:

APPS: FEM_TRANS_COMMERCIAL