VIEW: AP.AP_PREPAY_APP_DISTS#

Source

View Text - Preformatted

select PREPAY_APP_DIST_ID PREPAY_APP_DIST_ID, PREPAY_DIST_LOOKUP_CODE PREPAY_DIST_LOOKUP_CODE, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, PREPAY_APP_DISTRIBUTION_ID PREPAY_APP_DISTRIBUTION_ID, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, PREPAY_HISTORY_ID PREPAY_HISTORY_ID, PREPAY_EXCHANGE_DATE PREPAY_EXCHANGE_DATE, PREPAY_PAY_EXCHANGE_DATE PREPAY_PAY_EXCHANGE_DATE, PREPAY_CLR_EXCHANGE_DATE PREPAY_CLR_EXCHANGE_DATE, PREPAY_EXCHANGE_RATE PREPAY_EXCHANGE_RATE, PREPAY_PAY_EXCHANGE_RATE PREPAY_PAY_EXCHANGE_RATE, PREPAY_CLR_EXCHANGE_RATE PREPAY_CLR_EXCHANGE_RATE, PREPAY_EXCHANGE_RATE_TYPE PREPAY_EXCHANGE_RATE_TYPE, PREPAY_PAY_EXCHANGE_RATE_TYPE PREPAY_PAY_EXCHANGE_RATE_TYPE, PREPAY_CLR_EXCHANGE_RATE_TYPE PREPAY_CLR_EXCHANGE_RATE_TYPE, REVERSED_PREPAY_APP_DIST_ID REVERSED_PREPAY_APP_DIST_ID, AMOUNT AMOUNT, BASE_AMT_AT_PREPAY_XRATE BASE_AMT_AT_PREPAY_XRATE, BASE_AMT_AT_PREPAY_PAY_XRATE BASE_AMT_AT_PREPAY_PAY_XRATE, BASE_AMOUNT BASE_AMOUNT, BASE_AMT_AT_PREPAY_CLR_XRATE BASE_AMT_AT_PREPAY_CLR_XRATE, ROUNDING_AMT ROUNDING_AMT, ROUND_AMT_AT_PREPAY_XRATE ROUND_AMT_AT_PREPAY_XRATE, ROUND_AMT_AT_PREPAY_PAY_XRATE ROUND_AMT_AT_PREPAY_PAY_XRATE, ROUND_AMT_AT_PREPAY_CLR_XRATE ROUND_AMT_AT_PREPAY_CLR_XRATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, AWT_RELATED_ID AWT_RELATED_ID, RELEASE_INV_DIST_DERIVED_FROM RELEASE_INV_DIST_DERIVED_FROM, PA_ADDITION_FLAG PA_ADDITION_FLAG, BC_EVENT_ID BC_EVENT_ID, AMOUNT_VARIANCE AMOUNT_VARIANCE, INVOICE_BASE_AMT_VARIANCE INVOICE_BASE_AMT_VARIANCE, QUANTITY_VARIANCE QUANTITY_VARIANCE, INVOICE_BASE_QTY_VARIANCE INVOICE_BASE_QTY_VARIANCE from "AP"."AP_PREPAY_APP_DISTS"

View Text - HTML Formatted

SELECT PREPAY_APP_DIST_ID PREPAY_APP_DIST_ID
, PREPAY_DIST_LOOKUP_CODE PREPAY_DIST_LOOKUP_CODE
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, PREPAY_APP_DISTRIBUTION_ID PREPAY_APP_DISTRIBUTION_ID
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, PREPAY_HISTORY_ID PREPAY_HISTORY_ID
, PREPAY_EXCHANGE_DATE PREPAY_EXCHANGE_DATE
, PREPAY_PAY_EXCHANGE_DATE PREPAY_PAY_EXCHANGE_DATE
, PREPAY_CLR_EXCHANGE_DATE PREPAY_CLR_EXCHANGE_DATE
, PREPAY_EXCHANGE_RATE PREPAY_EXCHANGE_RATE
, PREPAY_PAY_EXCHANGE_RATE PREPAY_PAY_EXCHANGE_RATE
, PREPAY_CLR_EXCHANGE_RATE PREPAY_CLR_EXCHANGE_RATE
, PREPAY_EXCHANGE_RATE_TYPE PREPAY_EXCHANGE_RATE_TYPE
, PREPAY_PAY_EXCHANGE_RATE_TYPE PREPAY_PAY_EXCHANGE_RATE_TYPE
, PREPAY_CLR_EXCHANGE_RATE_TYPE PREPAY_CLR_EXCHANGE_RATE_TYPE
, REVERSED_PREPAY_APP_DIST_ID REVERSED_PREPAY_APP_DIST_ID
, AMOUNT AMOUNT
, BASE_AMT_AT_PREPAY_XRATE BASE_AMT_AT_PREPAY_XRATE
, BASE_AMT_AT_PREPAY_PAY_XRATE BASE_AMT_AT_PREPAY_PAY_XRATE
, BASE_AMOUNT BASE_AMOUNT
, BASE_AMT_AT_PREPAY_CLR_XRATE BASE_AMT_AT_PREPAY_CLR_XRATE
, ROUNDING_AMT ROUNDING_AMT
, ROUND_AMT_AT_PREPAY_XRATE ROUND_AMT_AT_PREPAY_XRATE
, ROUND_AMT_AT_PREPAY_PAY_XRATE ROUND_AMT_AT_PREPAY_PAY_XRATE
, ROUND_AMT_AT_PREPAY_CLR_XRATE ROUND_AMT_AT_PREPAY_CLR_XRATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, AWT_RELATED_ID AWT_RELATED_ID
, RELEASE_INV_DIST_DERIVED_FROM RELEASE_INV_DIST_DERIVED_FROM
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, BC_EVENT_ID BC_EVENT_ID
, AMOUNT_VARIANCE AMOUNT_VARIANCE
, INVOICE_BASE_AMT_VARIANCE INVOICE_BASE_AMT_VARIANCE
, QUANTITY_VARIANCE QUANTITY_VARIANCE
, INVOICE_BASE_QTY_VARIANCE INVOICE_BASE_QTY_VARIANCE
FROM "AP"."AP_PREPAY_APP_DISTS"