[Home] [Help] [Dependency Information]
Object Name: | PSP_SELECTED_PERSONS_T |
---|---|
Object Type: | TABLE |
Owner: | PSP |
FND Design Data: | PSP.PSP_SELECTED_PERSONS_T |
Subobject Name: | |
Status: | VALID |
Contains list of person, assignments processed by a create effort report process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSP_SELECTED_PERSONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
PSP_SELECTED_PERSONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Request Id | ||
PERSON_ID | NUMBER | Person Id | ||
ASSIGNMENT_ID | NUMBER | Assignment Id | ||
SKIP_REASON | VARCHAR2 | (20) | Reason to skip |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, PERSON_ID
, ASSIGNMENT_ID
, SKIP_REASON
FROM PSP.PSP_SELECTED_PERSONS_T;
PSP.PSP_SELECTED_PERSONS_T does not reference any database object
PSP.PSP_SELECTED_PERSONS_T is referenced by following:
|
|
|