[Home] [Help] [Dependency Information]
Object Name: | HR_TRIGGER_STATUS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.HR_TRIGGER_STATUS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Trigger Owner | |
TRIGGER_NAME | VARCHAR2 | (128) | Trigger Name | |
TRIGGER_TYPE | VARCHAR2 | (16) | Trigger Type | |
TRIGGERING_EVENT | VARCHAR2 | (246) | Triggering Event | |
TABLE_OWNER | VARCHAR2 | (128) | Table Owner | |
BASE_OBJECT_TYPE | VARCHAR2 | (18) | Base Object Type | |
TABLE_NAME | VARCHAR2 | (128) | Table Name | |
COLUMN_NAME | VARCHAR2 | (4000) | Column Name | |
REFERENCING_NAMES | VARCHAR2 | (422) | Referencing Name | |
WHEN_CLAUSE | VARCHAR2 | (4000) | When clause | |
STATUS | VARCHAR2 | (8) | Status | |
DESCRIPTION | VARCHAR2 | (4000) | Description | |
ACTION_TYPE | VARCHAR2 | (11) | Action type | |
TRIGGER_BODY | LONG | (0) | Trigger Body |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TRIGGER_NAME
, TRIGGER_TYPE
, TRIGGERING_EVENT
, TABLE_OWNER
, BASE_OBJECT_TYPE
, TABLE_NAME
, COLUMN_NAME
, REFERENCING_NAMES
, WHEN_CLAUSE
, STATUS
, DESCRIPTION
, ACTION_TYPE
, TRIGGER_BODY
FROM APPS.HR_TRIGGER_STATUS_V;
|
|
|