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.

[Home] [Help]

VIEW: APPS.FII_AP_SCH_PAYMTS_FCV

Source

View Text - Preformatted


SELECT SEQ_ID, PINVOICE_ID, INV_TYPE, PAY_NUM, CCID, COMPLETELY_PAID_PAYMENT_COUNT, CREATION_DATE, DISC_AMT_LOST_B, DISC_AMT_LOST_G, DISC_AMT_LOST_T, DISC_AMT_TAKEN_B, DISC_AMT_TAKEN_G, DISC_AMT_TAKEN_T, DISC_DATE_FK, DUE_DATE, DUE_DATE_FK, EMPLOYEE_FK, INV_EXCHANGE_DATE, INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_DATE, PAYMENT_EXCHANGE_RATE_TYPE, FIRST_DISC_AVAILABLE_B, FIRST_DISC_AVAILABLE_G, FIRST_DISC_AVAILABLE_T, FIRST_DISC_DATE, GEOGRAPHY_FK, HOLD_FLAG, INSTANCE, INSTANCE_FK, INV_AMT_HAVING_DISC_B, INV_AMT_HAVING_DISC_G, INV_AMT_HAVING_DISC_T, INV_AMT_NOT_HAVING_DISC_B, INV_AMT_NOT_HAVING_DISC_G, INV_AMT_NOT_HAVING_DISC_T, INV_CURRENCY_FK, PAYMENT_CURRENCY_FK, INV_DATE_FK, INV_FK, INV_SOURCE_FK, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, ORG_FK, PARTIALLY_PAID_PAYMENT_COUNT, PAYMENT_AMT_B, PAYMENT_AMT_G, PAYMENT_AMT_T, PAYMENT_METHOD, PAYMENT_PRIORITY, PAYMENT_STATUS_FLAG, PAYMENT_TERM_FK, POTENTIAL_DISC_AMT_B, POTENTIAL_DISC_AMT_G, POTENTIAL_DISC_AMT_T, REMAINING_DISC_AMT_AT_RISK_B, REMAINING_DISC_AMT_AT_RISK_G, REMAINING_DISC_AMT_AT_RISK_T, REMAINING_INV_AMT_B, REMAINING_INV_AMT_G, REMAINING_INV_AMT_T, REMAINING_INV_AMT_AT_RISK_B, REMAINING_INV_AMT_AT_RISK_G, REMAINING_INV_AMT_AT_RISK_T, SCH_PAYMENT_PK, SECOND_DISC_AVAILABLE_B, SECOND_DISC_AVAILABLE_G, SECOND_DISC_AVAILABLE_T, SECOND_DISC_DATE, SIC_CODE_FK, DUNS_FK, SOB_FK, SUPPLIER_FK, THIRD_DISC_AVAILABLE_B, THIRD_DISC_AVAILABLE_G, THIRD_DISC_AVAILABLE_T, THIRD_DISC_DATE, UNPAID_PAYMENT_COUNT, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, INVOICE_NUM, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,1,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,1,25))||substr(GL_SEG,251))) GL_ACCT1_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,26,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,26,25))||substr(GL_SEG,251))) GL_ACCT2_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,51,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,51,25))||substr(GL_SEG,251))) GL_ACCT3_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,76,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,76,25))||substr(GL_SEG,251))) GL_ACCT4_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,101,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,101,25))||substr(GL_SEG,251))) GL_ACCT5_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,126,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,126,25))||substr(GL_SEG,251))) GL_ACCT6_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,151,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,151,25))||substr(GL_SEG,251))) GL_ACCT7_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,176,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,176,25))||substr(GL_SEG,251))) GL_ACCT8_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,201,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,201,25))||substr(GL_SEG,251))) GL_ACCT9_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substr(GL_SEG,226,25)), 'NA_EDW','NA_EDW', rtrim(substr(GL_SEG,226,25))||substr(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, PINVOICE_ID, INV_TYPE, PAY_NUM, CCID, COMPLETELY_PAID_PAYMENT_COUNT, CREATION_DATE, DISC_AMT_LOST_B, DISC_AMT_LOST_G, DISC_AMT_LOST_T, DISC_AMT_TAKEN_B, DISC_AMT_TAKEN_G, DISC_AMT_TAKEN_T, DISC_DATE_FK, DUE_DATE, DUE_DATE_FK, EMPLOYEE_FK, INV_EXCHANGE_DATE, INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_DATE, PAYMENT_EXCHANGE_RATE_TYPE, FIRST_DISC_AVAILABLE_B, FIRST_DISC_AVAILABLE_G, FIRST_DISC_AVAILABLE_T, FIRST_DISC_DATE, GEOGRAPHY_FK, HOLD_FLAG, INSTANCE, INSTANCE_FK, INV_AMT_HAVING_DISC_B, INV_AMT_HAVING_DISC_G, INV_AMT_HAVING_DISC_T, INV_AMT_NOT_HAVING_DISC_B, INV_AMT_NOT_HAVING_DISC_G, INV_AMT_NOT_HAVING_DISC_T, INV_CURRENCY_FK, PAYMENT_CURRENCY_FK, INV_DATE_FK, INV_FK, INV_SOURCE_FK, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, ORG_FK, PARTIALLY_PAID_PAYMENT_COUNT, PAYMENT_AMT_B, PAYMENT_AMT_G, PAYMENT_AMT_T, PAYMENT_METHOD, PAYMENT_PRIORITY, PAYMENT_STATUS_FLAG, PAYMENT_TERM_FK, POTENTIAL_DISC_AMT_B, POTENTIAL_DISC_AMT_G, POTENTIAL_DISC_AMT_T, REMAINING_DISC_AMT_AT_RISK_B, REMAINING_DISC_AMT_AT_RISK_G, REMAINING_DISC_AMT_AT_RISK_T, REMAINING_INV_AMT_B, REMAINING_INV_AMT_G, REMAINING_INV_AMT_T, REMAINING_INV_AMT_AT_RISK_B, REMAINING_INV_AMT_AT_RISK_G, REMAINING_INV_AMT_AT_RISK_T, SCH_PAYMENT_PK, SECOND_DISC_AVAILABLE_B, SECOND_DISC_AVAILABLE_G, SECOND_DISC_AVAILABLE_T, SECOND_DISC_DATE, SIC_CODE_FK, DUNS_FK, SOB_FK, SUPPLIER_FK, THIRD_DISC_AVAILABLE_B, THIRD_DISC_AVAILABLE_G, THIRD_DISC_AVAILABLE_T, THIRD_DISC_DATE, UNPAID_PAYMENT_COUNT, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, INVOICE_NUM, 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_SCH_PAYMTS_FCV)

View Text - HTML Formatted

SELECT SEQ_ID
, PINVOICE_ID
, INV_TYPE
, PAY_NUM
, CCID
, COMPLETELY_PAID_PAYMENT_COUNT
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, DISC_DATE_FK
, DUE_DATE
, DUE_DATE_FK
, EMPLOYEE_FK
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE_TYPE
, FIRST_DISC_AVAILABLE_B
, FIRST_DISC_AVAILABLE_G
, FIRST_DISC_AVAILABLE_T
, FIRST_DISC_DATE
, GEOGRAPHY_FK
, HOLD_FLAG
, INSTANCE
, INSTANCE_FK
, INV_AMT_HAVING_DISC_B
, INV_AMT_HAVING_DISC_G
, INV_AMT_HAVING_DISC_T
, INV_AMT_NOT_HAVING_DISC_B
, INV_AMT_NOT_HAVING_DISC_G
, INV_AMT_NOT_HAVING_DISC_T
, INV_CURRENCY_FK
, PAYMENT_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_SOURCE_FK
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, ORG_FK
, PARTIALLY_PAID_PAYMENT_COUNT
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_METHOD
, PAYMENT_PRIORITY
, PAYMENT_STATUS_FLAG
, PAYMENT_TERM_FK
, POTENTIAL_DISC_AMT_B
, POTENTIAL_DISC_AMT_G
, POTENTIAL_DISC_AMT_T
, REMAINING_DISC_AMT_AT_RISK_B
, REMAINING_DISC_AMT_AT_RISK_G
, REMAINING_DISC_AMT_AT_RISK_T
, REMAINING_INV_AMT_B
, REMAINING_INV_AMT_G
, REMAINING_INV_AMT_T
, REMAINING_INV_AMT_AT_RISK_B
, REMAINING_INV_AMT_AT_RISK_G
, REMAINING_INV_AMT_AT_RISK_T
, SCH_PAYMENT_PK
, SECOND_DISC_AVAILABLE_B
, SECOND_DISC_AVAILABLE_G
, SECOND_DISC_AVAILABLE_T
, SECOND_DISC_DATE
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, THIRD_DISC_AVAILABLE_B
, THIRD_DISC_AVAILABLE_G
, THIRD_DISC_AVAILABLE_T
, THIRD_DISC_DATE
, UNPAID_PAYMENT_COUNT
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, INVOICE_NUM
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 1
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT1_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 26
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT2_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 51
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT3_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 76
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT4_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 101
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT5_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 126
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT6_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 151
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT7_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 176
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT8_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 201
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT9_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 226
, 25))||SUBSTR(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
, PINVOICE_ID
, INV_TYPE
, PAY_NUM
, CCID
, COMPLETELY_PAID_PAYMENT_COUNT
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, DISC_DATE_FK
, DUE_DATE
, DUE_DATE_FK
, EMPLOYEE_FK
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE_TYPE
, FIRST_DISC_AVAILABLE_B
, FIRST_DISC_AVAILABLE_G
, FIRST_DISC_AVAILABLE_T
, FIRST_DISC_DATE
, GEOGRAPHY_FK
, HOLD_FLAG
, INSTANCE
, INSTANCE_FK
, INV_AMT_HAVING_DISC_B
, INV_AMT_HAVING_DISC_G
, INV_AMT_HAVING_DISC_T
, INV_AMT_NOT_HAVING_DISC_B
, INV_AMT_NOT_HAVING_DISC_G
, INV_AMT_NOT_HAVING_DISC_T
, INV_CURRENCY_FK
, PAYMENT_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_SOURCE_FK
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, ORG_FK
, PARTIALLY_PAID_PAYMENT_COUNT
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_METHOD
, PAYMENT_PRIORITY
, PAYMENT_STATUS_FLAG
, PAYMENT_TERM_FK
, POTENTIAL_DISC_AMT_B
, POTENTIAL_DISC_AMT_G
, POTENTIAL_DISC_AMT_T
, REMAINING_DISC_AMT_AT_RISK_B
, REMAINING_DISC_AMT_AT_RISK_G
, REMAINING_DISC_AMT_AT_RISK_T
, REMAINING_INV_AMT_B
, REMAINING_INV_AMT_G
, REMAINING_INV_AMT_T
, REMAINING_INV_AMT_AT_RISK_B
, REMAINING_INV_AMT_AT_RISK_G
, REMAINING_INV_AMT_AT_RISK_T
, SCH_PAYMENT_PK
, SECOND_DISC_AVAILABLE_B
, SECOND_DISC_AVAILABLE_G
, SECOND_DISC_AVAILABLE_T
, SECOND_DISC_DATE
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, THIRD_DISC_AVAILABLE_B
, THIRD_DISC_AVAILABLE_G
, THIRD_DISC_AVAILABLE_T
, THIRD_DISC_DATE
, UNPAID_PAYMENT_COUNT
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, INVOICE_NUM
, 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_SCH_PAYMTS_FCV)