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