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

TABLE: HR.PER_MM_JOB_REQUIREMENTS

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


PER_MM_JOB_REQUIREMENTS holds data related to transferring position
requirements to a newly created position.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_MM_JOB_REQUIREMENTS_PK
  1. ColumnMASS_MOVE_ID
  2. ColumnANALYSIS_CRITERIA_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_MM_JOB_REQUIREMENTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMASS_MOVE_ID
ColumnANALYSIS_CRITERIA_ID
PER_MM_JOB_REQUIREMENTS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNEW_ANALYSIS_CRITERIA_ID
PER_MM_JOB_REQUIREMENTS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_CRITERIA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK2 TablePER_ANALYSIS_CRITERIA PER_MM_JOB_REQUIREMENTS NEW_ANALYSIS_CRITERIA_ID
PER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK3 TablePER_ANALYSIS_CRITERIA PER_MM_JOB_REQUIREMENTS ANALYSIS_CRITERIA_ID
PER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK1 TablePER_MASS_MOVES PER_MM_JOB_REQUIREMENTS MASS_MOVE_ID
Columns
Name Datatype Length Mandatory Comments
MASS_MOVE_ID NUMBER (15) Yes Foreign key to PER_MASS_MOVES.
ANALYSIS_CRITERIA_ID NUMBER (15) Yes Foreignkey to PER_ANALYSIS_CRITERIA of the source job requirement.
DELETE_FLAG VARCHAR2 (1) Yes Flag indicating that the source job requirement will be end dated.
NEW_ANALYSIS_CRITERIA_ID NUMBER (15)
Foreign key to PER_ANALYSIS_CRITERIA of the desired target job requirement.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment 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.
Query Text

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


SELECT MASS_MOVE_ID
,      ANALYSIS_CRITERIA_ID
,      DELETE_FLAG
,      NEW_ANALYSIS_CRITERIA_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_MM_JOB_REQUIREMENTS;

Dependencies

[top of page]

HR.PER_MM_JOB_REQUIREMENTS does not reference any database object

HR.PER_MM_JOB_REQUIREMENTS is referenced by following:

SchemaHR
ViewPER_MM_JOB_REQUIREMENTS#