FND Design Data [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: ViewAPPS.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