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: POS.POS_PRODUCT_SERVICE_REQUESTS

Object Details

Object Name:	POS_PRODUCT_SERVICE_REQUESTS
Object Type:	TABLE
Owner:	POS
Subobject Name:
Status:	VALID

POS_PRODUCT_SERVICE_REQUESTS stores information about supplier requests for adding new products and services.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POS_PRODUCT_SERVICE_REQ_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PS_REQUEST_ID
POS_PRODUCT_SERVICE_REQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MAPPING_ID
POS_PRODUCT_SERVICE_REQ_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_TYPE
POS_PRODUCT_SERVICE_REQ_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
PS_REQUEST_ID	NUMBER		Yes	Products&Services request identifier
MAPPING_ID	NUMBER		Yes	Identifier of the supplier mapping
REQUEST_STATUS	VARCHAR2	(30)	Yes	Status of the request
REQUEST_TYPE	VARCHAR2	(30)	Yes	Type of the request
SEGMENT1	VARCHAR2	(40)		Segment 1
SEGMENT2	VARCHAR2	(40)		Segment 2
SEGMENT3	VARCHAR2	(40)		Segment 3
SEGMENT4	VARCHAR2	(40)		Segment 4
SEGMENT5	VARCHAR2	(40)		Segment 5
SEGMENT6	VARCHAR2	(40)		Segment 6
SEGMENT7	VARCHAR2	(40)		Segment 7
SEGMENT8	VARCHAR2	(40)		Segment 8
SEGMENT9	VARCHAR2	(40)		Segment 9
SEGMENT10	VARCHAR2	(40)		Segment 10
SEGMENT11	VARCHAR2	(40)		Segment 11
SEGMENT12	VARCHAR2	(40)		Segment 12
SEGMENT13	VARCHAR2	(40)		Segment 13
SEGMENT14	VARCHAR2	(40)		Segment 14
SEGMENT15	VARCHAR2	(40)		Segment 15
SEGMENT16	VARCHAR2	(40)		Segment 16
SEGMENT17	VARCHAR2	(40)		Segment 17
SEGMENT18	VARCHAR2	(40)		Segment 18
SEGMENT19	VARCHAR2	(40)		Segment 19
SEGMENT20	VARCHAR2	(40)		Segment 20
SEGMENT_DEFINITION	VARCHAR2	(80)	Yes	Runtime Products&Service profile setting
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

Query Text

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


SELECT PS_REQUEST_ID
,      MAPPING_ID
,      REQUEST_STATUS
,      REQUEST_TYPE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT_DEFINITION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM POS.POS_PRODUCT_SERVICE_REQUESTS;

Dependencies

[top of page]

POS.POS_PRODUCT_SERVICE_REQUESTS does not reference any database object

POS.POS_PRODUCT_SERVICE_REQUESTS is referenced by following:

APPS: POS_PRODUCT_SERVICE_REQUESTS