[Home] [Help]
View: IGI_MPP_SELECTED_INVOICES_V
Product: | IGI - Public Sector Financials International |
Description: | Contains Non Multi Period Posting invoices which have been selected for Multi Period Posting |
Implementation/DBA Data: |
APPS.IGI_MPP_SELECTED_INVOICES_V
|
View Text
SELECT IMT.ROWID ROW_ID
, IMT.TRANSFER_ID
, IMT.INVOICE_ID
, IMT.ACCOUNTING_RULE_ID
, IMT.TRANSFER_FLAG
, IMT.LAST_UPDATED_BY
, IMT.LAST_UPDATE_DATE
, IMT.LAST_UPDATE_LOGIN
, IMT.CREATION_DATE
, IMT.CREATED_BY
, AIV.INVOICE_NUM
, AIV.VENDOR_NAME
FROM IGI_MPP_INVOICE_TRANSFER IMT
, AP_INVOICES_V AIV
WHERE IMT.INVOICE_ID = AIV.INVOICE_ID
Columns
Name |
ROW_ID |
TRANSFER_ID |
INVOICE_ID |
ACCOUNTING_RULE_ID |
TRANSFER_FLAG |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |
INVOICE_NUM |
VENDOR_NAME |