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: AMS_AP_PAYMENTS_V

Product:	AMS - Marketing
Description:	Invoice payments
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AIP.INVOICE_PAYMENT_ID
, AIP.INVOICE_ID
, AIP.CHECK_ID
, AIP.AMOUNT
, AIP.INVOICE_BASE_AMOUNT
, AIP.PAYMENT_BASE_AMOUNT
, AI.VOUCHER_NUM
, AI.INVOICE_NUM
, AI.TERMS_ID
, AT.NAME
, AI.TERMS_DATE
, AI.INVOICE_DATE
, AI.INVOICE_RECEIVED_DATE
, AI.INVOICE_TYPE_LOOKUP_CODE
, ALC1.DISPLAYED_FIELD
, AI.INVOICE_CURRENCY_CODE
, AI.INVOICE_AMOUNT
, AI.AMOUNT_PAID
, AI.PAYMENT_CURRENCY_CODE
, AI.PAYMENT_CROSS_RATE
, AI.PAY_CURR_INVOICE_AMOUNT
, AI.PAYMENT_AMOUNT_TOTAL
, AI.PAYMENT_METHOD_LOOKUP_CODE
, ALC2.DISPLAYED_FIELD
, AI.PAYMENT_STATUS_FLAG
, ALC3.DISPLAYED_FIELD
, AI.BASE_AMOUNT
, AI.TAX_AMOUNT
, AI.VAT_CODE
, AI.SOURCE
, ALC4.DISPLAYED_FIELD
, AI.APPROVED_AMOUNT
, AI.APPROVAL_STATUS
, AI.APPROVAL_DESCRIPTION
, AI.CANCELLED_AMOUNT
, AI.CANCELLED_DATE
, AI.CANCELLED_BY
, FND_USER_AP_PKG.GET_USER_NAME(AI.CANCELLED_BY)
, AI.FREIGHT_AMOUNT
, AI.PAY_GROUP_LOOKUP_CODE
, ALC5.DISPLAYED_FIELD
, AI.POSTING_STATUS
, AI.DESCRIPTION
, AC.CHECK_NUMBER
, AC.CHECK_DATE
, AC.CURRENCY_CODE
, AC.AMOUNT CHECK_AMOUNT
, AC.PAYMENT_METHOD_LOOKUP_CODE
, ALC6.DISPLAYED_FIELD
, AC.PAYMENT_TYPE_FLAG
, AC.STATUS_LOOKUP_CODE
, ALC7.DISPLAYED_FIELD
, AC.VENDOR_ID
, AC.VENDOR_NAME
, AC.VENDOR_SITE_ID
, AC.VENDOR_SITE_CODE
, AC.CHECK_VOUCHER_NUM
, AC.CLEARED_AMOUNT
, AC.CLEARED_DATE
, AC.STATE
, AC.STOPPED_AT
, AC.STOPPED_BY
, FND_USER_AP_PKG.GET_USER_NAME( AC.STOPPED_BY)
, AC.STOPPED_DATE
, AC.RELEASED_AT
, AC.RELEASED_BY
, FND_USER_AP_PKG.GET_USER_NAME( AC.RELEASED_BY)
, AC.RELEASED_DATE
FROM AP_INVOICES AI
, AP_CHECKS AC
, AP_INVOICE_PAYMENTS AIP
, AP_TERMS AT
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
, AP_LOOKUP_CODES ALC4
, AP_LOOKUP_CODES ALC5
, AP_LOOKUP_CODES ALC6
, AP_LOOKUP_CODES ALC7
WHERE AI.INVOICE_ID = AIP.INVOICE_ID
AND AC.CHECK_ID = AIP.CHECK_ID
AND AI.TERMS_ID = AT.TERM_ID
AND ALC1.LOOKUP_TYPE (+) = 'INVOICE_TYPE'
AND ALC1.LOOKUP_CODE (+) = AI.INVOICE_TYPE_LOOKUP_CODE
AND ALC2.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND ALC2.LOOKUP_CODE (+) = AI.PAYMENT_METHOD_LOOKUP_CODE
AND ALC3.LOOKUP_TYPE (+) = 'INVOICE_PAYMENT_STATUS'
AND ALC3.LOOKUP_CODE (+) = AI.PAYMENT_STATUS_FLAG
AND ALC4.LOOKUP_TYPE (+) = 'SOURCE'
AND ALC4.LOOKUP_CODE (+) = AI.SOURCE
AND ALC5.LOOKUP_TYPE (+) = 'PAY GROUP'
AND ALC5.LOOKUP_CODE (+) = AI.PAY_GROUP_LOOKUP_CODE
AND ALC6.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND ALC6.LOOKUP_CODE (+) = AC.PAYMENT_METHOD_LOOKUP_CODE
AND ALC7.LOOKUP_TYPE (+) = 'CHECK STATE'
AND ALC7.LOOKUP_CODE (+) = AC.STATUS_LOOKUP_CODE

Columns

Name
INVOICE_PAYMENT_ID
INVOICE_ID
CHECK_ID
AMOUNT
INVOICE_BASE_AMOUNT
PAYMENT_BASE_AMOUNT
VOUCHER_NUM
INVOICE_NUM
TERMS_ID
TERMS_NAME
TERMS_DATE
INVOICE_DATE
INVOICE_RECEIVED_DATE
INVOICE_TYPE_LOOKUP_CODE
INVOICE_TYPE
INVOICE_CURRENCY_CODE
INVOICE_AMOUNT
AMOUNT_PAID
PAYMENT_CURRENCY_CODE
PAYMENT_CROSS_RATE
PAY_CURR_INVOICE_AMOUNT
PAYMENT_AMOUNT_TOTAL
INV_PAYMENT_METHOD_CODE
INVOICE_PAYMENT_METHOD
PAYMENT_STATUS_FLAG
INVOICE_PAYMENT_STATUS
BASE_AMOUNT
TAX_AMOUNT
VAT_CODE
INVOICE_SOURCE
INVOICE_SOURCE_MEAN
APPROVED_AMOUNT
APPROVAL_STATUS
APPROVAL_DESCRIPTION
CANCELLED_AMOUNT
CANCELLED_DATE
CANCELLED_BY
CANCELLED_BY_DISPLAY
FREIGHT_AMOUNT
PAY_GROUP_LOOKUP_CODE
PAY_GROUP
POSTING_STATUS
DESCRIPTION
CHECK_NUMBER
CHECK_DATE
CURRENCY_CODE
CHECK_AMOUNT
CHK_PAYMENT_METHOD_CODE
CHECK_PAYMENT_METHOD
PAYMENT_TYPE_FLAG
STATUS_LOOKUP_CODE
CHECK_STATUS
VENDOR_ID
VENDOR_NAME
VENDOR_SITE_ID
VENDOR_SITE_CODE
CHECK_VOUCHER_NUM
CLEARED_AMOUNT
CLEARED_DATE
STATE
STOPPED_AT
STOPPED_BY
STOPPED_BY_DISPLAY
STOPPED_DATE
RELEASED_AT
RELEASED_BY
RELEASED_BY_DISPLAY
RELEASED_DATE