[Home] [Help] [Dependency Information]
Object Name: | QP_NPREQ_PATRN_PHASES_T |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_NPREQ_PATRN_PHASES_T |
Subobject Name: | |
Status: | VALID |
QP.QP_NPREQ_PATRN_PHASES_T 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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_NPREQ_PATRN_PHASES_TMP_N1 | NORMAL | NONUNIQUE |
REQUEST_ID
PRICING_PHASE_ID SEGMENT_INDEX PATTERN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PATTERN_ID | NUMBER | |||
SEGMENT_ID | NUMBER | |||
PRICING_PHASE_ID | NUMBER | |||
SEGMENT_INDEX | NUMBER | |||
SEGMENT_COUNT | NUMBER | |||
REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PATTERN_ID
, SEGMENT_ID
, PRICING_PHASE_ID
, SEGMENT_INDEX
, SEGMENT_COUNT
, REQUEST_ID
FROM QP.QP_NPREQ_PATRN_PHASES_T;
QP.QP_NPREQ_PATRN_PHASES_T does not reference any database object
QP.QP_NPREQ_PATRN_PHASES_T is referenced by following:
|
|
|