[Home] [Help]
View: EDWBV_HR_RQVC_REQUISTN_LCV
| 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 $ */ REQ.REQUISITION_ID || '-' || INST.INSTANCE_CODE REQUISITION_PK
, 'ALL' ALL_FK
, INST.INSTANCE_CODE INSTANCE
, REQ.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' NAME
, REQ.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' REQUISITION_DP
, REQ.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, REQ.REQUISITION_ID REQUISITION_ID
, REQ.DATE_FROM START_DATE
, REQ.DATE_TO END_DATE
, '_DF:PER:PER_REQUISITIONS:REQ'
, REQ.CREATION_DATE CREATION_DATE
, NVL(REQ.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
FROM EDW_LOCAL_INSTANCE INST
, HR_ALL_ORGANIZATION_UNITS BGR
, PER_REQUISITIONS REQ
WHERE BGR.ORGANIZATION_ID = REQ.BUSINESS_GROUP_ID
Columns
| Name |
| REQUISITION_PK |
| ALL_FK |
| INSTANCE |
| NAME |
| REQUISITION_DP |
| BUSINESS_GROUP_ID |
| REQUISITION_ID |
| START_DATE |
| END_DATE |
| "_DF:RQSTN_DETAILS:_EDW" |
| CREATION_DATE |
| LAST_UPDATE_DATE |