eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.HR_LEGISLATION_SUB_INST

Object Details

Object Name:	HR_LEGISLATION_SUB_INST
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

Used to track sub installation within the legislation such as public sector

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
LEGISLATION_CODE	VARCHAR2	(2)	Legislation Code
DATAINSTALL_ITEM	VARCHAR2	(30)	Datainstall item Name
VIEW_NAME	VARCHAR2	(30)	Name of view used in install
SEQUENCE_ID	NUMBER		Sequence Id
PER_ALLOWED	VARCHAR2	(1)	Install of Product PER Allowed
STATUS	VARCHAR2	(1)	Status
ACTION	VARCHAR2	(1)	Action
PI_STEPS_EXIST	VARCHAR2	(1)	Whether PI steps Exist
CREATED_BY	NUMBER	(15)	Standare WHO column.
CREATION_DATE	DATE		Standare WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Standare WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standare WHO column.
LAST_UPDATE_DATE	DATE		Standare WHO column.

Query Text

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


SELECT LEGISLATION_CODE
,      DATAINSTALL_ITEM
,      VIEW_NAME
,      SEQUENCE_ID
,      PER_ALLOWED
,      STATUS
,      ACTION
,      PI_STEPS_EXIST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_LEGISLATION_SUB_INST;

Dependencies

[top of page]

HR.HR_LEGISLATION_SUB_INST does not reference any database object

HR.HR_LEGISLATION_SUB_INST is referenced by following:

APPS: HR_LEGISLATION_SUB_INST; HR_LEGISLATION_SUB_INST_WHO
PUBLIC: HR_LEGISLATION_SUB_INST