View: JL_BR_AP_CONSOLID_INVOICES_V

Product:	JL - Latin America Localizations
Description:	- Retrofitted
Implementation/DBA Data:	APPS.JL_BR_AP_CONSOLID_INVOICES_V

View Text

SELECT JLCON.ROWID
, JLCON.CONSOLIDATED_INVOICE_ID
, JLCON.VENDOR_ID
, JLCON.INVOICE_NUM
, JLCON.SET_OF_BOOKS_ID
, JLCON.INVOICE_CURRENCY_CODE
, JLCON.INVOICE_AMOUNT
, JLCON.VENDOR_SITE_ID
, JLCON.INVOICE_DATE
, JLCON.DESCRIPTION
, JLCON.TERMS_ID
, JLCON.TERMS_DATE
, JLCON.CANCELLED_DATE
, JLCON.CANCELLED_BY
, JLCON.CANCELLED_AMOUNT
, JLCON.AMOUNT_APPLICABLE_TO_DISCOUNT
, JLCON.PAY_GROUP_LOOKUP_CODE
, JLCON.ATTRIBUTE_CATEGORY
, JLCON.ATTRIBUTE1
, JLCON.ATTRIBUTE2
, JLCON.ATTRIBUTE3
, JLCON.ATTRIBUTE4
, JLCON.ATTRIBUTE5
, JLCON.ATTRIBUTE6
, JLCON.ATTRIBUTE7
, JLCON.ATTRIBUTE8
, JLCON.ATTRIBUTE9
, JLCON.ATTRIBUTE10
, JLCON.ATTRIBUTE11
, JLCON.ATTRIBUTE12
, JLCON.ATTRIBUTE13
, JLCON.ATTRIBUTE14
, JLCON.ATTRIBUTE15
, JLCON.ORG_ID
, JLCON.PAY_GROUP_FLAG
, JLCON.LAST_UPDATE_DATE
, JLCON.LAST_UPDATED_BY
, JLCON.CREATION_DATE
, JLCON.CREATED_BY
, JLCON.LAST_UPDATE_LOGIN
, POV.VENDOR_NAME
, POV.SEGMENT1
, POVS.VENDOR_SITE_CODE
, AT.NAME
, POLC.DESCRIPTION
FROM JL_BR_AP_CONSOLID_INVOICES JLCON
, PO_VENDORS POV
, PO_VENDOR_SITES POVS
, AP_TERMS AT
, PO_LOOKUP_CODES POLC
WHERE POV.VENDOR_ID (+) = JLCON.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = JLCON.VENDOR_SITE_ID
AND AT.TERM_ID (+) = JLCON.TERMS_ID
AND POLC.LOOKUP_CODE (+) = JLCON.PAY_GROUP_LOOKUP_CODE
AND POLC.LOOKUP_TYPE (+) = 'PAY GROUP'

Columns