[Home] [Help]
View: IGI_MPP_AP_INVOICES_MERGE_V
Product: | IGI - Public Sector Financials International |
Description: | Contains invoice information for both Core and OPSFI forms |
Implementation/DBA Data: |
APPS.IGI_MPP_AP_INVOICES_MERGE_V
|
View Text
SELECT AIV.INVOICE_TYPE
, AIV.VENDOR_NAME
, AIV.VENDOR_NUMBER
, AIV.VENDOR_SITE_CODE
, AIV.INVOICE_DATE
, AIV.INVOICE_NUM
, AIV.INVOICE_CURRENCY_CODE
, AIV.INVOICE_AMOUNT
, AIV.GL_DATE
, IMI.INVOICE_ID
, IMI.IGNORE_MPP_FLAG
, IMI.ACCOUNTING_RULE_ID
, IMI.CREATED_BY
, IMI.CREATION_DATE
, IMI.LAST_UPDATED_BY
, IMI.LAST_UPDATE_DATE
, IMI.LAST_UPDATE_LOGIN
FROM AP_INVOICES_V AIV
, IGI_MPP_AP_INVOICES IMI
WHERE AIV.INVOICE_ID = IMI.INVOICE_ID
Columns
Name |
INVOICE_TYPE |
VENDOR_NAME |
VENDOR_NUMBER |
VENDOR_SITE_CODE |
INVOICE_DATE |
INVOICE_NUM |
INVOICE_CURRENCY_CODE |
INVOICE_AMOUNT |
GL_DATE |
INVOICE_ID |
IGNORE_MPP_FLAG |
ACCOUNTING_RULE_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |