JL_BR_AP_SICI_INVOICES_TN_V

Details

• Schema: FUSION

• Object owner: JL

• Object type: VIEW

Columns

Name
SICI INVOICE_ID VENDOR_ID INVOICE_NUM INVOICE_DATE INVOICE_CURRENCY_CODE INVOICE_AMOUNT VENDOR_SITE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN INVOICE_TYPE_LOOKUP_CODE ORG_ID

Query

SQL_Statement

SELECT 'CI' SICI , CONSOLIDATED_INVOICE_ID INVOICE_ID , VENDOR_ID , INVOICE_NUM , INVOICE_DATE , INVOICE_CURRENCY_CODE , INVOICE_AMOUNT , VENDOR_SITE_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , NULL INVOICE_TYPE_LOOKUP_CODE , ORG_ID FROM JL_BR_AP_CONSOLID_INVOICES WHERE INVOICE_CURRENCY_CODE = 'BRL' UNION SELECT 'SI' SICI , INVOICE_ID , VENDOR_ID , INVOICE_NUM , INVOICE_DATE , INVOICE_CURRENCY_CODE , INVOICE_AMOUNT , VENDOR_SITE_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , INVOICE_TYPE_LOOKUP_CODE , ORG_ID FROM AP_INVOICES WHERE GLOBAL_ATTRIBUTE10 IS NULL AND INVOICE_TYPE_LOOKUP_CODE = 'STANDARD' AND INVOICE_CURRENCY_CODE = 'BRL'