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]

VIEW: APPS.OKX_RESOURCES_V

Object Details

Object Name:	OKX_RESOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_RESOURCES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ID1	NUMBER		Unique resource identifier
ID2	CHAR	(1)	(Multi-part) Primary Key
RESOURCE_NUMBER	VARCHAR2	(30)	Resource Number
RESOURCE_TYPE	VARCHAR2	(30)	Resource category. Allowed values: Employee, Partner, Party, Supplier Contact or Others (lookup type: RESOURCE_PEOPLE_CATEGORY
NAME	VARCHAR2	(360)	Concatenation of last name, title, first name, middle names and the name the person is known by.
DESCRIPTION	VARCHAR2	(100)	Formatted address, email or telephone number used to help describe resource
SOURCE_ID	NUMBER		Source identifier (foreign key to PER_ALL_PEOPLE_F) or(foreign key to HZ_PARTIES) or ( foreign key to PO_VENDOR_CONTACTS)
ADDRESS_ID	NUMBER		Address identifier (foreign key to HZ_PARTY_SITES)
CONTACT_ID	NUMBER		Contact identifier (foreign key to HZ_ORG_CONTACTS)
SUPPORT_SITE_ID	NUMBER		Support Site from Service
ORG_ID	NUMBER		Operating unit identifier
START_DATE_ACTIVE	DATE		Effective start date.
END_DATE_ACTIVE	DATE		Effective end date.
USER_ID	NUMBER		Application user identifier
B_STATUS	VARCHAR2	(1)	Original status flag
STATUS	VARCHAR2	(1)	Status
EMAIL_ADDRESS	VARCHAR2	(2000)

Query Text

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


SELECT ID1
,      ID2
,      RESOURCE_NUMBER
,      RESOURCE_TYPE
,      NAME
,      DESCRIPTION
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      SUPPORT_SITE_ID
,      ORG_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      USER_ID
,      B_STATUS
,      STATUS
,      EMAIL_ADDRESS
FROM APPS.OKX_RESOURCES_V;

Dependencies

[top of page]

APPS.OKX_RESOURCES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_USER; HZ_PARTIES; JTF_RS_RESOURCE_EXTNS; JTF_RS_SALESREPS_MO_V; PER_ALL_PEOPLE_F; PO_VENDOR_CONTACTS; PO_VENDOR_SITES

APPS.OKX_RESOURCES_V is referenced by following:

APPS: OKC_OCE_PVT - show dependent code; OKC_RENEW_PUB - show dependent code; OKC_RENEW_PVT - show dependent code; OKC_RESOURCE_USERS_V; OKC_TASK_ALERT_ESCL_PVT - show dependent code; OKS_COVERAGES_MIGRATION - show dependent code; OKS_ENTITLEMENTS_WEB - show dependent code