Product: | FII - Financial Intelligence |
---|---|
Description: | FII_PA_BUDGET_F_FCV is the EDW Project Budget fact source view |
Implementation/DBA Data: | APPS.FII_PA_BUDGET_F_FCV |
SELECT SEQ_ID
, BUDGET_LINE_PK
, INSTANCE_FK
, SET_OF_BOOKS_FK
, PROJECT_FK
, PROJECT_ORG_FK
, BUDGET_FK
, EXPENDITURE_TYPE_FK
, CURRENCY_GL_FK
, GL_PERIOD_FK
, PA_PERIOD_FK
, UNIT_OF_MEASURE_FK
, RANGE_FROM_DATE
, RANGE_TO_DATE
, DESCRIPTION
, RAW_COST_G
, RAW_COST_B
, BURDENED_COST_G
, BURDENED_COST_B
, QUANTITY
, REVENUE_G
, REVENUE_B
, GLOBAL_CURRENCY_RATE
, LAST_UPDATE_DATE
, TO_NUMBER(NULL) USER_MEASURE1
, TO_NUMBER(NULL) USER_MEASURE2
, TO_NUMBER(NULL) USER_MEASURE3
, TO_NUMBER(NULL) USER_MEASURE4
, TO_NUMBER(NULL) USER_MEASURE5
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
, NULL USER_ATTRIBUTE6
, NULL USER_ATTRIBUTE7
, NULL USER_ATTRIBUTE8
, NULL USER_ATTRIBUTE9
, NULL USER_ATTRIBUTE10
, 'NA_EDW' USER_FK1
, 'NA_EDW' USER_FK2
, 'NA_EDW' USER_FK3
, 'NA_EDW' USER_FK4
, 'NA_EDW' USER_FK5
, TRANSACTION_DATE
FROM FIIBV_PA_BUDGET_F_FCV