IGI Views (155)

IGI - Public Sector Financials International — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`IGI_AP_INVOICE_PAY_V`	Provides invoices which are awaiting payment approval.
`IGI_AP_INVOICE_V`	Provides invoices which fall within approvers flexfield range and are awaiting secondary approval.
`IGI_AP_INV_DISTRIBUTIONS_V`	Provides invoice distribution lines which fall within flexfield ranges assigned to department approvers.
`IGI_AP_PO_LOOKUP_CODES_V`	This view displays lookup codes shared by Purchasing and Payables.
`IGI_AR_ADDRESSES_V`	This view displays single third party customer site information
`IGI_AR_ADJUSTMENTS`	Retrieves adjustments transferred to Combined Basis Accounting
`IGI_AR_CASH_BASIS_DISTS`	Stores Combined Basis Accounting Cash Basis distributions
`IGI_AR_CASH_RECEIPT_HIST`	Holds cash receipt history information
`IGI_AR_CORR_PAY_SCHED`	Holds pay schedules information which are related to correspondences
`IGI_AR_CUSTOMERS_V`	This view displays single third party customers information
`IGI_AR_MISC_CASH_DISTS`	Holds information for miscellaneous cash distributions
`IGI_AR_PAYMENT_SCHEDULES_V`	Holds payment term schedules for the selected invoice
`IGI_AR_REC_APPLICATIONS`	Holds information about receipt applications
`IGI_AR_SYSTEM_OPTIONS_V`	View for the system options form based on IGI_AR_SYSTEM_OPTIONS view
`IGI_BUD_CODE_COMBINATIONS_V`	Based on GL_CODE_COMBINATIONS
`IGI_BUD_GL_INTERFACE_V`	Based on GL_INTERFACE and GL_PERIOD_STATUSES
`IGI_BUD_HISTORY_ENTRIES_V`	Based on GL_JE_HEADERS, GL_JE_LINES, GL_PERIODS and GL_SETS_OF_BOOKS
`IGI_BUD_JOURNAL_BATCHES_V`	Based on IGI_BUD_JOURNAL_BATCHES
`IGI_BUD_JOURNAL_HEADERS_V`	Based on GL_BUDGET_ENTITIES, GL_BUDGET_VERSIONS, GL_JE_CATEGORIES and IGI_BUD_JOURNAL_HEADERS
`IGI_BUD_JOURNAL_LINES_V`	Based on IGI_BUD_JOURNAL_LINES
`IGI_BUD_JOURNAL_PERIODS_V`	Based on IGI_BUD_JOURNAL_PERIODS
`IGI_BUD_PROFILE_PERIODS_V`	Based on GL_PERIODS, GL_SETS_OF_BOOKS and IGI_BUD_PROFILE_PERIODS
`IGI_BUD_SUMMARY_COMBS_V`	Based on GL_CODE_COMBINATIONS and GL_SUMMARY_TEMPLATES
`IGI_BUD_VARIANCE_BAL_V`	Based on GL_BALANCES
`IGI_BUD_VARIANCE_SEC_BAL_V`	Based on GL_BALANCES
`IGI_CBR_AP_INV_DIST_V`	This view returns all the invoice distributions that have been posted
`IGI_CBR_ARC_RECONCILE_V`	This is an intermediate view for the AR reconciliation process. Used by IGI_CBR_ARC_V.
`IGI_CBR_ARC_V`	This view queries up all the reconciled transaction records.
`IGI_CBR_GL_JOURNAL_SOURCES_V`	Retrieves the journal source name from GL_JE_SOURCES_TL and links it with the ALL option from IGI_LOOKUPS for lookup_type IGI_CBR_JOURNAL_SO
`IGI_CEC_DIST_SUMMARY`	Based on IGI_CEC_DIST_SUMMARY
`IGI_CEC_ENCUMBRANCE_TYPES`	Based on IGI_CEC_ENCUMBRANCE_TYPES_ALL
`IGI_CEC_ENCUMBRANCE_TYPES_V`	Based on IGI_CEC_ENCUMBRANCE_TYPES_ALL
`IGI_CIS_AWT_TAX_RATES`	Displays CIS WIthholding Certificate records coupled with NI Number details.
`IGI_CIS_CERT_INV_PMT_VCH_V`	Displays Invoice and Invoice Payment details along with associated CIS Withholding Tax Certificate details and CIS Payment Voucher details.
`IGI_CIS_INVOICE_PAYMENTS`	Displays records of invoice payments coupled with CIS Payment Voucher details.
`IGI_CIS_PMT_VCH_V`	Displays CIS Payment Voucher details by vendor site.
`IGI_COM_GL_BATCHES_COPY_V`	Based on GL_JE_BATCHES and GL_LOOKUPS
`IGI_COM_GL_JE_LINES_V`	Based on GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES and GL_JE_SOURCES_TL
`IGI_COM_SOB_LINK_V`	Based on IGI_COM_SOB_LINK and GL_SETS_OF_BOOKS
`IGI_DOS_BUD_ASS_CAND_V`	Based on GL_BUDGET_ASSIGNMENT_RANGES_V, GL_BUDGET_ENTITIES, GL_BUDGETS, BUDGET_VERSIONS, GL_ENTITY_BUDGETS, and GL_CODE_COMBINATIONS_KFV.
`IGI_DOS_DEFAULT_VALUES`	Based on FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, IGI_DOSSIER_NUMBERING, IGI_DOS_SOURCE_USAGES_V
`IGI_DOS_DESTINATION_USAGES_V`	Based on IGI_DOS_DESTINATION_USAGES
`IGI_DOS_DEST_ACCOUNTS`	Based on IGI_DOS_DOC_TYPES, GL_CODE_COMBINATIONS_KFV, IGI_DOS_DESTINATIONS and IGI_DOS_DESTINATION_USAGES
`IGI_DOS_SOURCE_ACCOUNTS`	Based on IGI_DOS_DOC_TYPES, GL_CODE_COMBINATIONS_KFV, IGI_DOS_SOURCES and IGI_DOS_SOURCE_USAGES
`IGI_DOS_SOURCE_USAGES_V`	Based on IGI_DOS_SOURCE_USAGES
`IGI_DUN_CHARGE`	Multi-org view which temporarily holds the calculated charges for a dunning charge run
`IGI_DUN_CUSTOMER_PROFILE_V`	Holds information about Dunning customer profiles
`IGI_DUN_CUST_LETTER_SET_CUR_V`	Allows the entry of letter set currenicies
`IGI_DUN_CUST_LETTER_SET_LINE_V`	Holds letter set information for the customer profile form
`IGI_DUN_CUST_PROFILE_CLASS_V`	Holds information for Dunning customer profile classes
`IGI_DUN_LETTER_SETS_V`	Holds information for dunning letter sets
`IGI_DUN_LETTER_SET_CUR_V`	Holds information about dunning letter sets currencies
`IGI_DUN_LETTER_SET_LINES_V`	Holds letter set information for the letter sets form
`IGI_EER_JE_LINES_V`	Based on GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES
`IGI_EER_SETUP_V`	Based on IGI_EER_SETUP, FND_ID_FLEX_SEGMENTS and GL_SETS_OF_BOOKS
`IGI_EXP_AP_INV_V`	Displays all unposted invoices awaiting release of exchange protocol hold.
`IGI_EXP_AR_INV_V`	Displays all unposted receivable transactions awaiting exchange protocol approval.
`IGI_EXP_AR_TRX_AMOUNTS_V`	Returns the total transaction amount for Receivables transactions. Used by views IGI_EXP_AVAILABLE_TRANSACTIONS_V and IGI_EXP_DU_LINES_V.
`IGI_EXP_AVAILABLE_TRX_V`	Returns details of all transactions in Payables and Receivables that are available for inclusion into a Dialog Unit.
`IGI_EXP_DIAL_UNIT_DEF`	Multi org view which displays all information pertaining to dialog unit setup.
`IGI_EXP_DIAL_UNIT_DEF_V`	Displays all information pertaining to dialog unit setup.
`IGI_EXP_DIAL_UNIT_V`	Displays all information pertaining to dialog unit setup
`IGI_EXP_DUS_IN_TUS_V`	Displays details of Dialog Units which are inside Transmission Units. Primarily used by 'Define Transmission Units' screen.
`IGI_EXP_DUS_NOT_IN_TUS_V`	Displays Dialog Units which are not included in Transmission Units. primarily used by form 'Define Transmission Units'
`IGI_EXP_DUS_V`	Returns details of all dialog units. Primarily used in 'define Dialog Units' form.
`IGI_EXP_DU_LINES_V`	Returns details of all Payables and Receivables transactions that are included in Dialog Units.
`IGI_EXP_EPTU_DIAL_V`	Displays all information pertaining to exchange protocol dialog units contained in transmission units
`IGI_EXP_EPTU_TRANS_V`	Displays all information about Exchange Protocol transmission units
`IGI_EXP_NUMBERING`	Multi org view which displays all the code combinations and numbering information for Exchange Protocol numbering.
`IGI_EXP_NUM_SCHEMES_V`	Displays the single Organization view of Numering Schemes for Dialog Units and Transmission Units along with the Dialog Unit Type and Transm
`IGI_EXP_POSITION_ACTION_V`	Displays details of approval privileges for individual position identifiers.
`IGI_EXP_TRAN_UNIT_DEF`	Displays information about Echange Protocol transmission units.
`IGI_EXP_TRAN_UNIT_V`	Displays information about Echange Protocol transmission units.
`IGI_EXP_TUS_V`	Displays details of Transmission Units and is primarily used by the 'Define Transmission Units' screen
`IGI_EXP_WKF_ASSIGN_V`	Displays document types assigned to a workflow.
`IGI_EXP_WKF_FLOWS`	Multiorg view
`IGI_EXP_WKF_PROFILE`	Multiorg view
`IGI_EXP_WKF_STEP`	Multiorg view
`IGI_EXP_WKF_STEP_V`	Displays individual workflow step setup information.
`IGI_GCC_GL_FA_INST_OPS`	Displays status details of non Multi Org OPSFI requirements.
`IGI_GCC_INSTALLED_OPTIONS`	Displays single Organization status details of Multi Org OPSFI requirements.
`IGI_GL_BALANCES_V`	Based on GL_BALANCES, GL_PERIOD_STATUSES and GL_SETS_OF_BOOKS
`IGI_GL_DETAIL_BALANCES_V`	Based on GL_BALANCES, GL_ACCOUNT_HIERARCHIES and GL_SETS_OF_BOOKS
`IGI_GL_FUNCTIONAL_BALANCES_V`	Based on GL_BALANCES and GL_SETS_OF_BOOKS
`IGI_GL_JE_HEADERS_V`
`IGI_GL_JE_JOURNAL_LINES_V`	Based on GL_JE_SOURCES_TL, GL_JE_CATEGORIES_TL, GL_ENCUMBRANCE_TYPES, GL_BUDGET_VERSIONS, GL_LOOKUPS, GL_DAILY_CONVERSION_TYPES, GL_JE_BATCH
`IGI_GL_JE_LINES_V`	Based on IGI_GL_JE_LINES
`IGI_GL_JE_SOURCE_NAMES_V`
`IGI_GL_PERIOD_STATUSES_V`	Based on GL_LOOKUP_PERIOD_STATUSES_V and GL_PERIOD_STATUSES
`IGI_GL_SUMMARY_BALANCES_V`	Based on GL_BALANCES, GL_ACCOUNT_HIERARCHIES and GL_SETS_OF_BOOKS
`IGI_GL_SUMMARY_COMBINATIONS_V`	Based on GL_CODE_COMBINATIONS and GL_SUMMARY_TEMPLATES
`IGI_IAC_BOOK_CONTROLS_V`
`IGI_IMP_IAC_INTERFACE_DTL_V`
`IGI_INSTALMENT_AUDIT_V`	Stores information required for Instalment Terms requirement
`IGI_INT_BK_ID_MAP_SOB_V`	Based on GL_SETS_OF_BOOKS and IGI_INT_BK_ID_MAP
`IGI_INT_DETAILS_V`	Based on GL_JE_BATCHES, IGI_INT_DESCRIPTRS, GL_JE_HEADERS, GL_JE_LINES and GL_IMPORT_REFERENCES
`IGI_INT_FILE_V`
`IGI_INVOICE_DISTRIBUTIONS_V`	Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.
`IGI_ITR_CHARGE_AUTH_V`	Based on IGI_ITR_CHARGE_AUTH and FND_USER
`IGI_ITR_CHARGE_CENTER_SS_V`
`IGI_ITR_CHARGE_CENTER_V`	Based on IGI_ITR_CHARGE_CENTER
`IGI_ITR_CHARGE_HEADERS_SS_V`
`IGI_ITR_CHARGE_HEADERS_V`	Based on FND_USER, GL_JE_CATEGORIES_TL, IGI_ITR_CHARGE_HEADERS and IGI_LOOKUPS
`IGI_ITR_CHARGE_LINES_ENTRY_V`	Based on IGI_ITR_CHARGE_CENTER and IGI_ITR_CHARGE_LINES
`IGI_ITR_CHARGE_LINES_SS_V`
`IGI_ITR_CHARGE_ORIG_SS_V`
`IGI_ITR_CHARGE_RANGES_V`	Based on IGI_ITR_CHARGE_RANGES
`IGI_ITR_CHARGE_RANGE_AUTH_SS_V`
`IGI_ITR_CHARGE_SERVICE_SS_V`
`IGI_ITR_CHARGE_SETUP_SS_V`
`IGI_ITR_CH_LINES_APP_SS_V`
`IGI_ITR_CH_LINES_APP_V`	Based on IGI_ITR_CHARGE_CENTER, FND_USER, IGI_ITR_CHARGE_HEADERS and IGI_ITR_CHARGE_LINES
`IGI_ITR_SERVICE_SS_V`
`IGI_LOOKUPS`	Oracle Application Object Library QuickCodes
`IGI_MHC_CAL_PRICE_INDEXES_V`	IGI_MHC_CAL_PRICE_INDEXES_V contains the names of the calendars and the price indexes attached to them.
`IGI_MHC_CURR_REVAL_DTL_V`	IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview mod
`IGI_MHC_REVAL_DETAILS_LL_V`	IGI_MHC_REVAL_DETAILS_LL_V holds the revaluation details at the distribution level for each asset level for the Live Revaluation run that w
`IGI_MHC_REVAL_DETAILS_PL_V`	IGI_MHC_REVAL_SUMMARY_PL_V holds data for each distribution of an asset for all the Live runs of Revaluation done for the Previous periods
`IGI_MHC_REVAL_SUMMARY_LL_V`	IGI_MHC_REVAL_SUMMARY_LL_V holds the revaluation details at each asset level for the Live Revaluation run that was done for thecurrent peri
`IGI_MHC_REVAL_SUMMARY_PL_V`	IGI_MHC_REVAL_SUMMARY_PL_V holds data for all the Live runs of Revaluation done for the Previous periods
`IGI_MPP_AP_DIST_MERGE_V`	Contains information for both Core and OPSFI Invoice Distributions forms
`IGI_MPP_AP_INVOICES_MERGE_V`	Contains invoice information for both Core and OPSFI forms
`IGI_MPP_EXPENSE_RULES`	Contains expense accounts and associated accounting rules
`IGI_MPP_EXPENSE_RULES_V`	Contains expense rules information required by expense rules form based on IGI_MPP_EXPENSE_RULES view
`IGI_MPP_EXP_RECOGNITION`	Used for Multi Period Posting expense recognition
`IGI_MPP_NON_MPP_INVOICES_V`	Contains invoices that are not used by Multi Period Posting
`IGI_MPP_SELECTED_INVOICES_V`	Contains Non Multi Period Posting invoices which have been selected for Multi Period Posting
`IGI_MPP_SETUP`	Contains setup information for Multi Period Posting
`IGI_MPP_SETUP_V`	View for the Multi Period Posting form based on IGI_MPP_SETUP view
`IGI_RA_CUSTOMER_TRX_PARTIAL_V`
`IGI_RECOVERABLE_LINES`	MultiOrg View
`IGI_RPI_INVOICE_HISTORY_V`	Contains invoice history informaion for a single standing charge
`IGI_RPI_ITEMS_V`	View for the standing charges item form based on IGI_RPI_ITEMS view
`IGI_RPI_LINE_AUDIT_DETAILS_V`	View for the standing charges audit form based on IGI_RPI_LINE_AUDIT_DET view
`IGI_RPI_LINE_DETAILS_V`	View for the standing charges line details form based on IGI_RPI_LINE_DETAILS view
`IGI_RPI_STANDING_CHARGES_V`	View for the standing charges forms based on IGI_RPI_STANDING_CHARGES view
`IGI_RPI_UPDATE_HDR_V`	View for the global price update form based on IGI_RPI_UPDATE_HDR view
`IGI_RPI_UPDATE_LINES_C_V`	View used for line updates at standing charge level
`IGI_RPI_UPDATE_LINES_D_V`	View used for line updates at detailed level
`IGI_SAP_DEPT_APPROVERS_V`	Provides information about department approvers responsible for Secondary Invoice Approvals.
`IGI_SAP_EXCEPTIONS_V`	Provides exceptions raised for invoices that require secondary approval.
`IGI_SAP_GROUP_V`	Provides information from Secondary Invoice Approval groups.
`IGI_SAP_INVOICE_CLERK_V`	Provides information about Secondary Invoice Approval clerks.
`IGI_SIA_DEPT_APPROVER_RG`	Allows selection of users as Department Approvers.
`IGI_SIA_INVOICE_CLERK_RG`	Allows the selection of users as Invoice Clerks.
`IGI_SLS_DELETED_ALLOC_V`	This view provides information on deleted allocations
`IGI_SLS_DELETED_GROUPS_V`	This view provides information on deleted groups
`IGI_SLS_DELETED_TABLES_V`	This view provides information on deleted secure tables
`IGI_SLS_ENABLED_ALLOC_V`	This view provides information on enabled groups and secure tables
`IGI_STP_AP_BAL`	Displays all Payables invoices available for Single Third Party netting.
`IGI_STP_AR_BAL`	Displays all Receivables transactions available for Single Third Party netting.
`IGI_STP_BATCHES_V`	Displays netting batch information.
`IGI_STP_CONTROL_V`	Displays the Netting Transaction Batch information submitted.
`IGI_STP_PACKAGES_V`	View which displays information on Single Third Party netting transactions batch.
`IGI_STP_SITE_BAL`	View which displays the active Sites for a Single Third Party.