VIEW: APPS.EDWBV_HR_RQVC_REQUISTN_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvvc.odf 115.5 2001/11/01 01:21:25 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

View Text - HTML Formatted

SELECT /* $HEADER: HRISVVC.ODF 115.5 2001/11/01 01:21:25 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