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

TABLE: HR.GHR_MASS_TRANSFER_CRITERIA

Object Details
Object Name: GHR_MASS_TRANSFER_CRITERIA
Object Type: TABLE
Owner: HR
FND Design Data: TableGHR.GHR_MASS_TRANSFER_CRITERIA
Subobject Name:
Status: VALID


GHR_MASS_TRANSFER_CRITERIA stores additional criteria for a
mass transfer action.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Primary Key: GHR_MASS_TRANSFER_CRITERIA_PK
  1. ColumnMASS_TRANSFER_CRITERIA_ID
Indexes
Index Type Uniqueness Tablespace Column
GHR_MASS_TRANSFER_CRITERIA_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_TRANSFER_CRITERIA_ID
GHR_MASS_TRANSFER_CRITERIA_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_TRANSFER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GHR_MASS_TRANSFER_CRITERIA GHR_MASS_TRANSFER_CRITERIA_FK1 TableGHR_MASS_TRANSFERS GHR_MASS_TRANSFER_CRITERIA MASS_TRANSFER_ID
Columns
Name Datatype Length Mandatory Comments
MASS_TRANSFER_CRITERIA_ID NUMBER (15) Yes Primary key generated from sequence GHR_MASS_TRANSFER_CRITERIA_S
MASS_TRANSFER_ID NUMBER (15) Yes Foriegn kry to GHR_MASS_TRANSFERS
OCC_CODE VARCHAR2 (30) Yes Occupational Code
LAST_UPDATE_DATE DATE
Yes Standard who column.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column.
CREATED_BY NUMBER (15)
Standard who column.
CREATION_DATE DATE
Yes Standard who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column.
Query Text

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


SELECT MASS_TRANSFER_CRITERIA_ID
,      MASS_TRANSFER_ID
,      OCC_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
FROM HR.GHR_MASS_TRANSFER_CRITERIA;

Dependencies

[top of page]

HR.GHR_MASS_TRANSFER_CRITERIA does not reference any database object

HR.GHR_MASS_TRANSFER_CRITERIA is referenced by following:

SchemaAPPS
SynonymGHR_MASS_TRANSFER_CRITERIA
TriggerGHR_MASS_TRANSFER_CRITERIA_WHO
SchemaPUBLIC
SynonymGHR_MASS_TRANSFER_CRITERIA