VIEW: APPS.ICX_AP_INVOICES_V

Source

View Text - Preformatted

SELECT DISTINCT(PH.SEGMENT1) PO_NUMBER , AI.DESCRIPTION DESCRIPTION , to_char(AI.INVOICE_AMOUNT, fnd_currency.get_format_mask(ai.invoice_currency_code,30)) invoice_amount, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE , TO_CHAR( ICX_AP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID)) || ' ' || AI.INVOICE_CURRENCY_CODE WITHHELD_AMOUNT_CURRENCY_CODE , AI.INVOICE_DATE INVOICE_DATE , AI.INVOICE_ID INVOICE_ID , AI.INVOICE_NUM INVOICE_NUM , APS.DUE_DATE DUE_DATE , to_char(APS.GROSS_AMOUNT , fnd_currency.get_format_mask(ai.invoice_currency_code,30)) GROSS_AMOUNT, to_char(APS.AMOUNT_REMAINING , fnd_currency.get_format_mask(ai.invoice_currency_code,30)) AMOUNT_REMAINING, APS.DISCOUNT_DATE DISCOUNT_DATE , to_char(APS.DISCOUNT_AMOUNT_AVAILABLE , fnd_currency.get_format_mask(ai.invoice_currency_code,30)) DISCOUNT_AMOUNT_AVAILABLE, ALC1.DISPLAYED_FIELD INVOICE_TYPE , ALC2.DISPLAYED_FIELD PAYMENT_STATUS , ICX_AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY_LIST( AI.INVOICE_ID, APS.PAYMENT_NUM) PAYMENT_NUMBER , PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE , AI.VENDOR_SITE_ID VENDOR_SITE_ID , AI.VENDOR_ID VENDOR_ID , PV.EMPLOYEE_ID FROM AP_INVOICES AI, AP_PAYMENT_SCHEDULES APS, AP_LOOKUP_CODES ALC1, AP_LOOKUP_CODES ALC2, PO_VENDORS PV, PO_VENDOR_SITES PVS, PO_HEADERS PH, AP_INVOICE_DISTRIBUTIONS AID, PO_DISTRIBUTIONS_AP_V PD WHERE AI.INVOICE_ID = APS.INVOICE_ID AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID AND AI.VENDOR_ID = PV.VENDOR_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 AID.INVOICE_ID = AI.INVOICE_ID AND AID.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID (+) AND PD.PO_HEADER_ID = PH.PO_HEADER_ID (+)

View Text - HTML Formatted

SELECT DISTINCT(PH.SEGMENT1) PO_NUMBER
, AI.DESCRIPTION DESCRIPTION
, TO_CHAR(AI.INVOICE_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK(AI.INVOICE_CURRENCY_CODE
, 30)) INVOICE_AMOUNT
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TO_CHAR( ICX_AP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID)) || ' ' || AI.INVOICE_CURRENCY_CODE WITHHELD_AMOUNT_CURRENCY_CODE
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_NUM INVOICE_NUM
, APS.DUE_DATE DUE_DATE
, TO_CHAR(APS.GROSS_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK(AI.INVOICE_CURRENCY_CODE
, 30)) GROSS_AMOUNT
, TO_CHAR(APS.AMOUNT_REMAINING
, FND_CURRENCY.GET_FORMAT_MASK(AI.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, TO_CHAR(APS.DISCOUNT_AMOUNT_AVAILABLE
, FND_CURRENCY.GET_FORMAT_MASK(AI.INVOICE_CURRENCY_CODE
, 30)) DISCOUNT_AMOUNT_AVAILABLE
, ALC1.DISPLAYED_FIELD INVOICE_TYPE
, ALC2.DISPLAYED_FIELD PAYMENT_STATUS
, ICX_AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY_LIST( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAYMENT_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, AI.VENDOR_ID VENDOR_ID
, PV.EMPLOYEE_ID
FROM AP_INVOICES AI
, AP_PAYMENT_SCHEDULES APS
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, PO_HEADERS PH
, AP_INVOICE_DISTRIBUTIONS AID
, PO_DISTRIBUTIONS_AP_V PD
WHERE AI.INVOICE_ID = APS.INVOICE_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AI.VENDOR_ID = PV.VENDOR_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 AID.INVOICE_ID = AI.INVOICE_ID
AND AID.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID (+)
AND PD.PO_HEADER_ID = PH.PO_HEADER_ID (+)