Procure-to-Pay Insight
The following table lists objects (tables) of the Procure- to-Pay Insight for Oracle.
| Table/view name in IRC | Friendly name |
|---|---|
| AP_AGING_PERIOD_LINES | Aging Period Details |
| AP_AGING_PERIODS | Aging Periods |
| AP_AWT_GROUP_TAXES_ALL | Withholding Tax Codes |
| AP_AWT_GROUPS | Withholding Tax Group |
| AP_AWT_TAX_RATES_ALL | Withholding Tax Rates |
|
AP_BANK_ACCOUNTS_ALL Extracted table name for Oracle 12 version = IBY_EXT_BANK_ACCOUNTS |
Bank Accounts |
|
AP_BANK_BRANCHES Extracted table name for Oracle 12 version = CE_BANK_BRANCHES_V |
Bank Branches |
| AP_BANK_CHARGES | Bank Charges |
| AP_CHECKS_ALL | Payment Data |
| AP_DISTRIBUTION_SET_LINES_ALL | Individual Distribution Set Details |
| MTL_LE_ECONOMIC_ZONES | Individual Distribution Set Details |
| AP_DISTRIBUTION_SETS_ALL | Individual Distribution Sets |
| AP_HOLD_CODES | Invoice Hold and Release |
| AP_HOLDS_ALL | Invoice Hold Information |
| AP_INCOME_TAX_REGIONS | Income Tax Regions |
| AP_INTEREST_PERIODS | Interest Rates and Periods |
| AP_OTHER_PERIODS | AP Other Periods |
| AP_PAYMENT_PROGRAMS | Automatic Payment Programs |
| AP_REPORTING_ENTITIES_ALL | Tax Reporting Entities |
| AP_REPORTING_ENTITY_LINES_ALL | Tax Reporting Entity Details |
| AP_SYSTEM_PARAMETERS_ALL | AP System Parameters |
| AP_TAX_CODES_ALL | Tax Codes |
|
AP_TAX_RECVRY_RATES_ALL Extracted table name for Oracle 12 version =ZX_REC_NREC_DIST |
Tax Recovery Rates |
| AP_TAX_RECVRY_RULES_ALL | Tax Recovery Rules |
| AP_TERMS_LINES | Payment Term Details |
| AP_TERMS_TL | Payment Terms |
| AP_TOLERANCES_ALL | Invoice Tolerances |
| AR_TAX_GROUP_CODES_ALL | Tax Codes Within Tax Group |
| FINANCIALS_SYSTEM_PARAMS_ALL | Financials System Parameters |
| FND_APPLICATION | Applications registered with Oracle Application Object Library |
| FND_CURRENCIES | Currencies |
| FND_DESCR_FLEX_COLUMN_USAGES | Descriptive FlexField Segment Summary |
| FND_DESCR_FLEX_CONTEXTS | Descriptive FlexField Context Field Values |
| FND_DOCUMENT_CATEGORIES | Document Categories |
| FND_DOCUMENT_DATATYPES | Document Data Types |
| FND_DOCUMENTS | Documents |
| FND_FLEX_HIERARCHIES | Key FlexField Rollup Groups |
| FND_FLEX_VALIDATION_EVENTS | Special Validation Routines |
| FND_FLEX_VALIDATION_RULE_LINES | Key Flexfield Cross |
| FND_FLEX_VALIDATION_RULES | Key Flexfield Cross |
| FND_FLEX_VALIDATION_TABLES | Validation Table Information |
| FND_FLEX_VALUE_RULE_LINES | Flexfield Security Rule Details |
| FND_FLEX_VALUE_RULE_USAGES | Flexfield Security Rules Assigned To Responsibilities |
| FND_FLEX_VALUE_RULES | Flexfield Security Rules |
| FND_FLEX_VALUE_SETS | Value Sets |
| FND_FLEX_VALUES | Value Set Values |
| FND_FLEX_WORKFLOW_PROCESSES | Flexfields Workflow Processes |
| FND_ID_FLEX_SEGMENTS | Key Flexfield Segments |
| FND_ID_FLEX_STRUCTURES | Key Flexfield Structures |
| FND_ID_FLEXS | Key Flexfield Details |
| FND_LOOKUP_TYPES | Oracle Application Object Library QuickCode Types |
| FND_LOOKUP_VALUES | QuickCode Values |
| FND_PROFILE_OPTION_VALUES | Profile Option Values |
| FND_PROFILE_OPTIONS | Profile Options |
| FND_RESPONSIBILITY | Responsibilities |
| FND_SHORTHAND_FLEX_ALIASES | Key Flexfield Shorthand Aliases |
| FND_USER | User |
| GL_CODE_COMBINATIONS | GL Code Combinations |
| GL_DAILY_CONVERSION_TYPES | Conversion Rate Types |
| GL_DAILY_RATES | Daily Conversion Rates |
| GL_ENCUMBRANCE_TYPES | GL Encumbrance Types |
| GL_NET_INCOME_ACCOUNTS | Net Income Accounts |
| GL_PERIOD_SETS | Calendar Definitions |
| GL_PERIOD_STATUSES | Calendar Period Statuses |
| GL_PERIOD_TYPES | Calendar Period Types |
| GL_PERIODS | Calendar Period Definitions |
|
GL_SETS_OF_BOOKS Extracted table name for Oracle 12 version = GL_LEDGERS |
Set Of Books Definitions |
| GL_SUSPENSE_ACCOUNTS | Additional Suspense Accounts |
|
GL_TAX_OPTION_ACCOUNTS Extracted table name for Oracle 12 version = ZX_ACCT_TX_CLS_DEFS_ALL |
Tax Option Details |
| GL_TAX_OPTIONS | Tax Options |
| GL_TRANSACTION_CALENDAR | Transaction Calendar Definitions |
|
GL_TRANSLATION_RATES Extracted table name for Oracle 12 version = GL_DAILY_RATES |
Foreign Currency Translation Rates |
| HR_ALL_ORGANIZATION_UNITS | Organization Units |
| MTL_CATEGORIES_B | Item Category Code Combination |
| MTL_CATEGORY_ACCOUNTS | Accounts Categorization |
| MTL_CATEGORY_SET_VALID_CATS | Category Sets Types |
| MTL_CATEGORY_SETS_B | Category Sets |
| MTL_COMMODITY_CODES | Commodity Codes |
| MTL_COUNTRY_ASSIGNMENTS | Country Assignment |
| MTL_DEFAULT_CATEGORY_SETS | Functional Area Default Category Sets |
| MTL_DESCRIPTIVE_ELEMENTS | Descriptive Elements |
| MTL_ECONOMIC_ZONES_B | Economic Zones |
| MTL_ITEM_ATTRIBUTES | Item Attributes |
| MTL_ITEM_CATALOG_GROUPS_B | Item Catalog Groups |
| MTL_ITEM_CATEGORIES | Item Categories |
| MTL_ITEM_TEMPL_ATTRIBUTES | Attributes and Attribute Values for Item Templates |
| MTL_ITEM_TEMPLATES | Item Templates |
| MTL_LE_ECONOMIC_ZONES | Assignment of Legal Entity to EZ |
| MTL_MVT_STATS_RULE_SETS_B | Movement Statistics for Rule Sets |
| MTL_MVT_STATS_RULES | Validation Rule For Movement Statistics Fields |
| MTL_PARAMETERS | Inventory Control Parameters |
| MTL_SECONDARY_INVENTORIES | Subinventory |
| MTL_STATUS_ATTRIBUTE_VALUES | Item Status Code Attribute Values |
| MTL_SYSTEM_ITEMS_B | Inventory Items |
| MTL_TRANSACTION_REASONS | Inventory Transaction Reasons |
| MTL_UNITS_OF_MEASURE_TL | Units of Measure |
| MTL_UOM_CLASS_CONVERSIONS | Conversion Rates Between Two UOM |
| MTL_UOM_CLASSES_TL | Unit of Measure Classes |
| PO_CONTROL_GROUPS_ALL | Purchasing Document Control Groups |
| PO_CONTROL_RULES | Document Authorization Rules |
| PO_DOCUMENT_TYPES_ALL_B | Purchasing Document Types |
| PO_HAZARD_CLASSES_B | Hazardous Classes |
| PO_LINE_TYPES_B | PO Line Types |
| PO_POSITION_CONTROLS_ALL | Purchasing Position Control |
| PO_QUALITY_CODES | Quality Inspection Codes |
| PO_SYSTEM_PARAMETERS_ALL | Purchasing Options Parameters |
| PO_VENDORS | Suppliers |
| RCV_PARAMETERS | Organization |
| RCV_ROUTING_HEADERS | Receiving Routing Headers |