JL_BR_AP_CONSOLID_INVOICES_V

Details

• Schema: FUSION

• Object owner: JL

• Object type: VIEW

Columns

Name

ROW_ID CONSOLIDATED_INVOICE_ID VENDOR_ID INVOICE_NUM SET_OF_BOOKS_ID INVOICE_CURRENCY_CODE INVOICE_AMOUNT VENDOR_SITE_ID INVOICE_DATE DESCRIPTION TERMS_ID TERMS_DATE CANCELLED_DATE CANCELLED_BY CANCELLED_AMOUNT AMOUNT_APPLICABLE_TO_DISCOUNT PAY_GROUP_LOOKUP_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ORG_ID PAY_GROUP_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN VENDOR_NAME SEGMENT1 VENDOR_SITE_CODE NAME PAY_GROUP_LOOKUP_CODE_DESC OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT JLCON.ROWID ROW_ID , 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 PAY_GROUP_LOOKUP_CODE_DESC ,JLCON.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AP_CONSOLID_INVOICES JLCON , POZ_SUPPLIERS_V POV, POZ_SUPPLIER_SITES_ALL_X 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'