DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_LETTER_REQUESTS

Object Details
Object Name: PER_LETTER_REQUESTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_LETTER_REQUESTS_PK
  1. ColumnLETTER_REQUEST_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_LETTER_REQUESTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLETTER_REQUEST_ID
PER_LETTER_REQUESTS_FK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
ColumnREQUEST_STATUS
PER_LETTER_REQUESTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_LETTER_REQUESTS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLETTER_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_LETTER_REQUESTS PER_LETTER_REQUESTS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_LETTER_REQUESTS BUSINESS_GROUP_ID
PER_LETTER_REQUESTS PER_LETTER_REQUESTS_FK2 TablePER_LETTER_TYPES PER_LETTER_REQUESTS LETTER_TYPE_ID
TablePER_LETTER_REQUEST_LINES PER_LETTER_REQUEST_LINES_FK2 PER_LETTER_REQUESTS PER_LETTER_REQUEST_LINES LETTER_REQUEST_ID
Columns
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)
Vacancy Id
EVENT_ID NUMBER (15)
Event Id
Query Text

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;

Dependencies

[top of page]

HR.PER_LETTER_REQUESTS does not reference any database object

HR.PER_LETTER_REQUESTS is referenced by following:

SchemaHR
ViewPER_LETTER_REQUESTS#