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

TABLE: FII.FII_BUDGET_STG

Object Details
Object Name: FII_BUDGET_STG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_BUDGET_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
PLAN_TYPE_CODE VARCHAR2 (2) Yes Budget/Forecast
PRIM_AMOUNT_G NUMBER
Yes Primary Amount Delta
SEC_AMOUNT_G NUMBER

Secondary Amount Delta
CREATION_DATE DATE
Yes Standard Who Columns
CREATED_BY NUMBER
Yes Standard Who Columns
LAST_UPDATE_DATE DATE
Yes Standard Who Columns
LAST_UPDATED_BY NUMBER
Yes Standard Who Columns
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Columns
DAY NUMBER (15)
Day
WEEK NUMBER (15)
Week
PERIOD NUMBER (15)
Period
QUARTER NUMBER (15)
Quarter
YEAR NUMBER (15)
Year
COMPANY_COST_CENTER_ORG_ID NUMBER (15)
Company Cost Center Org Identifier
LINE_OF_BUSINESS VARCHAR2 (150)
Line of Business
NATURAL_ACCOUNT VARCHAR2 (25)
Natural Account
FIN_ITEM VARCHAR2 (150)
Financial Item
PRODUCT_CODE VARCHAR2 (150)
Product Code
CATEGORY_ID NUMBER

Category identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
LEDGER_ID NUMBER (15)
Ledger Identifier
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost Center Identifier
USER_DIM1_ID NUMBER (15)
User-defined Dimension 1 Identifier
USER_DIM2_ID NUMBER (15)
User-defined Dimension 2 Identifier
PRIM_AMOUNT_TOTAL NUMBER

Primary Amount
SEC_AMOUNT_TOTAL NUMBER

Secondary Amount
VERSION_DATE DATE

Version Date
OVERWRITE_VERSION_DATE DATE

Overwrite Version Date
NO_VERSION_FLAG VARCHAR2 (1)
No Version Flag
DATA_TYPE NUMBER (15)
Data Type
POSTED_DATE DATE

Posted Date
BASELINE_AMOUNT_PRIM NUMBER

Baseline Amount Primary
CODE_COMBINATION_ID NUMBER

Code Combination Identifier
BUDGET_VERSION_ID NUMBER

Budget Identifier
Query Text

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


SELECT PLAN_TYPE_CODE
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DAY
,      WEEK
,      PERIOD
,      QUARTER
,      YEAR
,      COMPANY_COST_CENTER_ORG_ID
,      LINE_OF_BUSINESS
,      NATURAL_ACCOUNT
,      FIN_ITEM
,      PRODUCT_CODE
,      CATEGORY_ID
,      FIN_CATEGORY_ID
,      LEDGER_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      PRIM_AMOUNT_TOTAL
,      SEC_AMOUNT_TOTAL
,      VERSION_DATE
,      OVERWRITE_VERSION_DATE
,      NO_VERSION_FLAG
,      DATA_TYPE
,      POSTED_DATE
,      BASELINE_AMOUNT_PRIM
,      CODE_COMBINATION_ID
,      BUDGET_VERSION_ID
FROM FII.FII_BUDGET_STG;

Dependencies

[top of page]

FII.FII_BUDGET_STG does not reference any database object

FII.FII_BUDGET_STG is referenced by following:

SchemaAPPS
SynonymFII_BUDGET_STG