You are browsing the archive for EGO.

Oracle Advance Product Catalog Tables

Oracle Advance Product Catalog tables

  • EGO_ACTIONS_B
  • EGO_ACTIONS_TL
  • EGO_ACTION_DISPLAYS_B
  • EGO_ACTION_GROUPS_B
  • EGO_ACTION_GROUPS_TL
  • EGO_ACTN_GRP_ENTRIES_B
  • EGO_AML_INTF
  • EGO_ATTR_MAPPING_MASTER
  • EGO_ATTR_MAPPING_ROWS
  • EGO_BULKLOAD_INTF
  • EGO_CATG_MAP_DTLS
  • EGO_CATG_MAP_HDRS_B
  • EGO_CATG_MAP_HDRS_TL
  • EGO_CAT_GRP_MFG_ASSOCS
  • EGO_CAT_GRP_RPT_TEMPLATES
  • EGO_CAT_GRP_TEMPLATES
  • EGO_CRITERIA_EXT
  • EGO_CUSTOMIZATION_EXT
  • EGO_CUSTOMIZATION_RF
  • EGO_DM_CAT_PRIVILEGE_MAP
  • EGO_EXTERNAL_SYSTEM_DEF
  • EGO_EXTERNAL_SYS_ATTR_MAP
  • EGO_EXT_SYS_ELEMENTS
  • EGO_FND_DESC_FLEXS_EXT
  • EGO_FND_DF_COL_USGS_EXT
  • EGO_FND_DSC_FLX_CTX_EXT
  • EGO_FND_FLX_VAL_STS_EXT
  • EGO_FND_OBJECTS_EXT
  • EGO_FUNCTIONS_B
  • EGO_FUNCTIONS_TL
  • EGO_FUNC_PARAMS_B
  • EGO_FUNC_PARAMS_TL
  • EGO_GLOBAL_BUTTON
  • EGO_GTIN_SETUP
  • EGO_GTN_ATTR_CHG_B
  • EGO_GTN_ATTR_CHG_TL
  • EGO_GTN_MUL_ATTR_CHG_B
  • EGO_GTN_MUL_ATTR_CHG_TL
  • EGO_IMAGES
  • EGO_IMPORT_BATCHES_B
  • EGO_IMPORT_BATCHES_TL
  • EGO_IMPORT_BATCH_CHANGES
  • EGO_IMPORT_EXCLUDED_SS_ITEMS
  • EGO_IMPORT_OPTION_SETS
  • EGO_ITEMS_ATTRS_CHANGES_B
  • EGO_ITEMS_ATTRS_CHANGES_TL
  • EGO_ITEM_CAT_DENORM_HIER
  • EGO_ITEM_CUST_ATTRS_B
  • EGO_ITEM_GTN_ATTRS_B
  • EGO_ITEM_GTN_ATTRS_TL
  • EGO_ITEM_MATCHES
  • EGO_ITEM_PEOPLE_INTF
  • EGO_ITEM_PROJECTS
  • EGO_ITEM_TEXT_TL
  • EGO_ITEM_TP_ATTRS_EXT_B
  • EGO_ITEM_TP_ATTRS_EXT_TL
  • EGO_ITMATTR_APPL_USGS_B
  • EGO_ITM_GTN_MUL_ATTRS_B
  • EGO_ITM_GTN_MUL_ATTRS_TL
  • EGO_ITM_USR_ATTR_INTRFC
  • EGO_LANGUAGE_SETTINGS
  • EGO_LCPHASE_ITEM_STATUS
  • EGO_LCPHASE_POLICY
  • EGO_LOGIN_ITEMS_TEMP
  • EGO_MAPPINGS_B
  • EGO_MASSUPDATE_ITEM_TMP
  • EGO_MASSUPDATE_ORG_TMP
  • EGO_MFG_PART_NUM_CHGS
  • EGO_MINOR_REVISIONS
  • EGO_MTL_SY_ITEMS_CHG_B
  • EGO_MTL_SY_ITEMS_CHG_TL
  • EGO_MTL_SY_ITEMS_EXT_B
  • EGO_MTL_SY_ITEMS_EXT_TL
  • EGO_MY_ITEMS
  • EGO_OBJECT_EXT_TABLES_B
  • EGO_OBJECT_ROLES
  • EGO_OBJTYPE_ATTACH_CATS
  • EGO_OBJ_AG_ASSOCS_B
  • EGO_OBJ_ROLE_MAPPINGS
  • EGO_OBJ_TYPE_LIFECYCLES
  • EGO_PAGES_B
  • EGO_PAGES_TL
  • EGO_PAGE_ENTRIES_B
  • EGO_PRODUCT_CAT_SET_EXT
  • EGO_REPORTS
  • EGO_REPORT_DELIVERABLES
  • EGO_REPORT_LISTS_B
  • EGO_REPORT_LISTS_TL
  • EGO_REPORT_LIST_ENTRIES
  • EGO_RESULTS_FMT_USAGES
  • EGO_SOURCE_SYSTEM_EXT
  • EGO_SUBTAB
  • EGO_TAB_SETUP
  • EGO_TEMPL_ATTRIBUTES
  • EGO_UCCNET_ADD_CIC_INFO
  • EGO_UCCNET_BASELINES
  • EGO_UCCNET_EVENTS
  • EGO_UOM_MAPPING_MASTER
  • EGO_UOM_MAPPING_ROWS
  • EGO_VS_VALUES_DISP_ORDER

Advanced Product Catalog Concurrent Programs

Oracle Advanced Product Catalog / Product Information Management module Concurrent Programs:

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
EGOIPI Item People Import
EGOIUAIP This is the concurrent program for the EGOIUAI executable
EGOCIPSP This is the concurrent program for the EGOCIPS executable
EGOIMTIDX Create/Rebuild Item Catalog Text Index
EGOICI Import Catalog Items
EGOOPTICTI Optimize Item Catalog Text Index
EGO_ITEM_CAT_ASSIGN_OI Catalog Categories Assignment Open Interface
EGOBKUPL Bulkload Program For Spread Sheet Upload
EGOIPP Purge Item People Interface Lines
EGOIOIMP Item Organization Assignment Import
EGOCPAGV User-Defined Attribute Group Views (AGV) Compilation Program
EGOMUPURGE Clears item mass update temporary  tables
EGOPRTYSTUP EGO Setup Default Organization for User
EGOMATCH EGO Item Import Batch Matching Concurrent Program
EGOIJAVA EGO Spreadsheet Java Concurrent Program
EGOMUOCP EGO MassUpdate Organization Assignment Concurrent Program
EGOPHPRG EGO program to purge publish history based on input parameters
EGOIOIPURGEINTF Batch Purge for IOI Data from Intf tables

Views in Product Information Management Module

Views in Oracle Product Information Management (PIM) / Advanced Product Catalog (APC) module

EGO_ACTION_DISPLAYS_V
EGO_ACTION_GROUPS_V
EGO_ACTIONS_V
EGO_ALL_ATTR_BASE_V
EGO_ALL_ATTR_LANG_V
EGO_ATTR_GROUP_OBJ_IDS_V
EGO_ATTR_GROUP_TYPE_OBJ_IDS_V
EGO_ATTR_GROUP_TYPES_V
EGO_ATTR_GROUPS_DL_V
EGO_ATTR_GROUPS_V
EGO_ATTRS_V
EGO_CATALOG_GROUPS_V
EGO_CATG_MAP_HDRS_VL
EGO_COMPANIES_V
EGO_CRITERIA_TEMPLATES_V
EGO_CRITERIA_V
EGO_CUSTOMER_COMPANY_V
EGO_CUSTOMER_PEOPLE_V
EGO_DATA_LEVEL_VL
EGO_FINANCIAL_REPORTING_AGV
EGO_FND_OBJECTS_V
EGO_FP_DATA_TYPES_V
EGO_FUNC_PARAMS_V
EGO_FUNCTIONS_V
EGO_GROUP_MEMBERS_V
EGO_GROUPS_V
EGO_GTIN_ATTRS_TL_V
EGO_GTIN_ATTRS_V
EGO_GTIN_BARCODE_ATTRS_V
EGO_GTIN_COLOR_ATTRS_V
EGO_GTIN_COUNTRY_ORGN_V
EGO_GTIN_DELIVERY_METHOD_V
EGO_GTIN_HAND_INF_ATTRS_V
EGO_GTIN_HARMONIZED_ID_V
EGO_GTIN_HAZMAT_ATTRS_V
EGO_GTIN_MFG_ATTRS_V
EGO_GTIN_SIZE_DESC_V
EGO_GTIN_TP_ATTRS_V
EGO_GTIN_UCCNET_HIER_ATTRS_V
EGO_GTN_ATTR_CHG_VL
EGO_GTN_MUL_ATTR_CHG_VL
EGO_IMPORT_BATCH_DETAILS_V
EGO_IMPORT_BATCHES_VL
EGO_INTERNAL_COMPANY_V
EGO_INTERNAL_PEOPLE_V
EGO_ITEM_ATTRIBUTES_V
EGO_ITEM_GTIN_V
EGO_ITEM_GTN_ATTRS_VL
EGO_ITEM_ICV
EGO_ITEM_MAIN_ATTRS_V
EGO_ITEM_MINOR_REVISIONS_V
EGO_ITEM_OCV
EGO_ITEM_STATUS_V
EGO_ITEM_SYNC_OP_V
EGO_ITEM_SYNC_V
EGO_ITEM_TP_ATTRS_EXT_VL
EGO_ITEM_TRANS_ATTRS_VL
EGO_ITEMS_ATTRS_CHANGES_VL
EGO_ITEMS_V
EGO_ITM_GTN_MUL_ATTRS_VL
EGO_ITMATTR_APPL_USGS_V
EGO_MAPPINGS_V
EGO_MTL_SY_ITEMS_CHG_VL
EGO_MTL_SY_ITEMS_EXT_VL
EGO_MTL_SYS_ITEMS_B_EXT_DFV
EGO_OBJ_ATTR_GRP_ASSOCS_V
EGO_PAGE_ENTRIES_V
EGO_PAGES_V
EGO_PARTY_SITE_GLN_V
EGO_PEOPLE_V
EGO_PERSON_COMPANY_V
EGO_PROD_CAT_SALES_MARKET_AGV
EGO_PUB_BAT_ENT_OBJS_V
EGO_PUB_BAT_STATUS_V
EGO_PUB_BATCH_STATUS_VL
EGO_PUB_PARAMETERS_V
EGO_PUB_WS_OUTPUT_V
EGO_REPORT_LISTS_VL
EGO_RESULTS_FORMAT_COLUMNS_V
EGO_RESULTS_FORMAT_SECTIONS_V
EGO_RESULTS_FORMAT_V
EGO_ROLE_DETAILS_V
EGO_ROLE_PRIVILEGES_V
EGO_ROLES_V
EGO_RULE_SETS_VL
EGO_SBDH_BUYING_QTY_INFO_AGV
EGO_SBDH_BUYING_QTY_INFO_TPAGV
EGO_SBDH_BUYING_QTY_INFO_TPV
EGO_SBDH_CAMPAIGN_INFO_AGV
EGO_SBDH_CLASS_COMPLIANCE_AGV
EGO_SBDH_COUNTRY_OF_ASSY_AGV
EGO_SBDH_DEP_VAL_DATE_INFO_AGV
EGO_SBDH_ITEM_FEATURE_BNFT_AGV
EGO_SBDH_MATERIAL_INFO_AGV
EGO_SBDH_ORDERING_INFO_AGV
EGO_SBDH_ORDERING_INFO_TPAGV
EGO_SBDH_ORDERING_INFO_TPV
EGO_SBDH_PAYMENT_METHOD_AGV
EGO_SBDH_PAYMENT_METHOD_TPAGV
EGO_SBDH_PAYMENT_METHOD_TPV
EGO_SBDH_PRC_CMPRSN_CONTNT_AGV
EGO_SBDH_PRC_CMPRSN_MSRMT_AGV
EGO_SBDH_PRICE_INFO_AGV
EGO_SBDH_PRICE_INFO_TPAGV
EGO_SBDH_PRICE_INFO_TPV
EGO_SBDH_RETURNS_AGV
EGO_SBDH_SEASON_AGV
EGO_SBDH_SEASON_AVL_DATE_AGV
EGO_SBDH_SHIP_EXCL_DATES_AGV
EGO_SBDH_SHIP_EXCL_DATES_TPAGV
EGO_SBDH_SHIP_EXCL_DATES_TPV
EGO_SBDH_SIZE_INFO_AGV
EGO_SBDH_SPECIAL_ITEM_AGV
EGO_SBDH_STRG_HNDLG_HMDTY_AGV
EGO_SBDH_TARGET_CONSUMER_AGV
EGO_SBDH_TRADE_ITEM_INFO_AGV
EGO_SBDH_TRD_ITM_LIFESPAN_AGV
EGO_SBDH_TRD_ITM_LIFESPAN_TPV
EGO_SBDH_TRD_ITM_LIFSPAN_TPAGV
EGO_SBDH_VAR_TRD_ITEM_TYPE_AGV
EGO_SBDH_VAR_TRD_ITEM_TYPE_TPV
EGO_SBDH_VAR_TRD_ITM_TYP_TPAGV
EGO_STAT_ATTRIB_VALUES_V
EGO_SYS_ITEM_EXT_LANG_V
EGO_USER_RULES_VL
EGO_USER_V
EGO_VAL_SET_VALUE_TABLES_V
EGO_VALIDATION_TABLE_INFO_V
EGO_VALUE_SET_FORMAT_CODES_V
EGO_VALUE_SET_VALUES_V
EGO_VALUE_SETS_V
EGO_VENDOR_COMPANY_V
EGO_VENDOR_PEOPLE_V
EGO_VENDOR_V
EGO_VS_DISPLAY_CODES_V
EGO_VS_FORMAT_CODES_V
EGO_VS_VALIDATION_CODES_V