[Home] [Help] [Dependency Information]
Object Name: | QP_DEBUG_REQ_LDETS# |
---|---|
Object Type: | VIEW |
Owner: | QP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | ||
LINE_DETAIL_INDEX | NUMBER | Yes | ||
LINE_DETAIL_TYPE_CODE | VARCHAR2 | (30) | Yes | |
PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
LINE_INDEX | NUMBER | Yes | ||
CREATED_FROM_LIST_HEADER_ID | NUMBER | Yes | ||
CREATED_FROM_LIST_LINE_ID | NUMBER | Yes | ||
CREATED_FROM_LIST_LINE_TYPE | VARCHAR2 | (30) | Yes | |
CREATED_FROM_LIST_TYPE_CODE | VARCHAR2 | (30) | ||
MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | ||
CREATED_FROM_SQL | VARCHAR2 | (30) | ||
PRICING_GROUP_SEQUENCE | NUMBER | |||
OPERAND_CALCULATION_CODE | VARCHAR2 | (30) | ||
OPERAND_VALUE | NUMBER | |||
ADJUSTMENT_AMOUNT | NUMBER | |||
LINE_QUANTITY | NUMBER | |||
SUBSTITUTION_TYPE_CODE | VARCHAR2 | (30) | ||
SUBSTITUTION_VALUE_FROM | VARCHAR2 | (240) | ||
SUBSTITUTION_VALUE_TO | VARCHAR2 | (240) | ||
ASK_FOR_FLAG | VARCHAR2 | (1) | ||
PRICE_FORMULA_ID | NUMBER | |||
PROCESSED_FLAG | VARCHAR2 | (1) | ||
PRICING_STATUS_CODE | VARCHAR2 | (30) | ||
PRICING_STATUS_TEXT | VARCHAR2 | (2000) | ||
PRODUCT_PRECEDENCE | NUMBER | |||
INCOMPATABILITY_GRP_CODE | VARCHAR2 | (30) | ||
BEST_PERCENT | NUMBER | |||
PRICING_PHASE_ID | NUMBER | |||
APPLIED_FLAG | VARCHAR2 | (1) | ||
AUTOMATIC_FLAG | VARCHAR2 | (1) | ||
OVERRIDE_FLAG | VARCHAR2 | (1) | ||
PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | ||
PRIMARY_UOM_FLAG | VARCHAR2 | (1) | ||
BENEFIT_QTY | NUMBER | |||
BENEFIT_UOM_CODE | VARCHAR2 | (30) | ||
LIST_LINE_NO | VARCHAR2 | (240) | ||
ACCRUAL_FLAG | VARCHAR2 | (1) | ||
ACCRUAL_CONVERSION_RATE | NUMBER | |||
ESTIM_ACCRUAL_RATE | NUMBER | |||
RECURRING_FLAG | VARCHAR2 | (1) | ||
SELECTED_VOLUME_ATTR | VARCHAR2 | (1) | ||
ROUNDING_FACTOR | NUMBER | |||
SECONDARY_PRICELIST_IND | VARCHAR2 | (1) | ||
GROUP_QUANTITY | NUMBER | |||
GROUP_AMOUNT | NUMBER | |||
PROCESS_CODE | VARCHAR2 | (30) | ||
UPDATED_FLAG | VARCHAR2 | (1) | ||
CHARGE_TYPE_CODE | VARCHAR2 | (30) | ||
CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | ||
LIMIT_CODE | VARCHAR2 | (30) | ||
LIMIT_TEXT | VARCHAR2 | (2000) | ||
HEADER_LIMIT_EXISTS | VARCHAR2 | (1) | ||
LINE_LIMIT_EXISTS | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, LINE_DETAIL_INDEX
, LINE_DETAIL_TYPE_CODE
, PRICE_BREAK_TYPE_CODE
, LINE_INDEX
, CREATED_FROM_LIST_HEADER_ID
, CREATED_FROM_LIST_LINE_ID
, CREATED_FROM_LIST_LINE_TYPE
, CREATED_FROM_LIST_TYPE_CODE
, MODIFIER_LEVEL_CODE
, CREATED_FROM_SQL
, PRICING_GROUP_SEQUENCE
, OPERAND_CALCULATION_CODE
, OPERAND_VALUE
, ADJUSTMENT_AMOUNT
, LINE_QUANTITY
, SUBSTITUTION_TYPE_CODE
, SUBSTITUTION_VALUE_FROM
, SUBSTITUTION_VALUE_TO
, ASK_FOR_FLAG
, PRICE_FORMULA_ID
, PROCESSED_FLAG
, PRICING_STATUS_CODE
, PRICING_STATUS_TEXT
, PRODUCT_PRECEDENCE
, INCOMPATABILITY_GRP_CODE
, BEST_PERCENT
, PRICING_PHASE_ID
, APPLIED_FLAG
, AUTOMATIC_FLAG
, OVERRIDE_FLAG
, PRINT_ON_INVOICE_FLAG
, PRIMARY_UOM_FLAG
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, LIST_LINE_NO
, ACCRUAL_FLAG
, ACCRUAL_CONVERSION_RATE
, ESTIM_ACCRUAL_RATE
, RECURRING_FLAG
, SELECTED_VOLUME_ATTR
, ROUNDING_FACTOR
, SECONDARY_PRICELIST_IND
, GROUP_QUANTITY
, GROUP_AMOUNT
, PROCESS_CODE
, UPDATED_FLAG
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, LIMIT_CODE
, LIMIT_TEXT
, HEADER_LIMIT_EXISTS
, LINE_LIMIT_EXISTS
FROM QP.QP_DEBUG_REQ_LDETS#;
|
|
|