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


TABLE: HR.HR_LEGISLATION_INSTALLATIONS

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


HR_LEGISLATION_INSTALLATIONS keeps a record of the various product/localisation combinations availabe for HRMS. This is used by the legislative post install/upgrade steps to determine what needs to be applied.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_LEG_INSTALLATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes application short name
LEGISLATION_CODE VARCHAR2 (2)
legislation code indicating which localisation can be installed for the product
STATUS VARCHAR2 (1)
indicated whether current product is installed
ACTION VARCHAR2 (1)
indicated what action is being performed on localisation (install/upgrade/force-reinstall)
PI_STEPS_EXIST VARCHAR2 (1) Yes indicates presence of legislative steps for this localisation
VIEW_NAME VARCHAR2 (250)
view used by driver to determine what steps to apply
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
Query Text

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


SELECT APPLICATION_SHORT_NAME
,      LEGISLATION_CODE
,      STATUS
,      ACTION
,      PI_STEPS_EXIST
,      VIEW_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_LEGISLATION_INSTALLATIONS;

Dependencies

[top of page]

HR.HR_LEGISLATION_INSTALLATIONS does not reference any database object

HR.HR_LEGISLATION_INSTALLATIONS is referenced by following:

SchemaHR
ViewHR_LEGISLATION_INSTALLATIONS#