[Home] [Help] [Dependency Information]
Object Name: | OKX_RESOURCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_RESOURCES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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) |
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;
|
|
|