[Home] [Help] [Dependency Information]

VIEW: APPS.QP_ARCH_MOD_SUMMARY_V

Object Details

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      LIST_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LATE_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_HEADER_ID
,      LIST_LINE_TYPE_CODE
,      AUTOMATIC_FLAG
,      MODIFIER_LEVEL_CODE
,      LIST_PRICE
,      LIST_PRICE_UOM_CODE
,      PRIMARY_UOM_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      SUBSTITUTION_CONTEXT
,      SUBSTITUTION_ATTR
,      SUBSTITUTION_VAL
,      REVISION
,      REVISION_DATE
,      REVISION_REASON_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      COMMENTS
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      INCLUDE_ON_RETURNS_FLAG
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICE_BREAK_TYPE_CODE
,      PERCENT_PRICE
,      EFFECTIVE_PERIOD_UOM
,      NUMBER_EFFECTIVE_PERIODS
,      OPERAND
,      ARITHMETIC_OPERATOR
,      OVERRIDE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      REBATE_TRANSACTION_TYPE_CODE
,      DB_ESTIM_ACCRUAL_RATE
,      PRICE_BY_FORMULA_ID
,      GENERATE_USING_FORMULA_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REPRICE_FLAG
,      DB_ACCRUAL_FLAG
,      PRICING_GROUP_SEQUENCE
,      INCOMPATIBILITY_GRP_CODE
,      LIST_LINE_NO
,      PRODUCT_PRECEDENCE
,      PRICING_PHASE_ID
,      DB_EXP_PERIOD_START_DATE
,      DB_NUMBER_EXPIRATION_PERIODS
,      DB_EXPIRATION_PERIOD_UOM
,      DB_EXPIRATION_DATE
,      ESTIM_GL_VALUE
,      DB_ACCRUAL_CONVERSION_RATE
,      BENEFIT_PRICE_LIST_LINE_ID
,      PRORATION_TYPE_CODE
,      DB_BENEFIT_QTY
,      DB_BENEFIT_UOM_CODE
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      BENEFIT_LIMIT
,      PRICING_ATTRIBUTE_ID
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTR
,      PRODUCT_ATTR_VAL
,      PRODUCT_UOM_CODE
,      COMPARISON_OPERATOR_CODE
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTR
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      PRICING_ATTRIBUTE_DATATYPE
,      PRODUCT_ATTRIBUTE_DATATYPE
,      EXCLUDER_FLAG
,      ATTRIBUTE_GROUPING_NO
,      PARENT_LIST_LINE_ID
,      TO_RLTD_MODIFIER_ID
,      RLTD_MODIFIER_GRP_NO
,      RLTD_MODIFIER_GRP_TYPE
,      RLTD_MODIFIER_ID
,      PRORATION_TYPE
,      PRICING_PHASE
,      INCOMPATIBILITY_GRP
,      MODIFIER_LEVEL
,      LIST_LINE_TYPE
,      PRICE_BREAK_TYPE
,      CHARGE_NAME
,      FORMULA
,      ARITHMETIC_OPERATOR_TYPE
,      EXPIRATION_DATE
,      EXPIRATION_PERIOD_START_DATE
,      NUMBER_EXPIRATION_PERIODS
,      EXPIRATION_PERIOD_UOM
,      COUP_EXPIRATION_DATE
,      COUP_EXP_PERIOD_START_DATE
,      COUP_NUMBER_EXPIRATION_PERIODS
,      COUP_EXPIRATION_PERIOD_UOM
,      BRK_EXPIRATION_DATE
,      BRK_EXPIRATION_PERIOD_START_DA
,      BRK_NUMBER_EXPIRATION_PERIODS
,      BRK_EXPIRATION_PERIOD_UOM
,      REBATE_TRANSACTION_TYPE
,      BRK_REB_TRANSACTION_TYPE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      COUP_BENEFIT_QTY
,      COUP_BENEFIT_UOM_CODE
,      COUP_LIST_LINE_NO
,      ACCRUAL_FLAG
,      BRK_ACCRUAL_FLAG
,      ACCRUAL_CONVERSION_RATE
,      COUP_ACCRUAL_CONVERSION_RATE
,      COUP_ESTIM_ACCRUAL_RATE
,      BRK_ACCRUAL_CONVERSION_RATE
,      ESTIM_ACCRUAL_RATE
,      BRK_ESTIM_ACCRUAL_RATE
,      BREAK_LINE_TYPE_CODE
,      BREAK_LINE_TYPE
,      PRODUCT_ID
,      DESCRIPTION
,      PRICING_ATTR_SEG_NAME
,      PROD_ATTR_SEGMENT_NAME
,      RELATED_ITEM
,      SUBSTITUTION_ATTRIBUTE
,      SUBSTITUTION_VALUE
,      SUB_SEGMENT_NAME
,      PRODUCT_ATTRIBUTE_TYPE
,      PRODUCT_ATTR_VALUE
,      PRICING_ATTRIBUTE
,      NET_AMOUNT_FLAG
,      ACCUM_ATTRIBUTE
,      ARCH_PURG_REQUEST_ID
,      CONTINUOUS_PRICE_BREAK_FLAG
FROM APPS.QP_ARCH_MOD_SUMMARY_V;

Dependencies

[top of page]

APPS

QP_ARCH_LIST_LINES

QP_ARCH_PRICING_ATTRIBUTES

QP_PRICE_LIST_LINE_UTIL - show dependent code

QP_QP_FORM_PRICING_ATTR - show dependent code

APPS.QP_ARCH_MOD_SUMMARY_V is not referenced by any database object