[Home] [Help] [Dependency Information]
Object Name: | GCS_DYN_TB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.GCS_DYN_TB_V is not referenced by any database object
|
|
|