[Home] [Help] [Dependency Information]
Object Name: | HRI_CL_ORG_HRCYVRSN_N_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
List of values for Organization Hierarchy Structure Version with Security Flags.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
VALUE | VARCHAR2 | (73) | ||
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
ORGANIZATION_HIERARCHY_NAME | VARCHAR2 | (30) | Yes | |
VERSION_NUMBER | NUMBER | Yes | ||
RESPONSIBILITY_ID | NUMBER | |||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
PRIMARY_STRUCTURE_FLAG_CODE | VARCHAR2 | (30) | ||
BG_SECURITY_FLAG_CODE | CHAR | (1) | ||
HRI_SECURITY_FLAG_CODE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, START_DATE
, END_DATE
, ORGANIZATION_HIERARCHY_NAME
, VERSION_NUMBER
, RESPONSIBILITY_ID
, BUSINESS_GROUP_ID
, PRIMARY_STRUCTURE_FLAG_CODE
, BG_SECURITY_FLAG_CODE
, HRI_SECURITY_FLAG_CODE
FROM APPS.HRI_CL_ORG_HRCYVRSN_N_V;
APPS.HRI_CL_ORG_HRCYVRSN_N_V is not referenced by any database object
|
|
|