Product: | FII - Financial Intelligence |
---|---|
Description: | FII_AP_HOLD_DATA_FCV is the collection view for FII_AP_HOLD_DATA_F fact |
Implementation/DBA Data: | APPS.FII_AP_HOLD_DATA_FCV |
SELECT SEQ_ID
, HOLD_DATA_PK
, INSTANCE_FK
, DUNS_FK
, GEOGRAPHY_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
, HOLD_BY_EMPLOYEE_FK
, HOLD_DATE_FK
, HOLD_FK
, INV_CURRENCY_FK
, INV_FK
, INV_SOURCE_FK
, ORG_FK
, PAYMENT_TERM_FK
, RELEASE_FK
, SIC_CODE_FK
, SUPPLIER_FK
, SOB_FK
, HELD_BY
, HOLD_COUNT
, HOLD_DATE
, HOLD_LOOKUP_CODE
, HOLD_REASON
, HOLD_RELEASE_COUNT
, HOLD_RELEASE_DAYS
, INSTANCE
, INV_AMT_B
, INV_AMT_G
, INV_AMT_T
, INV_NUM
, INV_SOURCE
, INV_TYPE
, RELEASE_LOOKUP_CODE
, RELEASE_REASON
, SUPPLIER_SITE_ID
, CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, EXCHANGE_RATE_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, FROM_CURRENCY
, TRANSACTION_DATE
, GL_DATE
, INVOICE_DATE
FROM ( SELECT SEQ_ID
, HOLD_DATA_PK
, INSTANCE_FK
, DUNS_FK
, GEOGRAPHY_FK
, HOLD_BY_EMPLOYEE_FK
, HOLD_DATE_FK
, HOLD_FK
, INV_CURRENCY_FK
, INV_FK
, INV_SOURCE_FK
, ORG_FK
, PAYMENT_TERM_FK
, RELEASE_FK
, SIC_CODE_FK
, SUPPLIER_FK
, SOB_FK
, HELD_BY
, HOLD_COUNT
, HOLD_DATE
, HOLD_LOOKUP_CODE
, HOLD_REASON
, HOLD_RELEASE_COUNT
, HOLD_RELEASE_DAYS
, INSTANCE
, INV_AMT_B
, INV_AMT_G
, INV_AMT_T
, INV_NUM
, INV_SOURCE
, INV_TYPE
, RELEASE_LOOKUP_CODE
, RELEASE_REASON
, SUPPLIER_SITE_ID
, CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, EXCHANGE_RATE_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, FROM_CURRENCY
, TRANSACTION_DATE
, GL_DATE
, INVOICE_DATE
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID) GL_SEG
FROM FIIBV_AP_HOLD_DATA_FCV)