You are browsing the archive for Technical Design.

Oracle Advanced Pricing Forms

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

Advanced Pricing Tables

Oracle Advanced Pricing Tables:

  • QP_LIST_HEADERS_TL
  • QP_LIST_HEADER_PHASES
  • QP_LIST_LINES
  • QP_LIST_LINES_EBS_LOG
  • QP_LIST_LINES_TEMP
  • QP_PARAMETERS_B
  • QP_PARAMETERS_TL
  • QP_PARAMETER_VALUES
  • QP_PATTERNS
  • QP_PATTERN_PHASES
  • QP_PB_INPUT_HEADERS_B
  • QP_PB_INPUT_HEADERS_TL
  • QP_PB_INPUT_LINES
  • QP_PRC_CONTEXTS_B
  • QP_PRC_CONTEXTS_TL
  • QP_PREQ_LINES_TMP_T
  • QP_PREQ_LINE_ATTRS_TMP_T
  • QP_PREQ_QUAL_TMP_T
  • QP_PRICE_BOOK_ATTRIBUTES
  • QP_PRICE_BOOK_BREAK_LINES
  • QP_PRICE_BOOK_HEADERS_ALL_B
  • QP_PRICE_BOOK_HEADERS_TL
  • QP_PRICE_BOOK_LINES
  • QP_PRICE_BOOK_LINE_DETAILS
  • QP_PRICE_BOOK_MESSAGES
  • QP_PRICE_FORMULAS_B
  • QP_PRICE_FORMULAS_TL
  • QP_PRICE_FORMULA_LINES
  • QP_PRICE_REQ_SOURCES
  • QP_PRICING_ATTRIBUTES
  • QP_PRICING_ATT_EBS_LOG
  • QP_PRICING_PHASES
  • QP_PTE_REQUEST_TYPES_B
  • QP_PTE_REQUEST_TYPES_TL
  • QP_PTE_SEGMENTS
  • QP_PTE_SOURCE_SYSTEMS
  • QP_QUALIFIERS
  • QP_QUALIFIERS_EBS_LOG
  • QP_QUALIFIERS_FWK_DUMMY
  • QP_QUALIFIER_RULES
  • QP_RLTD_MODIFIERS
  • QP_RLTD_MOD_EBS_LOG
  • QP_SEGMENTS_B
  • QP_SEGMENTS_TL
  • QP_SOURCESYSTEM_FNAREA_MAP
  • QP_UI_QUERIES_TL
  • QP_UI_QUERY_COLUMNS
  • QP_UPGRADE_ERRORS
  • QP_UPG_LINES_DISTRIBUTION
OE_AGREEMENTS
OE_AGREEMENTS_B
OE_AGREEMENTS_TL
OE_ITEM_GROUPS
OE_ITEM_GROUP_LINES
OE_PRC_COPY_PARAMETERS
OE_PRC_RULE_LINE_VALUES
OE_PRICE_LISTS
OE_PRICING_CONTRACTS
OE_PRICING_RULES_B
OE_PRICING_RULES_TL
OE_PRICING_RULE_LINES
OE_RULE_FORMULA_COMPTS
QP_ADV_MOD_PRODUCTS
QP_ARCH_CRITERIA_HEADERS
QP_ARCH_CRITERIA_LINES
QP_ARCH_LIST_HEADERS_B
QP_ARCH_LIST_HEADERS_TL
QP_ARCH_LIST_LINES
QP_ARCH_PRICING_ATTRIBUTES
QP_ARCH_QUALIFIERS
QP_ARCH_RLTD_MODIFIERS
QP_ARCH_ROW_COUNTS
QP_ATTRIBUTE_DEFNS
QP_ATTRIBUTE_GROUPS
QP_ATTRIBUTE_SOURCING
QP_CACHE_DO_SIZES
QP_CACHE_KEY_STATS
QP_CACHE_STATS
QP_COUPONS
QP_CURRENCY_DETAILS
QP_CURRENCY_LISTS_B
QP_CURRENCY_LISTS_TL
QP_DEBUG_FORMULA_STEP_VALUES
QP_DEBUG_REQ
QP_DEBUG_REQ_LDETS
QP_DEBUG_REQ_LINES
QP_DEBUG_REQ_LINE_ATTRS
QP_DEBUG_REQ_RLTD_LINES
QP_DEBUG_TEXT
QP_DISCOUNT_MAPPING
QP_EVENT_PHASES
QP_FACTOR_LIST_ATTRS
QP_FORMULAS_EBS_LOG
QP_FORMULA_LN_EBS_LOG
QP_FWK_DELAYED_REQUESTS
QP_GRANTS
QP_INTERFACE_ERRORS
QP_INTERFACE_LIST_HEADERS
QP_INTERFACE_LIST_LINES
QP_INTERFACE_PRICING_ATTRIBS
QP_INTERFACE_QUALIFIERS
QP_INT_FML_STEP_VALS_T
QP_INT_LDETS_T
QP_INT_LINES_T
QP_INT_LINE_ATTRS_T
QP_INT_PROFS_T
QP_INT_RLTD_LINES_T
QP_JSESSIONS
QP_LIMITS
QP_LIMIT_ATTRIBUTES
QP_LIMIT_BALANCES
QP_LIMIT_TRANSACTIONS
QP_LIST_HEADERS_B
QP_LIST_HEADERS_EBS_LOG
QP_LIST_HEADERS_TL
QP_LIST_HEADER_PHASES
QP_LIST_LINES
QP_LIST_LINES_EBS_LOG
QP_LIST_LINES_TEMP
QP_PARAMETERS_B
QP_PARAMETERS_TL
QP_PARAMETER_VALUES
QP_PATTERNS
QP_PATTERN_PHASES
QP_PB_INPUT_HEADERS_B
QP_PB_INPUT_HEADERS_TL
QP_PB_INPUT_LINES
QP_PRC_CONTEXTS_B
QP_PRC_CONTEXTS_TL
QP_PREQ_LINES_TMP_T
QP_PREQ_LINE_ATTRS_TMP_T
QP_PREQ_QUAL_TMP_T
QP_PRICE_BOOK_ATTRIBUTES
QP_PRICE_BOOK_BREAK_LINES
QP_PRICE_BOOK_HEADERS_ALL_B
QP_PRICE_BOOK_HEADERS_TL
QP_PRICE_BOOK_LINES
QP_PRICE_BOOK_LINE_DETAILS
QP_PRICE_BOOK_MESSAGES
QP_PRICE_FORMULAS_B
QP_PRICE_FORMULAS_TL
QP_PRICE_FORMULA_LINES
QP_PRICE_REQ_SOURCES
QP_PRICING_ATTRIBUTES
QP_PRICING_ATT_EBS_LOG
QP_PRICING_PHASES
QP_PTE_REQUEST_TYPES_B
QP_PTE_REQUEST_TYPES_TL
QP_PTE_SEGMENTS
QP_PTE_SOURCE_SYSTEMS
QP_QUALIFIERS
QP_QUALIFIERS_EBS_LOG
QP_QUALIFIERS_FWK_DUMMY
QP_QUALIFIER_RULES
QP_RLTD_MODIFIERS
QP_RLTD_MOD_EBS_LOG
QP_SEGMENTS_B
QP_SEGMENTS_TL
QP_SOURCESYSTEM_FNAREA_MAP
QP_UI_QUERIES_TL
QP_UI_QUERY_COLUMNS
QP_UPGRADE_ERRORS
QP_UPG_LINES_DISTRIBUTION

Views in Price Protection Module

Views in Oracle Price Protection Module

DPP_CUSTOMER_CLAIMS_ALL_DFV
DPP_INV_DET_ADJ_ALL_DFV
DPP_INVENTORY_DETAILS_ALL_DFV
DPP_LOOKUPS
DPP_TRANSACTION_HEADER_DFV
DPP_TRANSACTION_LINES_DFV
DPP_TXN_DASHBOARD_V
DPP_WEBADI_V
DPP_XLA_CLAIM_HEADERS_V
DPP_XLA_CLAIM_LINES_V
DPP_XLA_CP_V
DPP_XLA_INV_CU_V
DPP_XLA_INV_HEADERS_V
DPP_XLA_INV_LINES_V