Friday 18 July 2014

Oracle Pricing Table List

select * from QP_ADV_MOD_PRODUCTS

select * from QP_ARCH_CRITERIA_HEADERS

select * from QP_ARCH_CRITERIA_LINES

select * from QP_ARCH_LIST_HEADERS_B

select * from QP_ARCH_LIST_HEADERS_TL

select * from QP_ARCH_LIST_LINES

select * from QP_ARCH_PRICING_ATTRIBUTES

select * from QP_ARCH_QUALIFIERS

select * from QP_ARCH_RLTD_MODIFIERS

select * from QP_ARCH_ROW_COUNTS

select * from QP_ATTRIBUTE_DEFNS

select * from QP_ATTRIBUTE_GROUPS

select * from QP_ATTRIBUTE_SOURCING

select * from QP_CACHE_DO_SIZES

select * from QP_CACHE_KEYS_TMP

select * from QP_CACHE_KEY_STATS

select * from QP_CACHE_STATS

select * from QP_COUPONS

select * from QP_CURRENCY_DETAILS

select * from QP_CURRENCY_LISTS_B

select * from QP_CURRENCY_LISTS_TL

select * from QP_DEBUG_FORMULA_STEP_VALUES

select * from QP_DEBUG_REQ

select * from QP_DEBUG_REQ_LDETS

select * from QP_DEBUG_REQ_LINES

select * from QP_DEBUG_REQ_LINE_ATTRS

select * from QP_DEBUG_REQ_RLTD_LINES

select * from QP_DEBUG_TEXT

select * from QP_DISCOUNTS_UPG_TEMP

select * from QP_DISCOUNT_MAPPING

select * from QP_DOCUMENTS

select * from QP_EVENT_PHASES

select * from QP_FACTOR_LIST_ATTRS

select * from QP_FORMULAS_EBS_LOG

select * from QP_FORMULA_LN_EBS_LOG

select * from QP_FORMULA_STEP_VALUES_TMP_T

select * from QP_FWK_DELAYED_REQUESTS

select * from QP_GRANTS

select * from QP_INTERFACE_ERRORS

select * from QP_INTERFACE_LIST_HEADERS

select * from QP_INTERFACE_LIST_LINES

select * from QP_INTERFACE_PRICING_ATTRIBS

select * from QP_INTERFACE_QUALIFIERS

select * from QP_INT_FML_STEP_VALS_T

select * from QP_INT_LDETS_T

select * from QP_INT_LINES_T

select * from QP_INT_LINE_ATTRS_T

select * from QP_INT_PROFS_T

select * from QP_INT_RLTD_LINES_T

select * from QP_JSESSIONS

select * from QP_LIMITS

select * from QP_LIMIT_ATTRIBUTES

select * from QP_LIMIT_BALANCES

select * from QP_LIMIT_TRANSACTIONS

select * from QP_LIST_HEADERS_B

select * from QP_LIST_HEADERS_EBS_LOG

select * from QP_LIST_HEADERS_TL

select * from QP_LIST_HEADER_PHASES

select * from QP_LIST_HEADER_TEMP

select * from QP_LIST_LINES

select * from QP_LIST_LINES_EBS_LOG

select * from QP_LIST_LINES_TEMP

select * from QP_LIST_LINES_TMP

select * from QP_PARAMETERS_B

select * from QP_PARAMETERS_TL

select * from QP_PARAMETER_VALUES

select * from QP_PATTERNS

select * from QP_PATTERN_PHASES

select * from QP_PB_INPUT_HEADERS_B

select * from QP_PB_INPUT_HEADERS_TL

select * from QP_PB_INPUT_LINES

select * from QP_PRC_CONTEXTS_B

select * from QP_PRC_CONTEXTS_TL

select * from QP_PREQ_LDETS_TMP_T

select * from QP_PREQ_LINES_TMP_T

select * from QP_PREQ_LINE_ATTRS_TMP_T

select * from QP_PREQ_LINE_ATTR_FORMUL_TMP_T

select * from QP_PREQ_QUAL_TMP_T

select * from QP_PREQ_RLTD_LINES_TMP_T

select * from QP_PRICE_BOOK_ATTRIBUTES

select * from QP_PRICE_BOOK_BREAK_LINES

select * from QP_PRICE_BOOK_HEADERS_ALL_B

select * from QP_PRICE_BOOK_HEADERS_TL

select * from QP_PRICE_BOOK_LINES

select * from QP_PRICE_BOOK_LINE_DETAILS

select * from QP_PRICE_BOOK_MESSAGES

select * from QP_PRICE_FORMULAS_B

select * from QP_PRICE_FORMULAS_TL

select * from QP_PRICE_FORMULA_LINES

select * from QP_PRICE_REQ_SOURCES

select * from QP_PRICING_ATTRIBUTES

select * from QP_PRICING_ATTRIBUTES_TEMP

select * from QP_PRICING_ATTRIBUTES_TMP

select * from QP_PRICING_ATT_EBS_LOG

select * from QP_PRICING_PHASES

select * from QP_PTE_REQUEST_TYPES_B

select * from QP_PTE_REQUEST_TYPES_TL

select * from QP_PTE_SEGMENTS

select * from QP_PTE_SOURCE_SYSTEMS

select * from QP_QUALIFIERS

select * from QP_QUALIFIERS_EBS_LOG

select * from QP_QUALIFIERS_FWK_DUMMY

select * from QP_QUALIFIERS_TEMP

select * from QP_QUALIFIER_RULES

select * from QP_RLTD_MODIFIERS

select * from QP_RLTD_MOD_EBS_LOG

select * from QP_SEGMENTS_B

select * from QP_SEGMENTS_TL

select * from QP_SOURCESYSTEM_FNAREA_MAP

select * from QP_UI_QUERIES_TL

select * from QP_UI_QUERY_COLUMNS

select * from QP_UPGRADE_ERRORS

select * from QP_UPG_LINES_DISTRIBUTION

No comments:

Post a Comment