Product: | FII - Financial Intelligence (Obsolete) |
---|---|
Description: | FII_PA_COST_F_FCV is the EDW Project Cost fact source view |
Implementation/DBA Data: | Not implemented in this database |
SELECT SEQ_ID
, COST_PK
, RAW_COST_G
, RAW_COST_B
, RAW_COST_T
, BURDENED_COST_G
, BURDENED_COST_B
, BURDENED_COST_T
, QUANTITY
, BILLABLE_FLAG
, INSTANCE_FK
, SET_OF_BOOKS_FK
, PROJECT_FK
, PROJECT_ORG_FK
, EXPENDITURE_ORG_FK
, EXPENDITURE_TYPE_FK
, CURRENCY_GL_FK
, CURRENCY_TRX_FK
, EMPLOYEE_FK
, UNIT_OF_MEASURE_FK
, TRANSACTION_DATE_FK
, PA_DATE_FK
, GL_DATE_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 1
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT1_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 26
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT2_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 51
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT3_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 76
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT4_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 101
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT5_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 126
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT6_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 151
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT7_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 176
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT8_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 201
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT9_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 226
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT10_FK
, SET_OF_BOOKS_ID
, GLOBAL_CURRENCY_RATE
, LAST_UPDATE_DATE
, NULL USER_MEASURE1
, NULL USER_MEASURE2
, NULL USER_MEASURE3
, NULL USER_MEASURE4
, 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
, FROM_CURRENCY
, TRANSACTION_DATE
FROM ( SELECT SEQ_ID
, COST_PK
, RAW_COST_G
, RAW_COST_B
, RAW_COST_T
, BURDENED_COST_G
, BURDENED_COST_B
, BURDENED_COST_T
, QUANTITY
, BILLABLE_FLAG
, INSTANCE_FK
, SET_OF_BOOKS_FK
, PROJECT_FK
, PROJECT_ORG_FK
, EXPENDITURE_ORG_FK
, EXPENDITURE_TYPE_FK
, CURRENCY_GL_FK
, CURRENCY_TRX_FK
, EMPLOYEE_FK
, UNIT_OF_MEASURE_FK
, TRANSACTION_DATE_FK
, PA_DATE_FK
, GL_DATE_FK
, FII_FLEX_MAPPING.GET_VALUE( CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID ) GL_SEG
, SET_OF_BOOKS_ID
, GLOBAL_CURRENCY_RATE
, LAST_UPDATE_DATE
, FROM_CURRENCY
, TRANSACTION_DATE
FROM FIIBV_PA_COST_F_FCV )