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

TABLE: HR.FF_QP_REPORTS

Object Details
Object Name: FF_QP_REPORTS
Object Type: TABLE
Owner: HR
FND Design Data: TableFF.FF_QP_REPORTS
Subobject Name:
Status: VALID


FF_QP_REPORTS contains the text of any user defined QuickPaint
reports.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: FF_QP_REPORTS_PK
  1. ColumnQP_REPORT_ID
Unique Key: FF_QP_REPORTS_UK2
  1. ColumnQP_REPORT_NAME
  2. ColumnFORMULA_TYPE_ID
  3. ColumnBUSINESS_GROUP_ID
  4. ColumnLEGISLATION_CODE
Indexes
Index Type Uniqueness Tablespace Column
FF_QP_REPORTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQP_REPORT_ID
FF_QP_REPORTS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQP_REPORT_NAME
ColumnFORMULA_TYPE_ID
ColumnBUSINESS_GROUP_ID
ColumnLEGISLATION_CODE
SYS_IL0000034207C00014$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
FF_QP_REPORTS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORMULA_TYPE_ID
FF_QP_REPORTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORMULA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePER_QUICKPAINT_INVOCATIONS PER_QUICKPAINT_INVOCATIONS_FK1 FF_QP_REPORTS PER_QUICKPAINT_INVOCATIONS QP_REPORT_ID
Columns
Name Datatype Length Mandatory Comments
QP_REPORT_ID NUMBER (9) Yes Unique identifier for the report.
FORMULA_ID NUMBER (9) Yes Foreign key to FF_FORMULAS.
FORMULA_TYPE_ID NUMBER (9) Yes Foreign key to FF_FORMULA_TYPES.
QP_REPORT_NAME VARCHAR2 (80) Yes Name of the report.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
Foreign key to FND_TERRITORIES.
QP_ALTERED_FORMULA VARCHAR2 (1)
Indicates whether the user has altered the default formula generated for the report.
QP_DESCRIPTION VARCHAR2 (240)
Description of the report.
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.
QP_TEXT CLOB (4000)
Actual text of the report.
Query Text

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


SELECT QP_REPORT_ID
,      FORMULA_ID
,      FORMULA_TYPE_ID
,      QP_REPORT_NAME
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      QP_ALTERED_FORMULA
,      QP_DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      QP_TEXT
FROM HR.FF_QP_REPORTS;

Dependencies

[top of page]

HR.FF_QP_REPORTS does not reference any database object

HR.FF_QP_REPORTS is referenced by following:

SchemaHR
ViewFF_QP_REPORTS#