VIEW: APPS.FII_PA_REVENUE_F_FCV

Source

View Text - Preformatted

SELECT SEQ_ID, VIEW_TYPE, REVENUE_PK, REVENUE_G, REVENUE_B, INSTANCE_FK, SET_OF_BOOKS_FK, PROJECT_FK, PROJECT_ORG_FK, CUSTOMER_FK, CURRENCY_GL_FK, GL_DATE_FK, PA_DATE_FK, TRANSACTION_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 SET_OF_BOOKS_ID, GLOBAL_CURRENCY_RATE GLOBAL_CURRENCY_RATE, LAST_UPDATE_DATE 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 FROM ( select SEQ_ID, VIEW_TYPE, REVENUE_PK, REVENUE_G, REVENUE_B, INSTANCE_FK, SET_OF_BOOKS_FK, PROJECT_FK, PROJECT_ORG_FK, CUSTOMER_FK, CURRENCY_GL_FK, GL_DATE_FK, PA_DATE_FK, TRANSACTION_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 fiibv_pa_revenue_f_fcv )

View Text - HTML Formatted

SELECT SEQ_ID
, VIEW_TYPE
, REVENUE_PK
, REVENUE_G
, REVENUE_B
, INSTANCE_FK
, SET_OF_BOOKS_FK
, PROJECT_FK
, PROJECT_ORG_FK
, CUSTOMER_FK
, CURRENCY_GL_FK
, GL_DATE_FK
, PA_DATE_FK
, TRANSACTION_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 SET_OF_BOOKS_ID
, GLOBAL_CURRENCY_RATE GLOBAL_CURRENCY_RATE
, LAST_UPDATE_DATE 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
FROM ( SELECT SEQ_ID
, VIEW_TYPE
, REVENUE_PK
, REVENUE_G
, REVENUE_B
, INSTANCE_FK
, SET_OF_BOOKS_FK
, PROJECT_FK
, PROJECT_ORG_FK
, CUSTOMER_FK
, CURRENCY_GL_FK
, GL_DATE_FK
, PA_DATE_FK
, TRANSACTION_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 FIIBV_PA_REVENUE_F_FCV )