View: JL_BR_AP_SICI_INVOICES_V

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

View Text

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'

Columns