VIEW: APPS.JL_BR_AP_CONSOLID_INVOICES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'