You are browsing the archive for Order Management.

by oracleguru

Oracle Order Capture Tables

ORACLE APPS COMMUNITY > Tutorial > Order Management

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

Tags: , No Comments »

by oracleguru

Oracle Configurator Tables

ORACLE APPS COMMUNITY > Tutorial > Order Management

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

Tags: , 5 Comments »

by oracleguru

Oracle Advanced Pricing Forms

ORACLE APPS COMMUNITY > Tutorial > Order Management

Oracle Advanced Pricing Forms:

FORM SHORT CODE ORACLE FORM NAME
QPXEVPHS Event Phases
QPXPRAIG Add Item Groups
QPXPRAII Add Inventory Items
QPXPRCPL Copy Price List
QPXPRDDI Define Discounts
QPXPRDPC Enable Parameters
QPXPRDPL Define Price Lists
QPXPRDPR Define Pricing Rules
QPXPREPG Define Item Groups
QPXPRFOR Define Pricing Formulas
QPXPRLST Create Price Lists
QPXPRMLS Define Modifiers
QPXPRMPL Adjust Price Lists
QPXPRPFC Define Pricing Components
QPXPRPHS Define Modifier Incompatibility Groups
QPXPRQFS Define Qualifiers
QPXPRURP Update Formula Prices
QPXRQSRC Source Systems
QPXSSDAF Define Agreements
PQPWSDSH Enter and Maintain Employment History Periods
QPXLIMIT Define Limits
QPXQPORG Pricing Organizer
QPXAMPTE Pricing Transaction Entities
QPXCONAT Context and Segments
QPXPTMAP Attribute Mapping
PQPWSDAA Define Work Pattern Details
QPXPRREQ Query Pricing Request Temp Tables
QPXUPGRA View Upgrade Errors
QPXPACRL Accrual Redemption
QPXARCHV Archive Pricing Entities
QPXPURGE Purge Pricing Entities
PQPGBDSH Define Employment History Periods
PQPGBDAA Define Extra Details Of Service
PQPGBELE Mileage Element Creation Template
PQPWSVHD Enter and Maintain Vehicle Details
QPXCURRY Define Multi-Currency Lists

Tags: No Comments »