View: EDWBV_HR_RQVC_REQUISTN_LCV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.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