JL_BR_AP_SICI_INVOICES

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

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 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'

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 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'