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

TABLE: HR.PER_GENERIC_REPORT_OUTPUT

Object Details
Object Name: PER_GENERIC_REPORT_OUTPUT
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_GENERIC_REPORT_OUTPUT
Subobject Name:
Status: VALID


PER_GENERIC_REPORT_OUTPUT holds the text lines produced by a generic
report script. This is part of a generic reporting functionality in
Oracle HRMS. The contents of this table are generated by a
user-defined PL/SQL script that also handles the formatting of the
text lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_GENERIC_REPORT_OUTPUT_PK
  1. ColumnLINE_TYPE
  2. ColumnLINE_NUMBER
Indexes
Index Type Uniqueness Tablespace Column
PER_GENERIC_REPORT_OUTPUT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_TYPE
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
LINE_TYPE VARCHAR2 (30) Yes Indicates whether line is in report title, header, footer or body.
LINE_NUMBER NUMBER (9) Yes Line number in title, header, footer or body.
LINE_CONTENT VARCHAR2 (200)
Free text content of report line.
Query Text

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


SELECT LINE_TYPE
,      LINE_NUMBER
,      LINE_CONTENT
FROM HR.PER_GENERIC_REPORT_OUTPUT;

Dependencies

[top of page]

HR.PER_GENERIC_REPORT_OUTPUT does not reference any database object

HR.PER_GENERIC_REPORT_OUTPUT is referenced by following:

SchemaAPPS
SynonymPER_GENERIC_REPORT_OUTPUT
SchemaPUBLIC
SynonymPER_GENERIC_REPORT_OUTPUT