eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: QP.QP_SEGMENTS_B

Object Details

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

This table stores all the attribute details for all types of attributes. This table is a child table of QP_PRC_CONTEXTS_B. The attributes stored are attached to one context in the QP_PRC_CONTEXTS_B table. An attribute must belong to one and only one context.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_SEGMENTS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEGMENT_ID
QP_SEGMENTS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEGMENT_CODE PRC_CONTEXT_ID
QP_SEGMENTS_B_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEGMENT_MAPPING_COLUMN PRC_CONTEXT_ID
QP_SEGMENTS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRC_CONTEXT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEGMENT_ID	NUMBER		Yes	System generated unique identifier
SEGMENT_CODE	VARCHAR2	(30)	Yes	User entered non-unique identifier code. The segment code is however unique for the context, it belongs to.
PRC_CONTEXT_ID	NUMBER		Yes	Foreign key reference to QP_PRC_CONTEXTS_B table
AVAILABILITY_IN_BASIC	VARCHAR2	(1)	Yes	Valid values are 'Y','N',and 'F'. 'Y' indicates the attribute is avalibale in Basic as well as Advanced Pricing. 'N' indicates the attribute is available in Advanced Pricing only. 'F' indicates the attribute is avaialble in Basic Pricing and is used in Freight and special charges.
SEGMENT_MAPPING_COLUMN	VARCHAR2	(30)	Yes	Indicates the attribute_code in AK_ATTRIBUTES on which this attribute is mapped to.
SEEDED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the attribute is a seeded attribute or not.
APPLICATION_ID	NUMBER		Yes	Indicates the Application that created this attribute.
SEEDED_PRECEDENCE	NUMBER			Indicates the precedence of the seeded 'Pricing context' attribute. For a 'Qualifier context' attribute, this column presently has no relevance.
USER_PRECEDENCE	NUMBER		Yes	Indicates the modified or user eneterd precedence for a seeded or user eneterd attribute respectively.
SEEDED_VALUESET_ID	NUMBER			The Valueset to which the seeded attribute was attached to. A seeded attribute may or may not be attached to a value set.
USER_VALUESET_ID	NUMBER			The changed Valueset or a newly entered valueset for a seeded attribute or a user created attribute respectively. Attributes whose valid values are key flexfields or have measured values entered at runtime will not have a valueset.
SEEDED_FORMAT_TYPE	VARCHAR2	(1)		The Format type of the SEEDED_VALUESET_ID column. The values are from FND_LOOKUP_VALUES for lookup_type 'FIELD_TYPE'.
USER_FORMAT_TYPE	VARCHAR2	(1)		The Format type of the USER_VALUESET_ID column. The values are from FND_LOOKUP_VALUES for lookup_type 'FIELD_TYPE'.
CONTEXT	VARCHAR2	(30)		Descriptive flexfield segment defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether a segment is required or not in the Attribute Management screen itself, instead of having to look at the corresponding flexfield information.
PARTY_HIERARCHY_ENABLED_FLAG	VARCHAR2	(1)		Indicates that the attribute is TCA Party Hierarchy -enabled.

Query Text

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


SELECT SEGMENT_ID
,      SEGMENT_CODE
,      PRC_CONTEXT_ID
,      AVAILABILITY_IN_BASIC
,      SEGMENT_MAPPING_COLUMN
,      SEEDED_FLAG
,      APPLICATION_ID
,      SEEDED_PRECEDENCE
,      USER_PRECEDENCE
,      SEEDED_VALUESET_ID
,      USER_VALUESET_ID
,      SEEDED_FORMAT_TYPE
,      USER_FORMAT_TYPE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUIRED_FLAG
,      PARTY_HIERARCHY_ENABLED_FLAG
FROM QP.QP_SEGMENTS_B;

Dependencies

[top of page]

QP.QP_SEGMENTS_B does not reference any database object

QP.QP_SEGMENTS_B is referenced by following:

APPS: QP_SEGMENTS_B