[Home] [Help]
View: HRILV_ORGHVER_BGS_X
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ OSV.ORG_STRUCTURE_VERSION_ID ID
, OST.NAME||' : '||TO_CHAR(OSV.VERSION_NUMBER) VALUE
, OSV.DATE_FROM DATE_FROM
, NVL(OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO /*PARENT IDS*/
, OSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID /*OTHER IDS*/
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG
FROM PER_ORG_STRUCTURE_VERSIONS OSV
, PER_ORGANIZATION_STRUCTURES OST
WHERE OSV.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID
AND OSV.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, OSV.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |
PRIMARY_STRUCTURE_FLAG |