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_INV_ON_HOLD_FCV

Source

View Text - Preformatted


SELECT SEQ_ID, CCID, CREATION_DATE, DELETION_DATE, EMPLOYEE_FK, EXCHANGE_DATE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, GEOGRAPHY_FK, INSTANCE, INSTANCE_FK, INV_AMT_ON_HOLD_B, INV_AMT_ON_HOLD_G, INV_AMT_ON_HOLD_T, INV_CURRENCY_FK, INV_DATE_FK, INV_FK, INV_NUM, INV_ON_HOLD_COUNT, INV_ON_HOLD_PK, INV_SOURCE_FK, INV_TYPE, LAST_UPDATE_DATE, ORG_FK, PAYMENT_TERM_FK, SIC_CODE_FK, DUNS_FK, SOB_FK, SUPPLIER_FK, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, 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, 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, GL_DATE, INVOICE_DATE FROM ( SELECT SEQ_ID, CCID, CREATION_DATE, DELETION_DATE, EMPLOYEE_FK, EXCHANGE_DATE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, GEOGRAPHY_FK, INSTANCE, INSTANCE_FK, INV_AMT_ON_HOLD_B, INV_AMT_ON_HOLD_G, INV_AMT_ON_HOLD_T, INV_CURRENCY_FK, INV_DATE_FK, INV_FK, INV_NUM, INV_ON_HOLD_COUNT, INV_ON_HOLD_PK, INV_SOURCE_FK, INV_TYPE, LAST_UPDATE_DATE, ORG_FK, PAYMENT_TERM_FK, SIC_CODE_FK, DUNS_FK, SOB_FK, SUPPLIER_FK, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, FROM_CURRENCY, GL_DATE, INVOICE_DATE, fii_flex_mapping.get_value( CCID, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID) GL_SEG FROM FIIBV_AP_INV_ON_HOLD_FCV)

View Text - HTML Formatted

SELECT SEQ_ID
, CCID
, CREATION_DATE
, DELETION_DATE
, EMPLOYEE_FK
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INV_AMT_ON_HOLD_B
, INV_AMT_ON_HOLD_G
, INV_AMT_ON_HOLD_T
, INV_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_NUM
, INV_ON_HOLD_COUNT
, INV_ON_HOLD_PK
, INV_SOURCE_FK
, INV_TYPE
, LAST_UPDATE_DATE
, ORG_FK
, PAYMENT_TERM_FK
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, 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
, 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
, GL_DATE
, INVOICE_DATE
FROM ( SELECT SEQ_ID
, CCID
, CREATION_DATE
, DELETION_DATE
, EMPLOYEE_FK
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INV_AMT_ON_HOLD_B
, INV_AMT_ON_HOLD_G
, INV_AMT_ON_HOLD_T
, INV_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_NUM
, INV_ON_HOLD_COUNT
, INV_ON_HOLD_PK
, INV_SOURCE_FK
, INV_TYPE
, LAST_UPDATE_DATE
, ORG_FK
, PAYMENT_TERM_FK
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, FROM_CURRENCY
, GL_DATE
, INVOICE_DATE
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID) GL_SEG
FROM FIIBV_AP_INV_ON_HOLD_FCV)