Product: | AMS - Marketing |
---|---|
Description: | Payables Invoices |
Implementation/DBA Data: | Not implemented in this database |
SELECT AI.INVOICE_ID
, AI.INVOICE_NUM
, AI.INVOICE_DATE
, AI.INVOICE_RECEIVED_DATE
, AI.INVOICE_CURRENCY_CODE
, ALC1.DISPLAYED_FIELD
, AI.INVOICE_AMOUNT
, AI.BASE_AMOUNT
, AI.AMOUNT_PAID
, AI.EXCHANGE_DATE
, AI.EXCHANGE_RATE
, AI.EXCHANGE_RATE_TYPE
, AI.EARLIEST_SETTLEMENT_DATE
, AI.ORIGINAL_PREPAYMENT_AMOUNT
, AI.AMOUNT_APPLICABLE_TO_DISCOUNT
, AI.APPROVED_AMOUNT
, AI.INVOICE_TYPE_LOOKUP_CODE
, AI.PAYMENT_CURRENCY_CODE
, AI.PAYMENT_AMOUNT_TOTAL
, AI.PAYMENT_CROSS_RATE
, AI.PAYMENT_CROSS_RATE_TYPE
, AI.PAYMENT_CROSS_RATE_DATE
, GDCT.USER_CONVERSION_TYPE
, AI.PAYMENT_METHOD_LOOKUP_CODE
, ALC3.DISPLAYED_FIELD
, AI.PAYMENT_STATUS_FLAG
, ALC2.DISPLAYED_FIELD
, AI.PAY_GROUP_LOOKUP_CODE
, AI.PO_HEADER_ID
, AI.APPROVAL_STATUS
, AI.APPROVAL_DESCRIPTION
, AI.AUTHORIZED_BY
, AI.CANCELLED_BY
, AI.CANCELLED_DATE
, AI.CANCELLED_AMOUNT
, AI.DESCRIPTION
, AI.DISCOUNT_AMOUNT_TAKEN
, AI.EXCLUSIVE_PAYMENT_FLAG
, AI.FREIGHT_AMOUNT
, AI.GOODS_RECEIVED_DATE
, AI.PREPAY_FLAG
, AI.TERMS_ID
, AT.NAME
, AI.TERMS_DATE
, AI.VAT_CODE
, AI.SOURCE
, AI.TAX_AMOUNT
, AI.VENDOR_ID
, AI.VENDOR_PREPAY_AMOUNT
, AI.VENDOR_SITE_ID
, AI.VOUCHER_NUM
, PV.VENDOR_NAME
, PV.SEGMENT1
, PVS.VENDOR_SITE_CODE
, PVS.TERMS_DATE_BASIS
FROM AP_INVOICES AI
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
, AP_TERMS AT
, GL_DAILY_CONVERSION_TYPES GDCT
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE 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 (+) = 'INVOICE PAYMENT STATUS'
AND ALC2.LOOKUP_CODE (+) = AI.PAYMENT_STATUS_FLAG
AND ALC3.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND ALC3.LOOKUP_CODE (+) = AI.PAYMENT_METHOD_LOOKUP_CODE
AND AI.EXCHANGE_RATE_TYPE = GDCT.CONVERSION_TYPE (+)
AND AI.VENDOR_ID = PV.VENDOR_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID