[Home] [Help] [Dependency Information]

TABLE: QP.QP_PREQ_LDETS_TMP_T1

Object Details

Object Name:	QP_PREQ_LDETS_TMP_T1
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_PREQ_LDETS_TMP_T1
Subobject Name:
Status:	VALID

Temporary Table Details

QP.QP_PREQ_LDETS_TMP_T1 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_PREQ_LDETS_TMP_N1	NORMAL	NONUNIQUE		REQUEST_ID LINE_INDEX PRICING_STATUS_CODE PRICING_PHASE_ID CREATED_FROM_LIST_HEADER_ID CREATED_FROM_LIST_LINE_ID
QP_PREQ_LDETS_TMP_N2	NORMAL	NONUNIQUE		REQUEST_ID PRICING_PHASE_ID PRICING_STATUS_CODE LINE_INDEX CREATED_FROM_LIST_LINE_TYPE
QP_PREQ_LDETS_TMP_N3	NORMAL	NONUNIQUE		REQUEST_ID LINE_INDEX PRICING_PHASE_ID ASK_FOR_FLAG CREATED_FROM_LIST_LINE_TYPE PRICING_STATUS_CODE
QP_PREQ_LDETS_TMP_N4	NORMAL	NONUNIQUE		REQUEST_ID PRICING_STATUS_CODE HEADER_LIMIT_EXISTS
QP_PREQ_LDETS_TMP_N5	NORMAL	NONUNIQUE		REQUEST_ID PROCESS_CODE CREATED_FROM_LIST_LINE_ID
QP_PREQ_LDETS_TMP_N7	NORMAL	NONUNIQUE		REQUEST_ID UPDATED_FLAG
QP_PREQ_LDETS_TMP_U1	NORMAL	NONUNIQUE		REQUEST_ID LINE_DETAIL_INDEX

Columns

Query Text

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_ATTRIBUTE
,      ACCUM_ATTR_RUN_SRC_FLAG
,      ACCUM_CONTEXT
,      BREAK_UOM_ATTRIBUTE
,      BREAK_UOM_CODE
,      BREAK_UOM_CONTEXT
,      SERVICE_DURATION
,      SERVICE_PERIOD
FROM QP.QP_PREQ_LDETS_TMP_T1;

Dependencies

[top of page]

QP.QP_PREQ_LDETS_TMP_T1 does not reference any database object

QP.QP_PREQ_LDETS_TMP_T1 is referenced by following:

APPS

QP_PREQ_LDETS_TMP_T1