Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ICX Tables and Views

TABLE - ICX.ICX_AUDIT

TABLE - ICX.ICX_CART_DISTRIBUTIONS

TABLE - ICX.ICX_CART_LINE_DISTRIBUTIONS

TABLE - ICX.ICX_CATG_DETLS_INFO

TABLE - ICX.ICX_CATG_DETLS_INFO_TL

TABLE - ICX.ICX_CAT_ADV_SRCH_SETUP

TABLE - ICX.ICX_CAT_BROWSE_TREES

TABLE - ICX.ICX_CAT_CATEGORIES_TL

TABLE - ICX.ICX_CAT_CATEGORY_ITEMS

TABLE - ICX.ICX_CAT_DELETED_ATTRIBUTES

TABLE - ICX.ICX_CAT_DESCRIPTORS_TL

TABLE - ICX.ICX_CAT_EXT_ITEMS_TLP

TABLE - ICX.ICX_CAT_ITEMS_B

TABLE - ICX.ICX_CAT_ITEMS_CTX_TLP

TABLE - ICX.ICX_CAT_ITEMS_TLP

TABLE - ICX.ICX_CAT_ITEM_PRICES

TABLE - ICX.ICX_CAT_ITEM_SRC_DETAILS

TABLE - ICX.ICX_CAT_POPULATE_CTX_GT

TABLE - ICX.ICX_CAT_PRICE_HISTORY

TABLE - ICX.ICX_CAT_PRICE_LISTS

TABLE - ICX.ICX_CAT_SCHEMA_VERSIONS

TABLE - ICX.ICX_CAT_STORES_B

TABLE - ICX.ICX_CAT_STORES_TL

TABLE - ICX.ICX_CAT_STORE_CATALOGS

TABLE - ICX.ICX_CAT_UPLOAD_IT_DUMP

TABLE - ICX.ICX_CAT_UPLOAD_PRICE_DUMP

TABLE - ICX.ICX_COLORS

TABLE - ICX.ICX_CONTEXT_RESULTS_TEMP

TABLE - ICX.ICX_CUSTOM_MENU_ENTRIES

TABLE - ICX.ICX_ENABLED_PLSQL

TABLE - ICX.ICX_FAILURES

TABLE - ICX.ICX_ITEM_DETLS_INFO

TABLE - ICX.ICX_ITEM_DETLS_INFO_TL

TABLE - ICX.ICX_MARGIN_ANALYSIS

TABLE - ICX.ICX_MARGIN_ANALYSIS_ERR

TABLE - ICX.ICX_OE_CARTS

TABLE - ICX.ICX_OE_CART_ERRORS

TABLE - ICX.ICX_OE_CART_LINES

TABLE - ICX.ICX_PAGES

TABLE - ICX.ICX_PAGES_TL

TABLE - ICX.ICX_PAGE_COLORS

TABLE - ICX.ICX_PAGE_COLORS_TL

TABLE - ICX.ICX_PAGE_COLOR_SCHEME

TABLE - ICX.ICX_PAGE_PLUGS

TABLE - ICX.ICX_PANEL_SUMMARY

TABLE - ICX.ICX_PARAMETERS

TABLE - ICX.ICX_PORTLET_CUSTOMIZATIONS

TABLE - ICX.ICX_POR_BATCH_JOBS

TABLE - ICX.ICX_POR_BUGSEYE_CONFIG

TABLE - ICX.ICX_POR_BUGSEYE_FLAGS

TABLE - ICX.ICX_POR_BUYER_APPROVAL_JOBS

TABLE - ICX.ICX_POR_CATALOG_ATTACHMENTS

TABLE - ICX.ICX_POR_CATEGORIES_TL

TABLE - ICX.ICX_POR_CATEGORY_DATA_SOURCES

TABLE - ICX.ICX_POR_CATEGORY_DEFAULTS

TABLE - ICX.ICX_POR_CATEGORY_ITEMS

TABLE - ICX.ICX_POR_CATEGORY_ORDER_MAP

TABLE - ICX.ICX_POR_CONFIG_PARAMETERS

TABLE - ICX.ICX_POR_CONTEXT_POLICY

TABLE - ICX.ICX_POR_CONTRACT_REFERENCES

TABLE - ICX.ICX_POR_CTX_TL

TABLE - ICX.ICX_POR_DAILY_NOTIFICATIONS

TABLE - ICX.ICX_POR_DESCRIPTORS_CACHE

TABLE - ICX.ICX_POR_DESCRIPTORS_TL

TABLE - ICX.ICX_POR_EXT_QUERY

TABLE - ICX.ICX_POR_EXT_QUERY_TL

TABLE - ICX.ICX_POR_FAILED_ATTACHMENTS

TABLE - ICX.ICX_POR_FAILED_LINES

TABLE - ICX.ICX_POR_FAILED_LINE_MESSAGES

TABLE - ICX.ICX_POR_ITEMS

TABLE - ICX.ICX_POR_ITEMS_TL

TABLE - ICX.ICX_POR_ITEM_CONSTRAINT

TABLE - ICX.ICX_POR_ITEM_CTX_INDEX

TABLE - ICX.ICX_POR_ITEM_SITE

TABLE - ICX.ICX_POR_ITEM_SOURCES

TABLE - ICX.ICX_POR_ITEM_SOURCES_TL

TABLE - ICX.ICX_POR_LOADER_VALUES

TABLE - ICX.ICX_POR_LOAD_ITEM_MATCH

TABLE - ICX.ICX_POR_LOG

TABLE - ICX.ICX_POR_ORACLE_ITEM_SUBTABLE

TABLE - ICX.ICX_POR_PRICE_LISTS

TABLE - ICX.ICX_POR_PRICE_LIST_LINES

TABLE - ICX.ICX_POR_PRICE_LIST_LINES_CACHE

TABLE - ICX.ICX_POR_REALMS

TABLE - ICX.ICX_POR_REALMS_TL

TABLE - ICX.ICX_POR_REALM_COMPONENTS

TABLE - ICX.ICX_POR_SEARCH_CONFIG

TABLE - ICX.ICX_POR_SEARCH_CONFIG_POLICY

TABLE - ICX.ICX_POR_SITE

TABLE - ICX.ICX_POR_TABLE_OF_CONTENTS_TL

TABLE - ICX.ICX_POR_TEMPLATE_FILES

TABLE - ICX.ICX_POR_THIRD_PARTY_LOGS

TABLE - ICX.ICX_POR_THIRD_PARTY_LOG_VALUES

TABLE - ICX.ICX_POR_TITLE_ADMIN

TABLE - ICX.ICX_POR_TITLE_ADMIN_TL

TABLE - ICX.ICX_POR_TITLE_REGISTRY

TABLE - ICX.ICX_POR_UNIT

TABLE - ICX.ICX_POR_UNSPSC_CODES

TABLE - ICX.ICX_POR_UPLOADER_SUBTABLE

TABLE - ICX.ICX_POR_UPLOAD_IT_DUMP

TABLE - ICX.ICX_POR_VERSION_INFO

TABLE - ICX.ICX_PO_REVISIONS_TEMP

TABLE - ICX.ICX_PROCUREMENT_SERVER_SETUP

TABLE - ICX.ICX_PROMPTS

TABLE - ICX.ICX_QUESTIONS

TABLE - ICX.ICX_QUESTIONS_TL

TABLE - ICX.ICX_QUESTION_FUNCTIONS

TABLE - ICX.ICX_REGIONS

TABLE - ICX.ICX_RELATED_CATEGORIES

TABLE - ICX.ICX_REQUISITIONER_INFO

TABLE - ICX.ICX_REQ_CART_ERRORS

TABLE - ICX.ICX_SESSIONS

TABLE - ICX.ICX_SESSION_ATTRIBUTES

TABLE - ICX.ICX_SHOPPING_CARTS

TABLE - ICX.ICX_SHOPPING_CART_LINES

TABLE - ICX.ICX_STORE_INDEX

TABLE - ICX.ICX_TEMPLATE_TAGS

TABLE - ICX.ICX_TEXT

TABLE - ICX.ICX_TRANSACTIONS

TABLE - ICX.ICX_UNSPSC_CODES

TABLE - ICX.ICX_USER_PROFILES

TABLE - ICX.ICX_VERSIONS

TABLE - ICX.ICX_WEB_STORE_OPTIONS

TABLE - ICX.POR_CONFIGURABLE_USER_DATA

TABLE - ICX.POR_CONTAINER_IMAGES

TABLE - ICX.POR_EMPLOYEE_LOADER_VALUES

TABLE - ICX.POR_FAVORITE_LIST_HEADERS

TABLE - ICX.POR_FAVORITE_LIST_LINES

TABLE - ICX.POR_FAV_CHARGE_ACCOUNTS

TABLE - ICX.POR_FEED_FIELD_FORMATS

TABLE - ICX.POR_FEED_HISTORY

TABLE - ICX.POR_FEED_RECORDS

TABLE - ICX.POR_IMAGES

TABLE - ICX.POR_IMAGE_LANG_SETTINGS

TABLE - ICX.POR_ITEM_ATTRIBUTE_VALUES

TABLE - ICX.POR_LOCATION_LOADER_VALUES

TABLE - ICX.POR_LOV_DISPLAY_RESULTS

TABLE - ICX.POR_LOV_RESULT_VALUES

TABLE - ICX.POR_TEMPLATE_ASSOC

TABLE - ICX.POR_TEMPLATE_INFO

TABLE - ICX.POR_USER_DATA_CONF_LIST

TABLE - ICX.POR_USER_DATA_CONF_LIST_ITEMS

TABLE - ICX.POS_ACK_SELECT

TABLE - ICX.POS_ASN_SEARCH_RESULT

TABLE - ICX.POS_ASN_SHOP_CART_DETAILS

TABLE - ICX.POS_ASN_SHOP_CART_HEADERS

VIEW - APPS.ICX_ADMIN_LOV_BASE

VIEW - APPS.ICX_ADMIN_RESP_FUNC_V

VIEW - APPS.ICX_ADMIN_RESP_SEC_ATTR_V

VIEW - APPS.ICX_ADMIN_USER_RESP_V

VIEW - APPS.ICX_AK_ATTRIBUTES_VL

VIEW - APPS.ICX_AP_CHECKS_V

VIEW - APPS.ICX_AP_EXPENSE_LINES_V

VIEW - APPS.ICX_AP_EXPENSE_REPORTS_V

VIEW - APPS.ICX_AP_INVOICES_V

VIEW - APPS.ICX_AP_INVOICE_PAYMENTS_V

VIEW - APPS.ICX_AS_EVENT_FACILITIES_V

VIEW - APPS.ICX_AS_EVENT_FACSTAFF_COUNT_V

VIEW - APPS.ICX_AS_EVENT_FAC_STAFF_V

VIEW - APPS.ICX_AS_EVENT_NAME_RQMNTS_V

VIEW - APPS.ICX_CART_LINE_ACCOUNT_HEADER_V

VIEW - APPS.ICX_CART_LINE_DISTRIBUTIONS_V

VIEW - APPS.ICX_CATALOG_AVAIL_ITEMS_V

VIEW - APPS.ICX_CATALOG_ORD_ITEMS_V

VIEW - APPS.ICX_CATALOG_SUMMARY_V

VIEW - APPS.ICX_CATEGORY_LOV

VIEW - APPS.ICX_CATEGORY_SET_LOV

VIEW - APPS.ICX_CATG_DETLS_INFO_V

VIEW - APPS.ICX_CATG_DETLS_INFO_VL

VIEW - APPS.ICX_CHV_ITEM_ORDERS_V

VIEW - APPS.ICX_CHV_SCHEDULE_ITEMS_V

VIEW - APPS.ICX_CHV_SCHEDULE_LINES_V

VIEW - APPS.ICX_CONFIG_COMPONENTS_WEB_V

VIEW - APPS.ICX_COST_GRP_INV_VALUE_V

VIEW - APPS.ICX_CST_CUSTOMER_30DAY_V

VIEW - APPS.ICX_CST_CUSTOMER_7DAY_V

VIEW - APPS.ICX_CST_CUSTOMER_90DAY_V

VIEW - APPS.ICX_CST_ITEM_30DAY_V

VIEW - APPS.ICX_CST_ITEM_7DAY_V

VIEW - APPS.ICX_CST_ITEM_90DAY_V

VIEW - APPS.ICX_CST_MARGIN_BUILD_V

VIEW - APPS.ICX_CST_MARGIN_DETAIL_V

VIEW - APPS.ICX_CST_MARGIN_TEMP_V

VIEW - APPS.ICX_CST_SALES_REP_30DAY_V

VIEW - APPS.ICX_CST_SALES_REP_7DAY_V

VIEW - APPS.ICX_CST_SALES_REP_90DAY_V

VIEW - APPS.ICX_CST_TERRITORY_30DAY_V

VIEW - APPS.ICX_CST_TERRITORY_7DAY_V

VIEW - APPS.ICX_CST_TERRITORY_90DAY_V

VIEW - APPS.ICX_EDM_BUYER_SUP_PROJ_V

VIEW - APPS.ICX_EDM_BUYER_SUP_TASK_V

VIEW - APPS.ICX_EDM_COST_GROUP_INV_V

VIEW - APPS.ICX_EDM_CUSTOMER_TASK_V

VIEW - APPS.ICX_EDM_INV_ONHAND_BAL_V

VIEW - APPS.ICX_EDM_KEY_MEMBER_PROJ_V

VIEW - APPS.ICX_EDM_KEY_MEMBER_TASK_V

VIEW - APPS.ICX_EDM_MFG_PLAN_V

VIEW - APPS.ICX_EDM_PLANNER_PROJ_V

VIEW - APPS.ICX_EDM_PLANNER_TASK_V

VIEW - APPS.ICX_EDM_PO_BLANKET_REL_V

VIEW - APPS.ICX_EDM_PROJECT_TASK_V

VIEW - APPS.ICX_EDM_PROJECT_V

VIEW - APPS.ICX_EDM_PURCHASE_ORDER_V

VIEW - APPS.ICX_EDM_PURCHASE_REQ_V

VIEW - APPS.ICX_EDM_WIP_JOB_V

VIEW - APPS.ICX_ENG_WEB_SCHEDULE_CS_V

VIEW - APPS.ICX_ENG_WEB_SCHEDULE_PO_V

VIEW - APPS.ICX_ENG_WEB_SCHEDULE_SO_V

VIEW - APPS.ICX_FORM_FUNCTIONS_VL

VIEW - APPS.ICX_HORIZONTAL_SCHEDULE_V

VIEW - APPS.ICX_HR_LOCATIONS_V

VIEW - APPS.ICX_HR_ORGS_LOV_V

VIEW - APPS.ICX_INTERNAL_CONTACT_LOV

VIEW - APPS.ICX_INTERNAL_SAV_DEFAULTS_V

VIEW - APPS.ICX_ITEM_DETLS_INFO_V

VIEW - APPS.ICX_ITEM_DETLS_INFO_VL

VIEW - APPS.ICX_LOV_DUMMY_V

VIEW - APPS.ICX_MRP_BUCKETED_FORECASTS_V

VIEW - APPS.ICX_MRP_DUMMY_BUCKETED_PROC_V

VIEW - APPS.ICX_MRP_FORECAST_DATES_V

VIEW - APPS.ICX_MRP_FORECAST_UPDATES_V

VIEW - APPS.ICX_MTL_DEMAND_ITEM_SUM_V

VIEW - APPS.ICX_MTL_DEMAND_SUMMARY_V

VIEW - APPS.ICX_MTL_ONHAND_ITEMS_DMMY_V

VIEW - APPS.ICX_MTL_ONHAND_ITEMS_KFV

VIEW - APPS.ICX_MTL_ONHAND_LOCATOR_KFV

VIEW - APPS.ICX_MTL_ONHAND_LOT_KFV

VIEW - APPS.ICX_MTL_ONHAND_REV_KFV

VIEW - APPS.ICX_MTL_ONHAND_SERIAL_KFV

VIEW - APPS.ICX_MTL_ONHAND_SUB_KFV

VIEW - APPS.ICX_MTL_ONHAND_SUB_V

VIEW - APPS.ICX_MTL_SALES_ORDERS_V

VIEW - APPS.ICX_MTL_SUPPLY_DEMAND_V

VIEW - APPS.ICX_MTL_SYSTEM_ITEMS_CONT_V

VIEW - APPS.ICX_NONSHIP_DUMMY_LOV_V

VIEW - APPS.ICX_NONSHIP_ITEMS_V

VIEW - APPS.ICX_OE_DIRECT_ITEMS_V

VIEW - APPS.ICX_ORG_ADDRESS_V

VIEW - APPS.ICX_PAGES_VL

VIEW - APPS.ICX_PANEL_SUMMARY_V

VIEW - APPS.ICX_PANEL_TOTALS_V

VIEW - APPS.ICX_PER_ORGANIZATION_UNITS_V

VIEW - APPS.ICX_PER_PEOPLE_X_V

VIEW - APPS.ICX_PLAN_SCHEDULE_HEADERS_V

VIEW - APPS.ICX_POR_CATEGORIES_VL

VIEW - APPS.ICX_POR_CTLG_DUMMY_V

VIEW - APPS.ICX_POR_DESCRIPTORS_VL

VIEW - APPS.ICX_POR_EXT_ACTIVE_CONTRACTS

VIEW - APPS.ICX_POR_EXT_CONTRACTS

VIEW - APPS.ICX_POR_EXT_INACTIVE_CONTRACTS

VIEW - APPS.ICX_POR_ITEM_SOURCES_FORM_V

VIEW - APPS.ICX_POR_ITEM_SOURCES_VL

VIEW - APPS.ICX_POR_REALMS_FORM_V

VIEW - APPS.ICX_POR_REALMS_VL

VIEW - APPS.ICX_POR_REALM_COMP_FORM_V

VIEW - APPS.ICX_POR_REQ_ACTIVE_CONTRACTS

VIEW - APPS.ICX_POR_REQ_ASLS

VIEW - APPS.ICX_POR_REQ_CONTRACTS

VIEW - APPS.ICX_POR_REQ_INACTIVE_CONTRACTS

VIEW - APPS.ICX_POR_REQ_TEMPLATES

VIEW - APPS.ICX_POR_SEARCH_ASLS_V

VIEW - APPS.ICX_POR_SEARCH_CONTRACTS_V

VIEW - APPS.ICX_POR_SEARCH_ITEM_MASTER_V

VIEW - APPS.ICX_POS_QA_SHIPMENTS_V

VIEW - APPS.ICX_PO_ACTION_HISTORY_PK_V

VIEW - APPS.ICX_PO_APPROVER_VAL_V

VIEW - APPS.ICX_PO_DISTRIBUTES_DIFF_V

VIEW - APPS.ICX_PO_EMPLOYEE_DETAILS_V

VIEW - APPS.ICX_PO_HDR_ARCHIVE_OPEN_V

VIEW - APPS.ICX_PO_HEADERS_ARCHIVE_V

VIEW - APPS.ICX_PO_HEADER_DIFF_V

VIEW - APPS.ICX_PO_LATE_RECEIPTS_V

VIEW - APPS.ICX_PO_LINES_ALL_CONTEXT_V

VIEW - APPS.ICX_PO_LINES_DIFF_V

VIEW - APPS.ICX_PO_LINE_DIST_DIFF_V

VIEW - APPS.ICX_PO_LINE_LOC_DIFF_V

VIEW - APPS.ICX_PO_LIST_USERS_V

VIEW - APPS.ICX_PO_LOCATIONS_DIFF_V

VIEW - APPS.ICX_PO_LOCATION_DETAIL_V

VIEW - APPS.ICX_PO_MATCHED_INVOICES_V

VIEW - APPS.ICX_PO_OPEN_REQS_BY_USERS_V

VIEW - APPS.ICX_PO_OSP_V

VIEW - APPS.ICX_PO_REQS_BY_USERS_V

VIEW - APPS.ICX_PO_REQUESTOR_VAL_V

VIEW - APPS.ICX_PO_REQUISITION_HEADERS_V

VIEW - APPS.ICX_PO_REQUISITION_LINES_INQ_V

VIEW - APPS.ICX_PO_REQUISITION_OPEN_V

VIEW - APPS.ICX_PO_REQUISITION_TEMPLATES_V

VIEW - APPS.ICX_PO_REQ_DIST_V

VIEW - APPS.ICX_PO_REQ_HEADERS_V

VIEW - APPS.ICX_PO_REQ_LINES_DIST_V

VIEW - APPS.ICX_PO_REQ_LINES_V

VIEW - APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V

VIEW - APPS.ICX_PO_REVISIONS_HEADER_V

VIEW - APPS.ICX_PO_REVISIONS_LINE_V

VIEW - APPS.ICX_PO_REVISIONS_TEMP_V

VIEW - APPS.ICX_PO_RFQ_HEADERS_V

VIEW - APPS.ICX_PO_RFQ_LINES_V

VIEW - APPS.ICX_PO_SUPPLIER_AGREEMENTS_V

VIEW - APPS.ICX_PO_SUPPLIER_CATALOGS_V

VIEW - APPS.ICX_PO_SUPPLIER_INFO_V

VIEW - APPS.ICX_PO_SUPPLIER_ITEMS_V

VIEW - APPS.ICX_PO_SUPPLIER_ORDERS_V

VIEW - APPS.ICX_PO_SUPPL_CATALOG_ITEMS_V

VIEW - APPS.ICX_PO_SUPPL_CAT_ITEMS_V

VIEW - APPS.ICX_PO_SUPPL_SEARCH_ITEMS_V

VIEW - APPS.ICX_PO_SUP_ORDER_INVOICES_V

VIEW - APPS.ICX_PO_USER_DETAILS_V

VIEW - APPS.ICX_PO_VENDOR_CONTACTS_V

VIEW - APPS.ICX_PO_VENDOR_SITES_V

VIEW - APPS.ICX_PRICE_LIST_UOMS_V

VIEW - APPS.ICX_PROCSERV_SETUP_FORM_V

VIEW - APPS.ICX_QUESTIONS_VL

VIEW - APPS.ICX_RA_CUSTOMER_TRX_LINES_V

VIEW - APPS.ICX_RCV_ACCEPTED_ITEMS_V

VIEW - APPS.ICX_RCV_EARLY_LATE_RECEIPTS_V

VIEW - APPS.ICX_RCV_REJECTED_ITEMS_V

VIEW - APPS.ICX_RCV_RETURNS_V

VIEW - APPS.ICX_RCV_TRANSACTIONS_V

VIEW - APPS.ICX_RECEIPT_HEADERS_V

VIEW - APPS.ICX_RELATED_CATEGORIES_V

VIEW - APPS.ICX_RELATED_CATEGORIES_VAL_V

VIEW - APPS.ICX_RELATED_TEMPLATES_V

VIEW - APPS.ICX_RELATED_TEMPLATES_VAL_V

VIEW - APPS.ICX_REQS_LOCATION_LOV

VIEW - APPS.ICX_REQS_LOCATION_V

VIEW - APPS.ICX_REQUESTER_LOV

VIEW - APPS.ICX_REQ_CATEGORIES_V

VIEW - APPS.ICX_REQ_DIST_HEADER_V

VIEW - APPS.ICX_REQ_DIST_UPDATE_V

VIEW - APPS.ICX_REQ_ONE_TIME_ITEM_V

VIEW - APPS.ICX_REQ_SUPPLIERS_V

VIEW - APPS.ICX_REQ_TEMPLATES_V

VIEW - APPS.ICX_SHIP_SCHEDULE_HEADERS_V

VIEW - APPS.ICX_SHOPPING_CARTS_V

VIEW - APPS.ICX_SHOPPING_CART_LINES_V

VIEW - APPS.ICX_SO_LINES_VIEW_LINES_V

VIEW - APPS.ICX_SO_LINES_VIEW_RETURNS_V

VIEW - APPS.ICX_SO_PICKING_HDRS_LINES_V

VIEW - APPS.ICX_SO_RMA_MTL_INT_DETAIL_V

VIEW - APPS.ICX_SO_RMA_MTL_INT_V

VIEW - APPS.ICX_START_V

VIEW - APPS.ICX_SUPPLIER_ACCOUNT_V

VIEW - APPS.ICX_SUPPLIER_CONTACT_LOV

VIEW - APPS.ICX_SUPPLIER_ORG_LOV_V

VIEW - APPS.ICX_SUPPLIER_SAV_DEFAULTS_V

VIEW - APPS.ICX_SUPPLIER_SITE_LOV_V

VIEW - APPS.ICX_TEMPLATE_LOV

VIEW - APPS.ICX_TEMPLATE_TAGS_V

VIEW - APPS.ICX_UNIT_OF_MEASUREMENT_V

VIEW - APPS.ICX_WEBSTORE_CATEGORIES_V

VIEW - APPS.ICX_WEBSTORE_ITEMS_V

VIEW - APPS.ICX_WEBSTORE_SEARCH_ITEMS_V

VIEW - APPS.POR_APPROVAL_STATUS_HEADER_V

VIEW - APPS.POR_APPROVAL_STATUS_LINES_V

VIEW - APPS.POR_APPROVER_LOV_V

VIEW - APPS.POR_ATTACHMENTS_SUMMARY_V

VIEW - APPS.POR_BUYER_LOV_V

VIEW - APPS.POR_CATEGORY_LOV_V

VIEW - APPS.POR_CAT_CATG_DOMAIN_LOV_V

VIEW - APPS.POR_CAT_SUPPLIER_LOV_V

VIEW - APPS.POR_CAT_SUPP_DOMAIN_LOV_V

VIEW - APPS.POR_CONFIRM_INTERNAL_RECEIPT_V

VIEW - APPS.POR_DISTRIBUTIONS_ALL_V

VIEW - APPS.POR_DISTRIBUTIONS_V

VIEW - APPS.POR_DUMMY_V

VIEW - APPS.POR_EXPENDITURE_LOV_V

VIEW - APPS.POR_EXP_ORG_LOV_V

VIEW - APPS.POR_HAZARD_CLASS_LOV_V

VIEW - APPS.POR_HEADER_V

VIEW - APPS.POR_INFO_TEMPLATE_V

VIEW - APPS.POR_INVOICES_SUMMARY_V

VIEW - APPS.POR_LINES_ALL_V

VIEW - APPS.POR_LINES_V

VIEW - APPS.POR_LOCATION_LOV_V

VIEW - APPS.POR_MANUFACTURER_LOV_V

VIEW - APPS.POR_MTL_REASONS_LOV_V

VIEW - APPS.POR_OPERATION_SEQ_NUM_LOV_V

VIEW - APPS.POR_PREPARER_LOV_V

VIEW - APPS.POR_PROJECT_LOV_V

VIEW - APPS.POR_PUBLIC_LISTS_V

VIEW - APPS.POR_RCV_ALL_ITEMS_V1

VIEW - APPS.POR_RCV_CONF_ITEMS_V

VIEW - APPS.POR_RCV_EXPRESS_ITEMS_V

VIEW - APPS.POR_RCV_HOME_RECEIPTS_V

VIEW - APPS.POR_RCV_HOME_REQS_V

VIEW - APPS.POR_RCV_INTERNAL_ITEMS_V

VIEW - APPS.POR_RCV_INTERNAL_RECEIPTS_V

VIEW - APPS.POR_RCV_ORD_REQUESTER_V

VIEW - APPS.POR_RCV_PURCHASE_ITEMS_V

VIEW - APPS.POR_RCV_PURCHASE_RECEIPTS_V

VIEW - APPS.POR_RCV_REQS_ALL_V

VIEW - APPS.POR_RCV_REQS_NAME_V

VIEW - APPS.POR_RCV_REQS_ORDER_V

VIEW - APPS.POR_RCV_REQS_VENDOR_V

VIEW - APPS.POR_RCV_REQ_ITEMS_V

VIEW - APPS.POR_RCV_REQ_LOV_V

VIEW - APPS.POR_RCV_REQ_PURCH_RECEIPTS_V

VIEW - APPS.POR_RCV_RETURN_TO_VENDOR_V

VIEW - APPS.POR_RCV_SHIPMENTS_V

VIEW - APPS.POR_RCV_SHIP_DISP_HEADERS_V

VIEW - APPS.POR_RCV_SHIP_DISP_LINES_V

VIEW - APPS.POR_RECEIPTS_SUMMARY_V

VIEW - APPS.POR_RECEIVE_ORDERS_V

VIEW - APPS.POR_REQUESTER_LOV_V

VIEW - APPS.POR_SRC_SUBINV_LOV_V

VIEW - APPS.POR_SUBINVENTORY_LOV_V

VIEW - APPS.POR_SUPPLIER_LOV_V

VIEW - APPS.POR_TASK_LOV_V

VIEW - APPS.POR_TEMPLATES_V

VIEW - APPS.POR_TEMPLATE_ASSOC_V

VIEW - APPS.POR_TEMPLATE_ATTRIBUTES_V

VIEW - APPS.POR_UNIT_OF_MEASURE_LOV_V

VIEW - APPS.POR_UN_NUMBER_LOV_V

VIEW - APPS.POR_USSGL_TC_LOV_V

VIEW - APPS.POR_VIEW_DIST_HEADER_V

VIEW - APPS.POR_VIEW_DIST_LINES_V

VIEW - APPS.POR_VIEW_HEADER_ALL_V

VIEW - APPS.POR_VIEW_HEADER_V

VIEW - APPS.POR_VIEW_LINES_ALL_V

VIEW - APPS.POR_VIEW_LINES_V

VIEW - APPS.POR_VIEW_LINE_DETAILS_V

VIEW - APPS.POR_VIEW_REQS_AUTOQUERY_V

VIEW - APPS.POR_VIEW_REQS_BY_APPROVER_V

VIEW - APPS.POR_VIEW_REQS_BY_APPR_V

VIEW - APPS.POR_VIEW_REQS_BY_GROUP_V

VIEW - APPS.POR_VIEW_REQS_BY_HIERARCHY_V

VIEW - APPS.POR_VIEW_REQS_BY_PRIVATE_V

VIEW - APPS.POR_VIEW_REQS_BY_PUBLIC_V

VIEW - APPS.POR_VIEW_REQS_BY_PURCHASING_V

VIEW - APPS.POR_VIEW_REQS_TO_APPR_V

VIEW - APPS.POR_VIEW_REQS_V

VIEW - APPS.POR_WIP_ENTITY_NAME_LOV_V

VIEW - APPS.POS_ACK_ACC_TYPE_LOV_V

VIEW - APPS.POS_ACK_EDIT_V

VIEW - APPS.POS_ACK_SEARCH_V

VIEW - APPS.POS_ACK_SELECT_V

VIEW - APPS.POS_ACK_SITE_LOV_V

VIEW - APPS.POS_ASL_ITEM_LOV_V

VIEW - APPS.POS_ASL_ORDER_MODIFIERS_V

VIEW - APPS.POS_ASL_SEARCH_V

VIEW - APPS.POS_ASL_TOLERANCE_V

VIEW - APPS.POS_ASN_HEADERS_V

VIEW - APPS.POS_ASN_LOCATION_LOV_V

VIEW - APPS.POS_ASN_PO_SHIPMENTS_V

VIEW - APPS.POS_ASN_RESULT_V

VIEW - APPS.POS_ASN_REVIEW_HEADERS_V

VIEW - APPS.POS_ASN_REVIEW_SHIPMENTS_V

VIEW - APPS.POS_ASN_SEARCH_V

VIEW - APPS.POS_ASN_SHIPMENTS_V

VIEW - APPS.POS_ASN_SHIPMENT_DETAILS_V

VIEW - APPS.POS_ASN_SITE_LOV_V

VIEW - APPS.POS_ASN_UOM_V

VIEW - APPS.POS_ASN_WIP_JOB_V

VIEW - APPS.POS_COO_LOV

VIEW - APPS.POS_FREIGHT_TERMS_LOV_V

VIEW - APPS.POS_ORG_FREIGHT_LOV_V

VIEW - APPS.POS_REASONS_LOV_V

VIEW - APPS.POS_SUPPLIER_ITEM_CAPACITY_V

VIEW - APPS.POS_UPD_DATE_PO_SHIP_V

VIEW - APPS.POS_UPD_DATE_SEARCH_V

Table: ICX_AUDIT

Primary Key: ICX_AUDIT_PK

1. AUDIT_ID

Foreign Keys from this table:

Comments

ICX_AUDIT is available to developers to store audit information about
any web transaction.
.

Indexes

Columns

[top of page]

ICX.ICX_AUDIT does not reference any database object

ICX.ICX_AUDIT is referenced by following:

APPS

SYNONYM - ICX_AUDIT

[top of page]

Table: ICX_CART_DISTRIBUTIONS

Primary Key: ICX_CART_DISTRIBUTIONS_PK

1. CART_ID
2. DISTRIBUTION_ID

Foreign Keys from this table:

Comments

ICX_CART_DISTRIBUTIONS can store information about the accounting
distributions associated with the requisition. This information can
then be applied as a default to all requisition lines. In order to
use this table, custom code must be written.
.
One record is automatically added to this table each time a new
requisition is created.
.

Indexes

Columns

[top of page]

ICX.ICX_CART_DISTRIBUTIONS does not reference any database object

ICX.ICX_CART_DISTRIBUTIONS is referenced by following:

APPS

SYNONYM - ICX_CART_DISTRIBUTIONS

[top of page]

Table: ICX_CART_LINE_DISTRIBUTIONS

Primary Key: ICX_CART_LINE_DISTRIBUTION_PK1

1. DISTRIBUTION_ID

Primary Key: ICX_CART_LINE_DISTRIBUTION_UK1

1. DISTRIBUTION_NUM
2. CART_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

ICX_CART_LINE_DISTRIBUTIONS stores information about the accounting
distributions associated with each requisition line. Each requisition
line must have at least one accounting distribution. You need one
row for each requisition distribution you create.
.
DISTRIBUTION_ID is the unique identifier for the distribution. Each
distribution also contains the CART_LINE_ID from
ICX_SHOPPING_CART_LINES table, as well as CART_ID from
ICX_SHOPPING_CARTS table. The percent allocation to each amount is
stored in the ALLOCATION_VALUE field.
.

Indexes

Columns

[top of page]

ICX.ICX_CART_LINE_DISTRIBUTIONS does not reference any database object

ICX.ICX_CART_LINE_DISTRIBUTIONS is referenced by following:

APPS

SYNONYM - ICX_CART_LINE_DISTRIBUTIONS

[top of page]

Table: ICX_CATG_DETLS_INFO

Comments

Indexes

Columns

[top of page]

ICX.ICX_CATG_DETLS_INFO does not reference any database object

ICX.ICX_CATG_DETLS_INFO is referenced by following:

APPS

SYNONYM - ICX_CATG_DETLS_INFO

[top of page]

Table: ICX_CATG_DETLS_INFO_TL

Comments

Indexes

Columns

[top of page]

ICX.ICX_CATG_DETLS_INFO_TL does not reference any database object

ICX.ICX_CATG_DETLS_INFO_TL is referenced by following:

APPS

SYNONYM - ICX_CATG_DETLS_INFO_TL

[top of page]

Table: ICX_CAT_ADV_SRCH_SETUP

Comments

This table is obsolete since R12.

Columns

[top of page]

ICX.ICX_CAT_ADV_SRCH_SETUP does not reference any database object

ICX.ICX_CAT_ADV_SRCH_SETUP is referenced by following:

APPS

SYNONYM - ICX_CAT_ADV_SRCH_SETUP

[top of page]

Table: ICX_CAT_BROWSE_TREES

Comments

Each row in this table holds the parent and child category that defines the category relationship PARENT_CATEGORY_ID holds the category id of parent and CHILD_CATEGORY_ID holds the category id of child.
Root category (RT_CATEGORY_ID as '0') can only be a parent. Only Browsing categories can be the parent categories. Item Categories can only be child categories.

Columns

[top of page]

ICX.ICX_CAT_BROWSE_TREES does not reference any database object

ICX.ICX_CAT_BROWSE_TREES is referenced by following:

APPS

SYNONYM - ICX_CAT_BROWSE_TREES

[top of page]

Table: ICX_CAT_CATEGORIES_TL

Primary Key: ICX_CAT_CATEGORIES_TL_PK

1. LANGUAGE
2. RT_CATEGORY_ID

Comments

Categories are used to classify items into groups of related items.This table uses a flattened version of the base table/translation table structure usually used to support multilingual data. This approach was chosen because the number and relative size of the translatable columns closely matches or exceeds that of the non-translatable columns
There are 4 types of categories stored in this table:
1. Root category - A special type of seeded Browsing Category - This is the topmost category in the hierarchy (TYPE = 0)
2. Navigational or Browsing Categories (TYPE = 1)
3. Genus or Item Categories (TYPE = 2)
4. Requisition Templates - Requisition Templates from Core Purchasing are stored as categories with the key as <"ReqTemplate name">_tmpl (TYPE = 3)
Categories are uniquely identified by the KEY and LANGUAGE. This value can not be modified once it is created. ITEM_COUNT tells us the number of items the category contains.
REBUILD_FLAG Indicates whether the Oracle Text Index should be rebuilt due to changes in the Category Definition. Typically this is set when a category definition is changed.
Attribute SECTION_MAP, stores a bitmap to indicate whether a particular section tag is assigned already. Also used to derive STORED_IN_TABLE and STORED_IN_COLUMN.
If category id is 0,
If the n-th bit is 1 and 1<=n<=100, it means TEXT_BASE_ATTRIBUTEn column in ICX_CAT_ITEMS_TLP is already assigned to an existing text base attribute.
If the n-th bit is 1 and 100 If the n-th bit is 1 and 200 If category id > 0,
If the n-th bit is 1 and 1<=n<=50, it means TEXT_CAT_ATTRIBUTEn column in ICX_CAT_EXT_ITEMS_TLP is already assigned to an existing text category attribute.
If the n-th bit is 1 and 50 If the n-th bit is 1 and 100 Every time a new attribute is created, the section_map of the corresponding category will be updated and one of the bits will be flipped from 0 to 1.

Indexes

Columns

[top of page]

ICX.ICX_CAT_CATEGORIES_TL does not reference any database object

ICX.ICX_CAT_CATEGORIES_TL is referenced by following:

APPS

SYNONYM - ICX_CAT_CATEGORIES_TL

[top of page]

Table: ICX_CAT_CATEGORY_ITEMS

Comments

This table is obsolete since R12.

Indexes

Columns

[top of page]

ICX.ICX_CAT_CATEGORY_ITEMS does not reference any database object

ICX.ICX_CAT_CATEGORY_ITEMS is referenced by following:

APPS

SYNONYM - ICX_CAT_CATEGORY_ITEMS

[top of page]

Table: ICX_CAT_DELETED_ATTRIBUTES

Comments

This table is obsolete since R12.

Columns

[top of page]

ICX.ICX_CAT_DELETED_ATTRIBUTES does not reference any database object

ICX.ICX_CAT_DELETED_ATTRIBUTES is referenced by following:

APPS

SYNONYM - ICX_CAT_DELETED_ATTRIBUTES

[top of page]

Table: ICX_CAT_DESCRIPTORS_TL

Comments

There are 2 kinds of descriptors:
Base(Root) and
Local(Category) descriptors.
This table stores both these descriptors. This holds the translation information for all the descriptors.
For Local Descriptors, the column RT_CATEGORY_ID holds the Item Category Id reference value.
For Base Descriptors, the column RT_CATEGORY_ID stores the Root Category Id value. I.e. "0"
The attributes STORED_IN_TABLE and STORED_IN_COLUMN contains the table name and the column name where the attribute's value is stored for an item. These column values will be seeded for all the seeded base attributes. For example, for the base attribute "SUPPLIER", STORED_IN_TABLE will be populated with "ICX_CAT_ITEMS_TLP" and STORED_IN_COLUMN will be populated with "SUPPLIER".
When a new attribute is created, the values for the columns STORED_IN_TABLE and STORED_IN_COLUMNS are derived from the:
- Type of the Attribute (BASE/LOCAL)
- Data Type of the Attribute (TEXT/NUMERIC/TRANSLATABLE TEXT)
- Section Map value for the associated category.
SECTION_TAG is a number that is unique within a category. SECTION_TAG this is used for category attributes or base attributes created by users to derive which column in ICX_CAT_ITEMS_TLP or ICX_CAT_EXT_ITEMS_TLP stores this attribute.
The section_tag value is also used as the section tag in the CTX string if the attribute is searchable. For category attributes, section_tag starts at 5000 so it can be distinguished from the base attributes in the CTX string. To deduce the column, subtract 5000 from it. For non-seeded base attributes, section_tag starts for 1000. For seeded base attributes, section_tag will be seeded.

Indexes

Columns

[top of page]

ICX.ICX_CAT_DESCRIPTORS_TL does not reference any database object

ICX.ICX_CAT_DESCRIPTORS_TL is referenced by following:

APPS

SYNONYM - ICX_CAT_DESCRIPTORS_TL

[top of page]

Table: ICX_CAT_EXT_ITEMS_TLP

Comments

This table is obsolete since R12.

Indexes

Columns

[top of page]

ICX.ICX_CAT_EXT_ITEMS_TLP does not reference any database object

ICX.ICX_CAT_EXT_ITEMS_TLP is referenced by following:

APPS

SYNONYM - ICX_CAT_EXT_ITEMS_TLP

[top of page]

Table: ICX_CAT_ITEMS_B

Comments

This table is obsolete since R12.

Indexes

Columns

[top of page]

ICX.ICX_CAT_ITEMS_B does not reference any database object

ICX.ICX_CAT_ITEMS_B is referenced by following:

APPS

SYNONYM - ICX_CAT_ITEMS_B

[top of page]

Table: ICX_CAT_ITEMS_CTX_TLP

Comments

For each item, we construct a synthetic document Oracle Text will index on. This document is basically a concatenation of all the searchable attributes. To support efficient maintenance of these documents, each document is broken up into several rows, some for base attributes, some for category attributes. For each of these rows, SEQUENCE will be different.
CTX_DESC column stores the concatenation of all the searchable attributes.
ORG_ID column stores the id of the operating unit that owns this item, and in the case of global agreements, the ids of the different operating units that subscribe to the blanket where this item is extracted from.

Indexes

Columns

[top of page]

ICX.ICX_CAT_ITEMS_CTX_TLP does not reference any database object

ICX.ICX_CAT_ITEMS_CTX_TLP is referenced by following:

APPS

SYNONYM - ICX_CAT_ITEMS_CTX_TLP

[top of page]

Table: ICX_CAT_ITEMS_TLP

Primary Key: SYS_C00165714

1. RT_ITEM_ID
2. LANGUAGE

Comments

This table is obsolete since R12.

Primary Key: ICX_POR_ITEMS_TLP_PK1

1. RT_ITEM_ID
2. LANGUAGE

Indexes

Columns

[top of page]

ICX.ICX_CAT_ITEMS_TLP does not reference any database object

ICX.ICX_CAT_ITEMS_TLP is referenced by following:

APPS

SYNONYM - ICX_CAT_ITEMS_TLP

[top of page]

Table: ICX_CAT_ITEM_PRICES

Comments

This table is obsolete since R12.

Indexes

Columns