[Home] [Help]
View: EDWBV_HR_RQVC_REQUISTN_LCV
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 |