VIEW: APPS.FII_AP_INV_PAYMTS_FCV

Source

View Text - Preformatted

SELECT SEQ_ID, ACCOUNTING_DATE, ACCRUAL_POSTED_FLAG, ASSETS_ADDITION_FLAG, BANK_ACCOUNT_ID, BASE_CURRENCY_CODE, CASH_JE_BATCH_ID, CASH_POSTED_FLAG, CCID, CHECK_DATE, CREATION_DATE, DISC_AMT_LOST_B, DISC_AMT_LOST_G, DISC_AMT_LOST_T, EARLY_DISC_PAYMENT_AMT_B, EARLY_DISC_PAYMENT_AMT_G, EARLY_DISC_PAYMENT_AMT_T, EARLY_DISC_PAYMENT_DAYS, EARLY_DISC_PAYMENT_COUNT, EARLY_NET_PAYMENT_AMT_B, EARLY_NET_PAYMENT_AMT_G, EARLY_NET_PAYMENT_AMT_T, EARLY_NET_PAYMENT_COUNT, EARLY_NET_PAYMENT_DAYS, EMPLOYEE_FK, FUTURE_PAY_POSTED_FLAG, GEOGRAPHY_FK, INSTANCE, INSTANCE_FK, INVOICE_DATE, INV_CURRENCY_CODE, INV_EXCHANGE_DATE, INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, INV_FK, INV_NUM, INV_PAYMENT_PK, INV_PAYMENT_STATUS_FLAG, INV_PAYMENT_TYPE, INV_SOURCE, INV_SOURCE_FK, INV_TYPE, JE_BATCH_ID, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, LATE_DISC_DAYS, LATE_DISC_PAYMENT_AMT_B, LATE_DISC_PAYMENT_AMT_G, LATE_DISC_PAYMENT_AMT_T, LATE_DISC_PAYMENT_COUNT, LATE_NET_PAYMENT_AMT_B, LATE_NET_PAYMENT_AMT_G, LATE_NET_PAYMENT_AMT_T, LATE_NET_PAYMENT_COUNT, LATE_NET_PAYMENT_DAYS, ORG_FK, PAYMENT_AMT_B, PAYMENT_AMT_G, PAYMENT_AMT_T, PAYMENT_COUNT, PAYMENT_CURRENCY_CODE, PAYMENT_CURRENCY_FK, PAYMENT_DATE_FK, DISC_AMT_TAKEN_B, DISC_AMT_TAKEN_G, DISC_AMT_TAKEN_T, PAYMENT_EXCHANGE_DATE, PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_RATE_TYPE, PAYMENT_FK, PAYMENT_TERM_FK, POSTED_FLAG, 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, CHECK_AMT_B, CHECK_AMT_T, CHECK_AMT_G, CHECK_NUMBER FROM ( SELECT SEQ_ID, ACCOUNTING_DATE, ACCRUAL_POSTED_FLAG, ASSETS_ADDITION_FLAG, BANK_ACCOUNT_ID, BASE_CURRENCY_CODE, CASH_JE_BATCH_ID, CASH_POSTED_FLAG, CCID, CHECK_DATE, CREATION_DATE, DISC_AMT_LOST_B, DISC_AMT_LOST_G, DISC_AMT_LOST_T, EARLY_DISC_PAYMENT_AMT_B, EARLY_DISC_PAYMENT_AMT_G, EARLY_DISC_PAYMENT_AMT_T, EARLY_DISC_PAYMENT_DAYS, EARLY_DISC_PAYMENT_COUNT, EARLY_NET_PAYMENT_AMT_B, EARLY_NET_PAYMENT_AMT_G, EARLY_NET_PAYMENT_AMT_T, EARLY_NET_PAYMENT_COUNT, EARLY_NET_PAYMENT_DAYS, EMPLOYEE_FK, FUTURE_PAY_POSTED_FLAG, GEOGRAPHY_FK, INSTANCE, INSTANCE_FK, INVOICE_DATE, INV_CURRENCY_CODE, INV_EXCHANGE_DATE, INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, INV_FK, INV_NUM, INV_PAYMENT_PK, INV_PAYMENT_STATUS_FLAG, INV_PAYMENT_TYPE, INV_SOURCE, INV_SOURCE_FK, INV_TYPE, JE_BATCH_ID, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, LATE_DISC_DAYS, LATE_DISC_PAYMENT_AMT_B, LATE_DISC_PAYMENT_AMT_G, LATE_DISC_PAYMENT_AMT_T, LATE_DISC_PAYMENT_COUNT, LATE_NET_PAYMENT_AMT_B, LATE_NET_PAYMENT_AMT_G, LATE_NET_PAYMENT_AMT_T, LATE_NET_PAYMENT_COUNT, LATE_NET_PAYMENT_DAYS, ORG_FK, PAYMENT_AMT_B, PAYMENT_AMT_G, PAYMENT_AMT_T, PAYMENT_COUNT, PAYMENT_CURRENCY_CODE, PAYMENT_CURRENCY_FK, PAYMENT_DATE_FK, DISC_AMT_TAKEN_B, DISC_AMT_TAKEN_G, DISC_AMT_TAKEN_T, PAYMENT_EXCHANGE_DATE, PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_RATE_TYPE, PAYMENT_FK, PAYMENT_TERM_FK, POSTED_FLAG, SIC_CODE_FK, DUNS_FK, SOB_FK, SUPPLIER_FK, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, fii_flex_mapping.get_value( CCID, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID) GL_SEG, CHECK_AMT_B, CHECK_AMT_T, CHECK_AMT_G, CHECK_NUMBER FROM FIIBV_AP_INV_PAYMTS_FCV)

View Text - HTML Formatted

SELECT SEQ_ID
, ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG
, BANK_ACCOUNT_ID
, BASE_CURRENCY_CODE
, CASH_JE_BATCH_ID
, CASH_POSTED_FLAG
, CCID
, CHECK_DATE
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, EARLY_DISC_PAYMENT_AMT_B
, EARLY_DISC_PAYMENT_AMT_G
, EARLY_DISC_PAYMENT_AMT_T
, EARLY_DISC_PAYMENT_DAYS
, EARLY_DISC_PAYMENT_COUNT
, EARLY_NET_PAYMENT_AMT_B
, EARLY_NET_PAYMENT_AMT_G
, EARLY_NET_PAYMENT_AMT_T
, EARLY_NET_PAYMENT_COUNT
, EARLY_NET_PAYMENT_DAYS
, EMPLOYEE_FK
, FUTURE_PAY_POSTED_FLAG
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INVOICE_DATE
, INV_CURRENCY_CODE
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, INV_FK
, INV_NUM
, INV_PAYMENT_PK
, INV_PAYMENT_STATUS_FLAG
, INV_PAYMENT_TYPE
, INV_SOURCE
, INV_SOURCE_FK
, INV_TYPE
, JE_BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LATE_DISC_DAYS
, LATE_DISC_PAYMENT_AMT_B
, LATE_DISC_PAYMENT_AMT_G
, LATE_DISC_PAYMENT_AMT_T
, LATE_DISC_PAYMENT_COUNT
, LATE_NET_PAYMENT_AMT_B
, LATE_NET_PAYMENT_AMT_G
, LATE_NET_PAYMENT_AMT_T
, LATE_NET_PAYMENT_COUNT
, LATE_NET_PAYMENT_DAYS
, ORG_FK
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_COUNT
, PAYMENT_CURRENCY_CODE
, PAYMENT_CURRENCY_FK
, PAYMENT_DATE_FK
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_FK
, PAYMENT_TERM_FK
, POSTED_FLAG
, 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
, CHECK_AMT_B
, CHECK_AMT_T
, CHECK_AMT_G
, CHECK_NUMBER
FROM ( SELECT SEQ_ID
, ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG
, BANK_ACCOUNT_ID
, BASE_CURRENCY_CODE
, CASH_JE_BATCH_ID
, CASH_POSTED_FLAG
, CCID
, CHECK_DATE
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, EARLY_DISC_PAYMENT_AMT_B
, EARLY_DISC_PAYMENT_AMT_G
, EARLY_DISC_PAYMENT_AMT_T
, EARLY_DISC_PAYMENT_DAYS
, EARLY_DISC_PAYMENT_COUNT
, EARLY_NET_PAYMENT_AMT_B
, EARLY_NET_PAYMENT_AMT_G
, EARLY_NET_PAYMENT_AMT_T
, EARLY_NET_PAYMENT_COUNT
, EARLY_NET_PAYMENT_DAYS
, EMPLOYEE_FK
, FUTURE_PAY_POSTED_FLAG
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INVOICE_DATE
, INV_CURRENCY_CODE
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, INV_FK
, INV_NUM
, INV_PAYMENT_PK
, INV_PAYMENT_STATUS_FLAG
, INV_PAYMENT_TYPE
, INV_SOURCE
, INV_SOURCE_FK
, INV_TYPE
, JE_BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LATE_DISC_DAYS
, LATE_DISC_PAYMENT_AMT_B
, LATE_DISC_PAYMENT_AMT_G
, LATE_DISC_PAYMENT_AMT_T
, LATE_DISC_PAYMENT_COUNT
, LATE_NET_PAYMENT_AMT_B
, LATE_NET_PAYMENT_AMT_G
, LATE_NET_PAYMENT_AMT_T
, LATE_NET_PAYMENT_COUNT
, LATE_NET_PAYMENT_DAYS
, ORG_FK
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_COUNT
, PAYMENT_CURRENCY_CODE
, PAYMENT_CURRENCY_FK
, PAYMENT_DATE_FK
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_FK
, PAYMENT_TERM_FK
, POSTED_FLAG
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID) GL_SEG
, CHECK_AMT_B
, CHECK_AMT_T
, CHECK_AMT_G
, CHECK_NUMBER
FROM FIIBV_AP_INV_PAYMTS_FCV)