[Home] [Help] [Dependency Information]
Object Name: | PQH_ROLE_EXTRA_INFO1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
LIFE_EVENT_TYPE | VARCHAR2 | (150) | ||
READ_OR_WRITE | VARCHAR2 | (150) | ||
OBJ_TYP | VARCHAR2 | (150) | ||
OBJ | VARCHAR2 | (150) | ||
TYPE | VARCHAR2 | (150) | ||
ESTABLISHMENT | VARCHAR2 | (150) | ||
CORPS | VARCHAR2 | (150) | ||
CATEGORY | VARCHAR2 | (150) | ||
FROM_GRADE | VARCHAR2 | (150) | ||
TO_GRADE | VARCHAR2 | (150) | ||
DATE_OF_ELECTION | DATE | |||
LENGTH_OF_MANDATE__DURATION | NUMBER | |||
LENGTH_OF_MANDATE__UNITS | VARCHAR2 | (150) | ||
START_DATE_OF_MANDATE | DATE | |||
END_DATE_OF_MANDATE | DATE | |||
TITULAIRE_FROM_CATEGORY_A | NUMBER | |||
DEPUTY_MEMBER_FROM_CATEGORY_A | NUMBER | |||
TITULAIRE_FROM_CATEGORY_B | NUMBER | |||
DEPUTY_MEMBER_FROM_CATEGORY_B | NUMBER | |||
TITULAIRE_FROM_CATEGORY_C | NUMBER | |||
DEPUTY_MEMBER_FROM_CATEGORY_C | NUMBER | |||
QUORUM | NUMBER | |||
CONVOCATION_DELAY | VARCHAR2 | (150) | ||
INDEMNITY_GRANTED_AMOUNT | NUMBER | |||
CURRENCY | VARCHAR2 | (150) | ||
DELEGATION_HOURS_PER_PERSON | NUMBER | |||
FREQUENCY | VARCHAR2 | (150) | ||
MEETINGS | VARCHAR2 | (150) | ||
PLACE | VARCHAR2 | (150) | ||
RULE_TYPE | VARCHAR2 | (150) | ||
POSITION_STATUTAIRE | VARCHAR2 | (150) | ||
LENGTH_OF_SERVICE | NUMBER | |||
UNITS | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1691) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, LIFE_EVENT_TYPE
, READ_OR_WRITE
, OBJ_TYP
, OBJ
, TYPE
, ESTABLISHMENT
, CORPS
, CATEGORY
, FROM_GRADE
, TO_GRADE
, DATE_OF_ELECTION
, LENGTH_OF_MANDATE__DURATION
, LENGTH_OF_MANDATE__UNITS
, START_DATE_OF_MANDATE
, END_DATE_OF_MANDATE
, TITULAIRE_FROM_CATEGORY_A
, DEPUTY_MEMBER_FROM_CATEGORY_A
, TITULAIRE_FROM_CATEGORY_B
, DEPUTY_MEMBER_FROM_CATEGORY_B
, TITULAIRE_FROM_CATEGORY_C
, DEPUTY_MEMBER_FROM_CATEGORY_C
, QUORUM
, CONVOCATION_DELAY
, INDEMNITY_GRANTED_AMOUNT
, CURRENCY
, DELEGATION_HOURS_PER_PERSON
, FREQUENCY
, MEETINGS
, PLACE
, RULE_TYPE
, POSITION_STATUTAIRE
, LENGTH_OF_SERVICE
, UNITS
, CONCATENATED_SEGMENTS
FROM APPS.PQH_ROLE_EXTRA_INFO1_DFV;
APPS.PQH_ROLE_EXTRA_INFO1_DFV is not referenced by any database object
|
|
|