DBA Data[Home] [Help]

VIEW: APPS.IGI_MPP_SELECTED_INVOICES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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