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

Object Details

Object Name:	GCS_DYN_TB_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DATASET_CODE	NUMBER		Yes
CAL_PERIOD_ID	NUMBER		Yes
ENTITY_ID	NUMBER
LEDGER_ID	NUMBER		Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
CURRENCY_TYPE_CODE	VARCHAR2	(30)	Yes
SOURCE_SYSTEM_CODE	NUMBER		Yes
COMPANY_COST_CENTER_ORG_ID	NUMBER
INTERCOMPANY_ID	NUMBER
LINE_ITEM_ID	NUMBER
FINANCIAL_ELEM_ID	NUMBER
PRODUCT_ID	NUMBER
NATURAL_ACCOUNT_ID	NUMBER
CHANNEL_ID	NUMBER
PROJECT_ID	NUMBER
CUSTOMER_ID	NUMBER
TASK_ID	NUMBER
USER_DIM1_ID	NUMBER
USER_DIM2_ID	NUMBER
USER_DIM3_ID	NUMBER
USER_DIM4_ID	NUMBER
USER_DIM5_ID	NUMBER
USER_DIM6_ID	NUMBER
USER_DIM7_ID	NUMBER
USER_DIM8_ID	NUMBER
USER_DIM9_ID	NUMBER
USER_DIM10_ID	NUMBER
COMPANY_COST_CENTER_ORG_NAME	VARCHAR2	(150)	Yes
INTERCOMPANY_NAME	VARCHAR2	(150)	Yes
LINE_ITEM_NAME	VARCHAR2	(150)	Yes
FINANCIAL_ELEM_NAME	VARCHAR2	(0)
PRODUCT_NAME	VARCHAR2	(0)
NATURAL_ACCOUNT_NAME	VARCHAR2	(0)
CHANNEL_NAME	VARCHAR2	(0)
PROJECT_NAME	VARCHAR2	(0)
CUSTOMER_NAME	VARCHAR2	(0)
TASK_NAME	VARCHAR2	(0)
USER_DIM1_NAME	VARCHAR2	(0)
USER_DIM2_NAME	VARCHAR2	(0)
USER_DIM3_NAME	VARCHAR2	(0)
USER_DIM4_NAME	VARCHAR2	(0)
USER_DIM5_NAME	VARCHAR2	(0)
USER_DIM6_NAME	VARCHAR2	(0)
USER_DIM7_NAME	VARCHAR2	(0)
USER_DIM8_NAME	VARCHAR2	(0)
USER_DIM9_NAME	VARCHAR2	(0)
USER_DIM10_NAME	VARCHAR2	(0)
COMPANY_COST_CENTER_ORG_DESC	VARCHAR2	(255)
INTERCOMPANY_DESC	VARCHAR2	(255)
LINE_ITEM_DESC	VARCHAR2	(255)
FINANCIAL_ELEM_DESC	VARCHAR2	(0)
PRODUCT_DESC	VARCHAR2	(0)
NATURAL_ACCOUNT_DESC	VARCHAR2	(0)
CHANNEL_DESC	VARCHAR2	(0)
PROJECT_DESC	VARCHAR2	(0)
CUSTOMER_DESC	VARCHAR2	(0)
TASK_DESC	VARCHAR2	(0)
USER_DIM1_DESC	VARCHAR2	(0)
USER_DIM2_DESC	VARCHAR2	(0)
USER_DIM3_DESC	VARCHAR2	(0)
USER_DIM4_DESC	VARCHAR2	(0)
USER_DIM5_DESC	VARCHAR2	(0)
USER_DIM6_DESC	VARCHAR2	(0)
USER_DIM7_DESC	VARCHAR2	(0)
USER_DIM8_DESC	VARCHAR2	(0)
USER_DIM9_DESC	VARCHAR2	(0)
USER_DIM10_DESC	VARCHAR2	(0)
XTD_BALANCE_E	NUMBER
XTD_BALANCE_F	NUMBER
YTD_BALANCE_E	NUMBER
YTD_BALANCE_F	NUMBER

Query Text

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


SELECT DATASET_CODE
,      CAL_PERIOD_ID
,      ENTITY_ID
,      LEDGER_ID
,      CURRENCY_CODE
,      CURRENCY_TYPE_CODE
,      SOURCE_SYSTEM_CODE
,      COMPANY_COST_CENTER_ORG_ID
,      INTERCOMPANY_ID
,      LINE_ITEM_ID
,      FINANCIAL_ELEM_ID
,      PRODUCT_ID
,      NATURAL_ACCOUNT_ID
,      CHANNEL_ID
,      PROJECT_ID
,      CUSTOMER_ID
,      TASK_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
,      USER_DIM10_ID
,      COMPANY_COST_CENTER_ORG_NAME
,      INTERCOMPANY_NAME
,      LINE_ITEM_NAME
,      FINANCIAL_ELEM_NAME
,      PRODUCT_NAME
,      NATURAL_ACCOUNT_NAME
,      CHANNEL_NAME
,      PROJECT_NAME
,      CUSTOMER_NAME
,      TASK_NAME
,      USER_DIM1_NAME
,      USER_DIM2_NAME
,      USER_DIM3_NAME
,      USER_DIM4_NAME
,      USER_DIM5_NAME
,      USER_DIM6_NAME
,      USER_DIM7_NAME
,      USER_DIM8_NAME
,      USER_DIM9_NAME
,      USER_DIM10_NAME
,      COMPANY_COST_CENTER_ORG_DESC
,      INTERCOMPANY_DESC
,      LINE_ITEM_DESC
,      FINANCIAL_ELEM_DESC
,      PRODUCT_DESC
,      NATURAL_ACCOUNT_DESC
,      CHANNEL_DESC
,      PROJECT_DESC
,      CUSTOMER_DESC
,      TASK_DESC
,      USER_DIM1_DESC
,      USER_DIM2_DESC
,      USER_DIM3_DESC
,      USER_DIM4_DESC
,      USER_DIM5_DESC
,      USER_DIM6_DESC
,      USER_DIM7_DESC
,      USER_DIM8_DESC
,      USER_DIM9_DESC
,      USER_DIM10_DESC
,      XTD_BALANCE_E
,      XTD_BALANCE_F
,      YTD_BALANCE_E
,      YTD_BALANCE_F
FROM APPS.GCS_DYN_TB_V;

Dependencies

[top of page]

APPS.GCS_DYN_TB_V references the following:

APPS: FEM_BALANCES; FEM_CCTR_ORGS_TL; FEM_LN_ITEMS_TL

APPS.GCS_DYN_TB_V is not referenced by any database object