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

TABLE: FII.FII_GL_JE_SUMMARY_STG

Object Details
Object Name: FII_GL_JE_SUMMARY_STG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_GL_JE_SUMMARY_STG
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DAY NUMBER (15)
Day Name
WEEK NUMBER (15)
Week Name
PERIOD NUMBER (15)
Period Name
QUARTER NUMBER (15)
Quarter Name
YEAR NUMBER (15)
Year Name
COST_CENTER_ORG_ID NUMBER (15)
No longer used
PROD_CATEGORY_ID NUMBER (15)
Product Category identifier
EFFECTIVE_DATE DATE
Yes Effective Date
JE_SOURCE VARCHAR2 (25) Yes Journal Entry Source
JE_CATEGORY VARCHAR2 (25) Yes Journal Entry Category
SET_OF_BOOKS_ID NUMBER (15)
No longer used.
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes Key flexfield structure defining column
FUNCTIONAL_CURRENCY VARCHAR2 (15) Yes Functional currency code
AMOUNT_B NUMBER

Total amount in Accounting currency
PRIM_AMOUNT_G NUMBER

Amount in the primary currency
SEC_AMOUNT_G NUMBER

Amount in the secondarry currency
PRIM_CONVERSION_RATE NUMBER

Conversion rate to the primary currency
SEC_CONVERSION_RATE NUMBER

Conversion rate to the secondarry currency
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost Center Identifier
USER_DIM1_ID NUMBER (15)
User Dimension1 Identifier
USER_DIM2_ID NUMBER (15)
User Dimension2 Identifier
POSTED_DATE DATE

Posted date for the journals
COMMITTED_AMOUNT_B NUMBER

Committed amount in Accounting currency
COMMITTED_AMOUNT_PRIM NUMBER

Committed amount in primary global currency
OBLIGATED_AMOUNT_B NUMBER

Obligated amount in Accouting currency
OBLIGATED_AMOUNT_PRIM NUMBER

Obligated amount in primary global currency
OTHER_AMOUNT_B NUMBER

Amount in accounting currency which is either not committed or obligated for encumbrances
OTHER_AMOUNT_PRIM NUMBER

Amount in primary global currency which is either not committed or obligated for encumbrances
LEDGER_ID NUMBER (15) Yes Ledger Identifier
Query Text

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


SELECT DAY
,      WEEK
,      PERIOD
,      QUARTER
,      YEAR
,      COST_CENTER_ORG_ID
,      PROD_CATEGORY_ID
,      EFFECTIVE_DATE
,      JE_SOURCE
,      JE_CATEGORY
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      FUNCTIONAL_CURRENCY
,      AMOUNT_B
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      POSTED_DATE
,      COMMITTED_AMOUNT_B
,      COMMITTED_AMOUNT_PRIM
,      OBLIGATED_AMOUNT_B
,      OBLIGATED_AMOUNT_PRIM
,      OTHER_AMOUNT_B
,      OTHER_AMOUNT_PRIM
,      LEDGER_ID
FROM FII.FII_GL_JE_SUMMARY_STG;

Dependencies

[top of page]

FII.FII_GL_JE_SUMMARY_STG does not reference any database object

FII.FII_GL_JE_SUMMARY_STG is referenced by following:

SchemaAPPS
SynonymFII_GL_JE_SUMMARY_STG