Tuesday, 26 February 2013

Oracle iProcurement Tables



    ICX_AUDIT
    ICX_CART_DISTRIBUTIONS
    ICX_CART_LINE_DISTRIBUTIONS
    ICX_CATG_DETLS_INFO
    ICX_CATG_DETLS_INFO_TL
    ICX_CAT_ADV_SRCH_SETUP
    ICX_CAT_BROWSE_TREES
    ICX_CAT_CATEGORIES_TL
    ICX_CAT_CATEGORY_ITEMS
    ICX_CAT_DELETED_ATTRIBUTES
    ICX_CAT_DESCRIPTORS_TL
    ICX_CAT_EXT_ITEMS_TLP
    ICX_CAT_ITEMS_B
    ICX_CAT_ITEMS_CTX_TLP
    ICX_CAT_ITEMS_TLP
    ICX_CAT_ITEM_PRICES
    ICX_CAT_ITEM_SRC_DETAILS
    ICX_CAT_POPULATE_CTX_GT
    ICX_CAT_PRICE_HISTORY
    ICX_CAT_PRICE_LISTS
    ICX_CAT_SCHEMA_VERSIONS
    ICX_CAT_STORES_B
    ICX_CAT_STORES_TL
    ICX_CAT_STORE_CATALOGS
    ICX_CAT_UPLOAD_IT_DUMP
    ICX_CAT_UPLOAD_PRICE_DUMP
    ICX_COLORS
    ICX_CONTEXT_RESULTS_TEMP
    ICX_CUSTOM_MENU_ENTRIES
    ICX_ENABLED_PLSQL
    ICX_FAILURES
    ICX_ITEM_DETLS_INFO
    ICX_ITEM_DETLS_INFO_TL
    ICX_MARGIN_ANALYSIS
    ICX_MARGIN_ANALYSIS_ERR
    ICX_OE_CARTS
    ICX_OE_CART_ERRORS
    ICX_OE_CART_LINES
    ICX_PAGES
    ICX_PAGES_TL
    ICX_PAGE_COLORS
    ICX_PAGE_COLORS_TL
    ICX_PAGE_COLOR_SCHEME
    ICX_PAGE_PLUGS
    ICX_PANEL_SUMMARY
    ICX_PARAMETERS
    ICX_PORTLET_CUSTOMIZATIONS
    ICX_POR_BATCH_JOBS
    ICX_POR_BATCH_JOB_DETAILS
    ICX_POR_BROWSE_CATEGORIES
    ICX_POR_BUGSEYE_CONFIG
    ICX_POR_BUGSEYE_FLAGS
    ICX_POR_BUYER_APPROVAL_JOBS
    ICX_POR_CATALOG_ATTACHMENTS
    ICX_POR_CATALOG_PREFERENCES
    ICX_POR_CATEGORIES_TL
    ICX_POR_CATEGORY_DATA_SOURCES
    ICX_POR_CATEGORY_DEFAULTS
    ICX_POR_CATEGORY_ITEMS
    ICX_POR_CATEGORY_ORDER_MAP
    ICX_POR_CONFIG_PARAMETERS
    ICX_POR_CONTEXT_POLICY
    ICX_POR_CONTRACT_REFERENCES
    ICX_POR_CTX_TL
    ICX_POR_DAILY_NOTIFICATIONS
    ICX_POR_DESCRIPTORS_CACHE
    ICX_POR_DESCRIPTORS_TL
    ICX_POR_DOWNLOAD_JOB_DETAILS
    ICX_POR_EXT_QUERY
    ICX_POR_EXT_QUERY_TL
    ICX_POR_FAILED_ATTACHMENTS
    ICX_POR_FAILED_LINES
    ICX_POR_FAILED_LINE_MESSAGES
    ICX_POR_ITEMS
    ICX_POR_ITEMS_TL
    ICX_POR_ITEM_CONSTRAINT
    ICX_POR_ITEM_CTX_INDEX
    ICX_POR_ITEM_SITE
    ICX_POR_ITEM_SOURCES
    ICX_POR_ITEM_SOURCES_TL
    ICX_POR_LOADER_VALUES
    ICX_POR_LOAD_ITEM_MATCH
    ICX_POR_LOG
    ICX_POR_MANAGE_GROUPS_CACHE
    ICX_POR_ORACLE_ITEM_SUB
    ICX_POR_PRICE_BREAKS
    ICX_POR_PRICE_HISTORY
    ICX_POR_PRICE_LISTS
    ICX_POR_PRICE_LIST_LINES
    ICX_POR_PRICE_LIST_LINES_CACHE
    ICX_POR_REALMS
    ICX_POR_REALMS_TL
    ICX_POR_REALM_COMPONENTS
    ICX_POR_SEARCH_CONFIG
    ICX_POR_SEARCH_CONFIG_POLICY
    ICX_POR_SITE
    ICX_POR__OF_CONTENTS_TL
    ICX_POR_TEMPLATE_FILES
    ICX_POR_THIRD_PARTY_LOGS
    ICX_POR_THIRD_PARTY_LOG_VALUES
    ICX_POR_TITLE_ADMIN
    ICX_POR_TITLE_ADMIN_TL
    ICX_POR_TITLE_REGISTRY
    ICX_POR_UNIT
    ICX_POR_UNSPSC_CODES
    ICX_POR_UPLOADER_SUB
    ICX_POR_UPLOAD_ITEMS_IT
    ICX_POR_UPLOAD_IT_DUMP
    ICX_POR_UPLOAD_PRICES_IT
    ICX_POR_UPLOAD_PRICE_BREAKS_DP
    ICX_POR_UPLOAD_PRICE_BREAKS_IT
    ICX_POR_VERSION_INFO
    ICX_PO_REVISIONS_TEMP
    ICX_PROCUREMENT_SERVER_SETUP
    ICX_PROMPTS
    ICX_QUESTIONS
    ICX_QUESTIONS_TL
    ICX_QUESTION_FUNCTIONS
    ICX_REGIONS
    ICX_RELATED_CATEGORIES
    ICX_REQUISITIONER_INFO
    ICX_REQ_CART_ERRORS
    ICX_SESSIONS
    ICX_SESSION_ATTRIBUTES
    ICX_SHOPPING_CARTS
    ICX_SHOPPING_CART_LINES
    ICX_STORE_INDEX
    ICX_TEMPLATE_TAGS
    ICX_TEXT
    ICX_TRANSACTIONS
    ICX_UNSPSC_CODES
    ICX_USER_PROFILES
    ICX_VERSIONS
    ICX_WEB_STORE_OPTIONS
    POR_CONFIGURABLE_USER_DATA
    POR_CONTAINER_IMAGES
    POR_EMPLOYEE_LOADER_VALUES
    POR_FAVORITE_LIST_HEADERS
    POR_FAVORITE_LIST_LINES
    POR_FAV_CHARGE_ACCOUNTS
    POR_FEED_FIELD_FORMATS
    POR_FEED_HISTORY
    POR_FEED_RECORDS
    POR_IMAGES
    POR_IMAGE_LANG_SETTINGS
    POR_ITEM_ATTRIBUTE_VALUES
    POR_LOCATION_LOADER_VALUES
    POR_LOV_DISPLAY_RESULTS
    POR_LOV_RESULT_VALUES
    POR_TEMPLATE_ASSOC
    POR_TEMPLATE_INFO
    POR_USER_DATA_CONF_LIST
    POR_USER_DATA_CONF_LIST_ITEMS
    POS_ACK_SELECT
    POS_ASN_SEARCH_RESULT
    POS_ASN_SHOP_CART_DETAILS
    POS_ASN_SHOP_CART_HEADERS

=========================  ***********************   =====================


Table Name

Feature Area

ICX_CAT_ATTRIBUTES_TL

Catalog Authoring, Shopping

ICX_CAT_BATCH_JOBS_ALL

Catalog Authoring

ICX_CAT_CONTENT_ZONES_B

Catalog Authoring, Shopping

ICX_CAT_CONTENT_ZONES_TL

Catalog Authoring, Shopping

ICX_CAT_CONVERTER_DETAILS

Catalog Authoring

ICX_CAT_DELETED_SQES

Catalog Authoring

ICX_CAT_FAV_LIST_HEADERS

Catalog Authoring, Shopping

ICX_CAT_FAV_LIST_LINES_TLP

Catalog Authoring, Shopping

ICX_CAT_ITEMS_CTX_DTLS_TLP

Catalog Authoring, Shopping

ICX_CAT_ITEMS_CTX_HDRS_TLP

Catalog Authoring, Shopping

ICX_CAT_PARSE_ERRORS

Catalog Authoring

ICX_CAT_PUNCHOUT_ZONE_DETAILS

Catalog Authoring, Shopping

ICX_CAT_R12_UPGRADE

R12 Upgrade

ICX_CAT_R12_UPGRADE_JOBS

R12 Upgrade

ICX_CAT_R12_UPG_AUTOSOURCE

R12 Upgrade

ICX_CAT_R12_UPG_EXCEP_FILES

R12 Upgrade

ICX_CAT_R12_UPG_ERROR_MSGS

R12 Upgrade

ICX_CAT_SECURE_CONTENTS

Catalog Authoring, Shopping

ICX_CAT_SHOP_STORES_B

Catalog Authoring, Shopping

ICX_CAT_SHOP_STORES_TL

Catalog Authoring, Shopping

ICX_CAT_STORE_CONTENTS

Catalog Authoring, Shopping

ICX_CAT_ZONE_ATTRIBUTES

Catalog Authoring, Shopping

ICX_CAT_ZONE_SECURE_ATTRIBUTES

Catalog Authoring, Shopping

Changed Tables

N/A

Obsolete Tables

Table Name

Feature Area

Optional - Replaced By

ICX_CAT_CATEGORY_ITEMS

Catalog Authoring, Shopping

ICX_CAT_EXT_ITEMS_TLP

Catalog Authoring, Shopping

PO_ATTRIBUTE_VALUES,

PO_ATTRIBUTE_VALUES_TLP

ICX_CAT_ITEMS_B

Catalog Authoring, Shopping

ICX_CAT_ITEMS_TLP

Catalog Authoring, Shopping

ICX_CAT_ITEMS_CTX_HDRS_TLP

ICX_CAT_ITEM_PRICES

Catalog Authoring, Shopping

ICX_CAT_ITEM_SRC_DETAILS

Catalog Authoring, Shopping

ICX_CAT_ZONE_SECURE_ATTRIBUTES,

ICX_CAT_ZONE_ATTRIBUTES

ICX_POR_ITEM_SOURCES

Catalog Authoring, Shopping

ICX_CAT_CONTENT_ZONES_B

ICX_POR_ITEM_SOURCES_TL

Catalog Authoring, Shopping

ICX_CAT_CONTENT_ZONES_TL

ICX_CAT_PRICE_LISTS

Catalog Authoring, Shopping

ICX_CAT_STORES_B

Catalog Authoring, Shopping

ICX_CAT_SHOP_STORES_B

ICX_CAT_STORES_TL

Catalog Authoring, Shopping

ICX_CAT_SHOP_STORES_TL

ICX_CAT_STORE_CATALOGS

Catalog Authoring, Shopping

ICX_CAT_STORE_CONTENTS

ICX_CAT_STORE_ORG_ASSIGNMENTS

Catalog Authoring, Shopping

ICX_CAT_SECURE_CONTENTS

ICX_CAT_UPLOAD_IT_DUMP

Catalog Authoring

ICX_CAT_UPLOAD_PRICE_DUMP

Catalog Authoring

POR_FAVORITE_LIST_HEADERS

Catalog Authoring, Shopping

ICX_CAT_FAV_LIST_HEADERS

POR_FAVORITE_LIST_LINES

Catalog Authoring, Shopping

ICX_CAT_FAV_LIST_LINES_TLP

New Views

View Name

Feature Area

ICX_CAT_AGREEMENT_ATTRS_V

Catalog Authoring, Shopping

ICX_CAT_CATEGORIES_V

Catalog Authoring, Shopping

ICX_CAT_CONTENT_ZONES_VL

Catalog Authoring, Shopping

ICX_CAT_LATEST_BATCH_JOBS_V

Catalog Authoring

ICX_CAT_PURCHASING_CAT_MAP_V

Catalog Authoring, Shopping

ICX_CAT_SHOPPING_CAT_MAP_V

Catalog Authoring, Shopping

ICX_CAT_SHOP_STORES_VL

Catalog Authoring, Shopping

ICX_CAT_STORE_CONTENTS_V

Catalog Authoring,

No comments:

Post a Comment