[Home] [Help] [Dependency Information]
Object Name: | PER_LETTER_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_LETTER_REQUESTS |
Subobject Name: | |
Status: | VALID |
PER_LETTER_REQUESTS holds details of requests for a specific type of
letter. A request can have one or more request lines for specific
people, held in PER_LETTER_REQUEST_LINES. When a request is
processed, it will produce a standard letter for each of the people
identified in the request lines. Requests are created automatically
as a result of a letter generation status change, or manually using
the Request Letter form. A status of PENDING indicates that a request
is open for new request lines to be added. When the request is
actually submitted the status is changed to REQUESTED, and then to
COMPLETED when the letter generation process is successfully
completed. For Release 10 character mode the letter generation
process is a concurrent program to output a mailmerge datafile. For
Release 10SC you can determine during implementation, whether the
process is a separate concurrent process, or an online mailmerge
process using a local wordprocessor and printer.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_LETTER_REQUESTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LETTER_REQUEST_ID |
PER_LETTER_REQUESTS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
PER_LETTER_REQUESTS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LETTER_TYPE_ID |
Table | |
Foreign Table | Foreign Key Column | PER_LETTER_REQUESTS | HR_ALL_ORGANIZATION_UNITS | PER_LETTER_REQUESTS BUSINESS_GROUP_ID | PER_LETTER_REQUESTS | PER_LETTER_TYPES | PER_LETTER_REQUESTS LETTER_TYPE_ID | PER_LETTER_REQUEST_LINES | PER_LETTER_REQUESTS | PER_LETTER_REQUEST_LINES LETTER_REQUEST_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LETTER_REQUEST_ID | NUMBER | (15) | Yes | System-generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
LETTER_TYPE_ID | NUMBER | (15) | Yes | Foreign key to PER_LETTER_TYPES. |
DATE_FROM | DATE | Yes | Date on which the letter request was created. | |
REQUEST_STATUS | VARCHAR2 | (30) | Yes | Letter request status: PENDING , REQUESTED or COMPLETED. |
AUTO_OR_MANUAL | VARCHAR2 | (30) | Indicates whether the request was created automatically by change of status, or manually by a user. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
REQUEST_ID | NUMBER | (15) | Standard Who column. | |
VACANCY_ID | NUMBER | (15) | Foreign key to PER_ALL_VACANCIES | |
EVENT_ID | NUMBER | (15) | Event Id |
Cut, paste (and edit) the following text to query this object:
SELECT LETTER_REQUEST_ID
, BUSINESS_GROUP_ID
, LETTER_TYPE_ID
, DATE_FROM
, REQUEST_STATUS
, AUTO_OR_MANUAL
, OBJECT_VERSION_NUMBER
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, VACANCY_ID
, EVENT_ID
FROM HR.PER_LETTER_REQUESTS;
HR.PER_LETTER_REQUESTS does not reference any database object
HR.PER_LETTER_REQUESTS is referenced by following:
|
|
|