[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_INT_LDETS_T# |
|---|---|
| Object Type: | VIEW |
| Owner: | QP |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_DETAIL_INDEX | NUMBER | Yes | ||
| LINE_DETAIL_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| LINE_DETAIL_PBH_TYPE | VARCHAR2 | (30) | ||
| 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) | Yes | |
| 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) | ||
| CALCULATION_CODE | VARCHAR2 | (30) | ||
| CURRENCY_HEADER_ID | NUMBER | |||
| PRICING_EFFECTIVE_DATE | DATE | |||
| BASE_CURRENCY_CODE | VARCHAR2 | (15) | ||
| ORDER_CURRENCY | VARCHAR2 | (15) | ||
| CURRENCY_DETAIL_ID | NUMBER | |||
| SELLING_ROUNDING_FACTOR | NUMBER | |||
| CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
| CHANGE_REASON_TEXT | VARCHAR2 | (2000) | ||
| PRICE_ADJUSTMENT_ID | NUMBER | |||
| REQUEST_ID | NUMBER | Yes | ||
| RECURRING_VALUE | NUMBER | |||
| NET_AMOUNT_FLAG | VARCHAR2 | (1) | ||
| ORDER_QTY_OPERAND | NUMBER | |||
| ORDER_QTY_ADJ_AMT | NUMBER | |||
| ACCUM_CONTEXT | VARCHAR2 | (30) | ||
| ACCUM_ATTRIBUTE | VARCHAR2 | (240) | ||
| ACCUM_ATTR_RUN_SRC_FLAG | VARCHAR2 | (1) | ||
| BREAK_UOM_CODE | VARCHAR2 | (3) | ||
| BREAK_UOM_CONTEXT | VARCHAR2 | (30) | ||
| BREAK_UOM_ATTRIBUTE | VARCHAR2 | (30) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| SERVICE_DURATION | NUMBER | |||
| SERVICE_PERIOD | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_DETAIL_INDEX
, LINE_DETAIL_TYPE_CODE
, LINE_DETAIL_PBH_TYPE
, 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
, CALCULATION_CODE
, CURRENCY_HEADER_ID
, PRICING_EFFECTIVE_DATE
, BASE_CURRENCY_CODE
, ORDER_CURRENCY
, CURRENCY_DETAIL_ID
, SELLING_ROUNDING_FACTOR
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, PRICE_ADJUSTMENT_ID
, REQUEST_ID
, RECURRING_VALUE
, NET_AMOUNT_FLAG
, ORDER_QTY_OPERAND
, ORDER_QTY_ADJ_AMT
, ACCUM_CONTEXT
, ACCUM_ATTRIBUTE
, ACCUM_ATTR_RUN_SRC_FLAG
, BREAK_UOM_CODE
, BREAK_UOM_CONTEXT
, BREAK_UOM_ATTRIBUTE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SERVICE_DURATION
, SERVICE_PERIOD
FROM QP.QP_INT_LDETS_T#;
QP
QP_INT_LDETS_T
APPS
QP_INT_LDETS_T
|
|
|
|