Oracle Purchasing Tables

September 20, 2010 in Technical Design

  • POA_BIS_SAVINGS
  • POA_BIS_SAVINGS_EFC
  • POA_BIS_SAVINGS_RPT
  • POA_BIS_SAVINGS_RPT_EFC
  • POA_BIS_SUPPLIER_PERFORMANCE
  • POA_BIS_SUPPLIER_PERFORMAN_EFC
  • POA_CM_DISTRIBUTIONS
  • POA_CM_EVALUATION
  • POA_CM_EVAL_SCORES
  • PO_ACCEPTANCES
  • PO_ACCRUAL_ACCOUNTS_TEMP_ALL
  • PO_ACCRUAL_RECONCILE_TEMP_ALL
  • PO_ACCRUAL_WRITE_OFFS_ALL
  • PO_ACCRUAL_WRITE_OFFS_ALL_EFC
  • PO_ACTION_HISTORY
  • PO_AGENTS
  • PO_APPROVAL_LIST_HEADERS
  • PO_APPROVAL_LIST_LINES
  • PO_APPROVED_SUPPLIER_LIST
  • PO_ASL_ATTRIBUTES
  • PO_ASL_DOCUMENTS
  • PO_ASL_STATUSES
  • PO_ASL_STATUS_RULES
  • PO_ATT_TMP_RECORDS
  • PO_AUTOSOURCE_DOCUMENTS_ALL
  • PO_AUTOSOURCE_RULES
  • PO_AUTOSOURCE_VENDORS
  • PO_CHANGE_REQUESTS
  • PO_COMMODITIES_B
  • PO_COMMODITIES_TL
  • PO_COMMODITY_CATEGORIES
  • PO_COMMODITY_GRANTS
  • PO_CONTROL_FUNCTIONS
  • PO_CONTROL_GROUPS_ALL
  • PO_CONTROL_RULES
  • PO_CONTROL_RULES_EFC
  • PO_DISTRIBUTIONS_ALL
  • PO_DISTRIBUTIONS_ALL_EBS
  • PO_DISTRIBUTIONS_ARCHIVE_ALL
  • PO_DISTRIBUTIONS_GT
  • PO_DISTRIBUTIONS_INTERFACE
  • PO_DOCUMENT_TOTALS_GT
  • PO_DOCUMENT_TYPES_ALL_B
  • PO_DOCUMENT_TYPES_ALL_TL
  • PO_EMPLOYEE_HIERARCHIES_ALL
  • PO_ENCUMBRANCE_GT
  • PO_GA_ORG_ASSIGNMENTS
  • PO_GA_ORG_ASSIGNMENTS_ARCHIVE
  • PO_HAZARD_CLASSES_B
  • PO_HAZARD_CLASSES_TL
  • PO_HEADERS_ALL
  • PO_HEADERS_ALL_EBS
  • PO_HEADERS_ARCHIVE_ALL
  • PO_HEADERS_GT
  • PO_HEADERS_INTERFACE
  • PO_HISTORY_POS_ALL
  • PO_HISTORY_RECEIPTS
  • PO_HISTORY_REQUISITIONS_ALL
  • PO_HISTORY_VENDORS
  • PO_INTERFACE_ERRORS
  • PO_JOB_ASSOCIATIONS_B
  • PO_JOB_ASSOCIATIONS_TL
  • PO_LINES_ALL
  • PO_LINES_ALL_EBS
  • PO_LINES_ARCHIVE_ALL
  • PO_LINES_INTERFACE
  • PO_LINE_LOCATIONS_ALL
  • PO_LINE_LOCATIONS_ALL_EBS
  • PO_LINE_LOCATIONS_ARCHIVE_ALL
  • PO_LINE_LOCATIONS_GT
  • PO_LINE_TYPES_B
  • PO_LINE_TYPES_TL
  • PO_LOCATION_ASSOCIATIONS
  • PO_LOCATION_ASSOCIATIONS_ALL
  • PO_MASSCANCEL_INCLUDES_ALL
  • PO_MASSCANCEL_INTERIM
  • PO_MC_DISTRIBUTIONS
  • PO_MC_HEADERS
  • PO_NOTES
  • PO_NOTE_ATTRIBUTES
  • PO_NOTE_REFERENCES
  • PO_NOTIFICATIONS_ALL
  • PO_NOTIFICATION_CONTROLS
  • PO_ONLINE_REPORT_TEXT
  • PO_POSITION_CONTROLS_ALL
  • PO_PRICE_DIFFERENTIALS
  • PO_PRICE_DIFFERENTIALS_ARCHIVE
  • PO_PRICE_DIFF_INTERFACE
  • PO_PURGE_PO_LIST
  • PO_PURGE_RECEIPT_LIST
  • PO_PURGE_REQ_LIST
  • PO_PURGE_VENDOR_LIST
  • PO_QUALITY_CODES
  • PO_QUOTATION_APPROVALS_ALL
  • PO_RELATED_TEMPLATES
  • PO_RELEASES_ALL
  • PO_RELEASES_ALL_EBS
  • PO_RELEASES_ARCHIVE_ALL
  • PO_REQEXPRESS_HEADERS_ALL
  • PO_REQEXPRESS_LINES_ALL
  • PO_REQUISITIONS_INTERFACE_ALL
  • PO_REQUISITIONS_INT_ALL_EFC
  • PO_REQUISITION_HEADERS_ALL
  • PO_REQUISITION_LINES_ALL
  • PO_REQUISITION_LINES_ALL_EFC
  • PO_REQUISITION_SUPPLIERS
  • PO_REQ_DISTRIBUTIONS_ALL
  • PO_REQ_DISTRIBUTIONS_ALL_EFC
  • PO_REQ_DIST_INTERFACE_ALL
  • PO_RESCHEDULE_INTERFACE
  • PO_RETRIEVED_TIMECARDS
  • PO_RFQ_VENDORS
  • PO_RULE_EXPENSE_ACCOUNTS
  • PO_SUPPLIER_ITEM_CAPACITY
  • PO_SUPPLIER_ITEM_TOLERANCE
  • PO_SYSTEM_PARAMETERS_ALL
  • PO_UNIQUE_IDENTIFIER_CONT_ALL
  • PO_UN_NUMBERS_B
  • PO_UN_NUMBERS_TL
  • PO_USAGES
  • PO_USAGE_ATTRIBUTES
  • PO_VALIDATION_RESULTS_GT
  • PO_VENDORS
  • PO_VENDORS_EBS
  • PO_VENDOR_CONTACTS
  • PO_VENDOR_LIST_ENTRIES
  • PO_VENDOR_LIST_HEADERS
  • PO_VENDOR_SITES_ALL
  • PO_VENDOR_SITES_ALL_EBS
  • PO_WF_CANDIDATE_REQ_LINES_TEMP
  • PO_WF_DEBUG
  • PO_WF_USER_TMP
  • RCV_ACCOUNTING_EVENTS
  • RCV_ACCOUNTING_EVENT_TYPES
  • RCV_FTE_TRANSACTION_LINES
  • RCV_GAPLESS_INVOICE_NUMBERS
  • RCV_HEADERS_INTERFACE
  • RCV_LOTS_INTERFACE
  • RCV_LOTS_SUPPLY
  • RCV_LOT_TRANSACTIONS
  • RCV_MC_REC_SUB_LEDGER
  • RCV_MC_SHIPMENT_HEADERS
  • RCV_MC_SHIPMENT_LINES
  • RCV_MC_SUB_LEDGER_DETAILS
  • RCV_MC_TRANSACTIONS
  • RCV_PARAMETERS
  • RCV_RECEIVING_SUB_LEDGER
  • RCV_ROUTING_HEADERS
  • RCV_ROUTING_HEADERS_OLD
  • RCV_ROUTING_STEPS
  • RCV_SERIALS_INTERFACE
  • RCV_SERIALS_SUPPLY
  • RCV_SERIAL_TRANSACTIONS
  • RCV_SHIPMENT_HEADERS
  • RCV_SHIPMENT_LINES
  • RCV_SHIPMENT_LINES_EFC
  • RCV_SUB_LEDGER_DETAILS
  • RCV_SUPPLY
  • RCV_TRANSACTIONS
  • RCV_TRANSACTIONS_INTERFACE
  • RCV_UPGRADE_STEPS

Oracle Order Capture Tables

September 20, 2010 in Oracle Order Capture

Oracle Order Capture module data base tables:

  • ASO_APR_APPROVAL_DETAILS
  • ASO_APR_APPROVAL_DET_B
  • ASO_APR_APPROVAL_DET_TL
  • ASO_APR_FUNCTION
  • ASO_APR_OBJ_APPROVALS
  • ASO_APR_RULES
  • ASO_APR_RULES_B
  • ASO_APR_RULES_TL
  • ASO_APR_RULE_APPROVERS
  • ASO_APR_RULE_GROUPS_B
  • ASO_APR_RULE_GROUPS_TL
  • ASO_APR_RULE_GRP_MEMBER
  • ASO_APR_RULE_STEPS_B
  • ASO_APR_RULE_STEPS_TL
  • ASO_BI_LINE_IDS
  • ASO_BI_QUOTE_FACT_JOBS
  • ASO_BI_QUOTE_HDRS_ALL
  • ASO_BI_QUOTE_HDRS_STG
  • ASO_BI_QUOTE_IDS
  • ASO_BI_QUOTE_LINES_ALL
  • ASO_BI_QUOTE_LINES_STG
  • ASO_ER_BIN_RS_FACT
  • ASO_ER_DATA_BIN_FACT
  • ASO_ER_ORD_HDRS_FACT
  • ASO_ER_ORD_LINES_FACT
  • ASO_ER_QTE_HDRS_FACT
  • ASO_ER_QTE_LINES_FACT
  • ASO_ER_REFRESH_LOG
  • ASO_FREIGHT_CHARGES
  • ASO_HEADER_RELATIONSHIPS
  • ASO_LINE_RELATIONSHIPS
  • ASO_PARTY_RELATIONSHIPS
  • ASO_PAYMENTS
  • ASO_PRICE_ADJUSTMENTS
  • ASO_PRICE_ADJ_ATTRIBS
  • ASO_PRICE_ADJ_RELATIONSHIPS
  • ASO_PRICE_ATTRIBUTES
  • ASO_QUOTE_ACCESSES
  • ASO_QUOTE_HEADERS_ALL
  • ASO_QUOTE_LINES_ALL
  • ASO_QUOTE_LINE_ATTRIBS_EXT
  • ASO_QUOTE_LINE_DETAILS
  • ASO_QUOTE_PARTIES
  • ASO_QUOTE_RELATED_OBJECTS
  • ASO_QUOTE_STATUSES_B
  • ASO_QUOTE_STATUSES_TL
  • ASO_QUOTE_STATUS_TRANSITIONS
  • ASO_SALES_CREDITS
  • ASO_SHIPMENTS
  • ASO_SUP_COMPONENT_B
  • ASO_SUP_COMPONENT_TL
  • ASO_SUP_COMP_RESP_MAP
  • ASO_SUP_INSTANCE_VALUE
  • ASO_SUP_RESPONSE_B
  • ASO_SUP_RESPONSE_TL
  • ASO_SUP_SECTION_B
  • ASO_SUP_SECTION_TL
  • ASO_SUP_SECT_COMP_MAP
  • ASO_SUP_TEMPLATE_B
  • ASO_SUP_TEMPLATE_SCOPE
  • ASO_SUP_TEMPLATE_TL
  • ASO_SUP_TMPL_INSTANCE
  • ASO_SUP_TMPL_SECT_MAP
  • ASO_TAX_DETAILS
  • ASO_UPGRADE_ERRORS

Oracle Configurator Tables

September 19, 2010 in Oracle Configurator

Important Oracle Configurator tables

  • CZ_ADDRESSES
  • CZ_ADDRESS_USES
  • CZ_ARCHIVES
  • CZ_ARCHIVE_REFS
  • CZ_ATP_REQUESTS
  • CZ_BATCH_VAL_SESSION_DATA
  • CZ_COMBO_FEATURES
  • CZ_CONFIG_ATTRIBUTES
  • CZ_CONFIG_EXT_ATTRIBUTES
  • CZ_CONFIG_HDRS
  • CZ_CONFIG_INPUTS
  • CZ_CONFIG_ITEMS
  • CZ_CONFIG_MESSAGES
  • CZ_CONFIG_USAGES
  • CZ_CONTACTS
  • CZ_CUSTOMERS
  • CZ_CUSTOMER_END_USERS
  • CZ_DB_LOGS
  • CZ_DB_SETTINGS
  • CZ_DB_SIZES
  • CZ_DES_CHART_CELLS
  • CZ_DES_CHART_COLUMNS
  • CZ_DES_CHART_FEATURES
  • CZ_DEVL_PRJ_USER_GROUPS
  • CZ_DEVL_PROJECTS
  • CZ_DRILL_DOWN_ITEMS
  • CZ_EFFECTIVITY_SETS
  • CZ_END_USERS
  • CZ_END_USER_GROUPS
  • CZ_EXPRESSIONS
  • CZ_EXPRESSION_NODES
  • CZ_EXP_TMP_LINES
  • CZ_EXT_APPLICATIONS
  • CZ_FILTER_SETS
  • CZ_FUNC_COMP_REFS
  • CZ_FUNC_COMP_SPECS
  • CZ_GRID_CELLS
  • CZ_GRID_COLS
  • CZ_GRID_DEFS
  • CZ_IMP_ADDRESS
  • CZ_IMP_ADDRESS_USE
  • CZ_IMP_CONTACT
  • CZ_IMP_CUSTOMER
  • CZ_IMP_CUSTOMER_END_USER
  • CZ_IMP_DEVL_PROJECT
  • CZ_IMP_END_USER
  • CZ_IMP_END_USER_GROUP
  • CZ_IMP_INTL_TEXT
  • CZ_IMP_ITEM_MASTER
  • CZ_IMP_ITEM_PARENT
  • CZ_IMP_ITEM_PROPERTY_VALUE
  • CZ_IMP_ITEM_TYPE
  • CZ_IMP_ITEM_TYPE_PROPERTY
  • CZ_IMP_LOCALIZED_TEXTS
  • CZ_IMP_MODEL_REF_EXPLS
  • CZ_IMP_PRICE
  • CZ_IMP_PRICE_GROUP
  • CZ_IMP_PROPERTY
  • CZ_IMP_PS_NODES
  • CZ_IMP_RULES
  • CZ_IMP_TMP_ITEMCAT
  • CZ_IMP_USER_GROUP
  • CZ_INTL_TEXTS
  • CZ_ITEM_MASTERS
  • CZ_ITEM_PARENTS
  • CZ_ITEM_PROPERTY_VALUES
  • CZ_ITEM_TYPES
  • CZ_ITEM_TYPE_PROPERTIES
  • CZ_JRAD_CHUNKS
  • CZ_LCE_CLOBS
  • CZ_LCE_HEADERS
  • CZ_LCE_LINES
  • CZ_LCE_LOAD_SPECS
  • CZ_LCE_OPERANDS
  • CZ_LCE_TEXTS
  • CZ_LOCALES
  • CZ_LOCALIZED_TEXTS
  • CZ_LOCK_HISTORY
  • CZ_LOOKUP_VALUES
  • CZ_LOOKUP_VALUES_TL
  • CZ_MODEL_PUBLICATIONS
  • CZ_MODEL_REF_EXPLS
  • CZ_MODEL_USAGES
  • CZ_MODEL_USAGES_TL
  • CZ_OPPORTUNITY_HDRS
  • CZ_OPP_HDR_CONTACTS
  • CZ_PB_CLIENT_APPS
  • CZ_PB_LANGUAGES
  • CZ_PB_MODEL_EXPORTS
  • CZ_PB_TEMP_IDS
  • CZ_POPULATORS
  • CZ_POPULATOR_MAPS
  • CZ_PRICES
  • CZ_PRICE_GROUPS
  • CZ_PRICING_STRUCTURES
  • CZ_PROPERTIES
  • CZ_PROPOSAL_HDRS
  • CZ_PROP_QUOTE_HDRS
  • CZ_PSNODE_PROPCOMPAT_GENS
  • CZ_PS_NODES
  • CZ_PS_PROP_VALS
  • CZ_PUBLICATION_USAGES
  • CZ_QUOTE_HDRS
  • CZ_QUOTE_MAIN_ITEMS
  • CZ_QUOTE_ORDERS
  • CZ_QUOTE_SPARES
  • CZ_QUOTE_SPECIAL_ITEMS
  • CZ_REL_TYPES
  • CZ_RP_ENTRIES
  • CZ_RULES
  • CZ_RULE_FOLDERS
  • CZ_SERVERS
  • CZ_SIGNATURES
  • CZ_SIGNATURE_ARGUMENTS
  • CZ_SPARES_SPECIALS
  • CZ_SUB_CON_SETS
  • CZ_TERMINATE_MSGS
  • CZ_TYPE_RELATIONSHIPS
  • CZ_UI_ACTIONS
  • CZ_UI_CONT_TYPE_TEMPLS
  • CZ_UI_DEFS
  • CZ_UI_IMAGES
  • CZ_UI_NODES
  • CZ_UI_NODE_PROPS
  • CZ_UI_PAGES
  • CZ_UI_PAGE_ELEMENTS
  • CZ_UI_PAGE_REFS
  • CZ_UI_PAGE_SETS
  • CZ_UI_PROPERTIES
  • CZ_UI_REFS
  • CZ_UI_REF_TEMPLATES
  • CZ_UI_TEMPLATES
  • CZ_UI_TEMPLATE_ELEMENTS
  • CZ_UI_XMLS
  • CZ_USER_GROUPS
  • CZ_XFR_FIELDS
  • CZ_XFR_FIELD_REQUIRES
  • CZ_XFR_PRICE_LISTS
  • CZ_XFR_PROJECT_BILLS
  • CZ_XFR_RUN_INFOS
  • CZ_XFR_RUN_RESULTS
  • CZ_XFR_STATUS_CODES
  • CZ_XFR_TABLES