VIEW: APPS.FII_PA_BUDGET_F_FCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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