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: PV.PV_PARTNER_ACCESSES

Object Details

Object Name:	PV_PARTNER_ACCESSES
Object Type:	TABLE
Owner:	PV
FND Design Data:	PV.PV_PARTNER_ACCESSES
Subobject Name:
Status:	VALID

PV_PARTNER_ACCESSES stores information that indicates whether an employee
can access a partner information.
.
Each record in PV_PARTNER_ACCESSES includes values that identify an
employee for which the access applies and the partner to which access is
granted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_PARTNER_ACCESSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTNER_ACCESS_ID
PV_PARTNER_ACCESSES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTNER_ID RESOURCE_ID
PV_PARTNER_ACCESSES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_ID PARTNER_ID
PV_PARTNER_ACCESSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAD_PARTNER_ID PARTNER_ID
PV_PARTNER_ACCESSES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARTNER_ACCESS_ID	NUMBER		Yes	Partner Access Id
PARTNER_ID	NUMBER		Yes	Relationship Id between the Partner and the Vendor Org
RESOURCE_ID	NUMBER		Yes	Individual resource Id
KEEP_FLAG	VARCHAR2	(1)	Yes	Flag to be 'ON' if the resource is created manually, else it should be 'OFF'.
CREATED_BY_TAP_FLAG	VARCHAR2	(1)	Yes	Flag should be 'ON' if the individual resource is attached online during partner creation, else it should be 'OFF'.
ACCESS_TYPE	VARCHAR2	(1)	Yes	If it is ON then it means resource has FULL access, otherwise none.
VAD_PARTNER_ID	NUMBER			Party Id of the VAD organization.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Program Application Id
PROGRAM_ID	NUMBER			Program Id
PROGRAM_UPDATE_DATE	DATE			Program Update Date
SECURITY_GROUP_ID	NUMBER			Security Group Id
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column

Query Text

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


SELECT PARTNER_ACCESS_ID
,      PARTNER_ID
,      RESOURCE_ID
,      KEEP_FLAG
,      CREATED_BY_TAP_FLAG
,      ACCESS_TYPE
,      VAD_PARTNER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM PV.PV_PARTNER_ACCESSES;

Dependencies

[top of page]

PV.PV_PARTNER_ACCESSES does not reference any database object

PV.PV_PARTNER_ACCESSES is referenced by following:

PV: PV_PARTNER_ACCESSES#