eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FII_AP_HOLD_DATA_FCV

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)