DBA Data[Home] [Help] [Dependency Information]

TABLE: APPS.FEM_BAL_LIEXCC_ATTR_MV

Object Details
Object Name: FEM_BAL_LIEXCC_ATTR_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_BAL_LIEXCC_ATTR_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnLEDGER_ID
ColumnDATASET_CODE
ColumnCAL_PERIOD_ID
ColumnCURRENCY_CODE
ColumnCOMPANY_COST_CENTER_ORG_ID
ColumnCOMPANY_COST_CENTER_ORG_VS_ID
ColumnLINE_ITEM_ID
ColumnLINE_ITEM_VS_ID
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER
Yes
DATASET_CODE NUMBER
Yes
CAL_PERIOD_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
COMPANY_COST_CENTER_ORG_ID NUMBER

COMPANY_COST_CENTER_ORG_VS_ID NUMBER

LINE_ITEM_ID NUMBER

LINE_ITEM_VS_ID NUMBER

EXTENDED_ACCOUNT_TYPE VARCHAR2 (30)
BASIC_ACCOUNT_TYPE VARCHAR2 (30)
EXTENDED_ACCOUNT_SIGN NUMBER

XTD_BALANCE_E NUMBER

XTD_BALANCE_F NUMBER

QTD_BALANCE_E NUMBER

QTD_BALANCE_F NUMBER

YTD_BALANCE_E NUMBER

YTD_BALANCE_F NUMBER

PTD_CREDIT_BALANCE_E NUMBER

PTD_DEBIT_BALANCE_E NUMBER

YTD_CREDIT_BALANCE_E NUMBER

YTD_DEBIT_BALANCE_E NUMBER

Query Text

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


SELECT LEDGER_ID
,      DATASET_CODE
,      CAL_PERIOD_ID
,      CURRENCY_CODE
,      COMPANY_COST_CENTER_ORG_ID
,      COMPANY_COST_CENTER_ORG_VS_ID
,      LINE_ITEM_ID
,      LINE_ITEM_VS_ID
,      EXTENDED_ACCOUNT_TYPE
,      BASIC_ACCOUNT_TYPE
,      EXTENDED_ACCOUNT_SIGN
,      XTD_BALANCE_E
,      XTD_BALANCE_F
,      QTD_BALANCE_E
,      QTD_BALANCE_F
,      YTD_BALANCE_E
,      YTD_BALANCE_F
,      PTD_CREDIT_BALANCE_E
,      PTD_DEBIT_BALANCE_E
,      YTD_CREDIT_BALANCE_E
,      YTD_DEBIT_BALANCE_E
FROM APPS.FEM_BAL_LIEXCC_ATTR_MV;

Dependencies

[top of page]

APPS.FEM_BAL_LIEXCC_ATTR_MV does not reference any database object

APPS.FEM_BAL_LIEXCC_ATTR_MV is referenced by following:

SchemaAPPS
Materialized ViewFEM_BAL_LIEXCC_ATTR_MV