VIEW: APPS.EDWBV_HR_GRD_GRADES_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvgd.odf 115.5 2001/11/01 01:21:21 pkm ship       $ */ gra.grade_id || '-' || inst.instance_code grade_pk ,inst.instance_code instance ,gra.name || '(' || inst.instance_code || ')' name ,gra.name || '(' || inst.instance_code || ')' grade_dp ,'ALL' all_fk ,gra.date_from grade_date_from ,gra.date_to grade_date_to ,gra.sequence grade_sequence ,bgr.name business_group_name ,gra.grade_id grade_id ,bgr.organization_id business_group_id ,grd.grade_definition_id grade_definition_id ,'_DF:PER:PER_GRADES:gra' ,'_KF:PER:GRD:grd' ,greatest( NVL(gra.last_update_date,to_date('01-01-2000','DD-MM-YYYY')) ,NVL(bgr.last_update_date,to_date('01-01-2000','DD-MM-YYYY')) ,NVL(grd.last_update_date,to_date('01-01-2000','DD-MM-YYYY'))) last_update_date ,gra.creation_date creation_date FROM per_grades gra ,hr_all_organization_units bgr ,per_grade_definitions grd ,edw_local_instance inst WHERE gra.business_group_id = bgr.organization_id AND gra.grade_definition_id = grd.grade_definition_id

View Text - HTML Formatted

SELECT /* $HEADER: HRISVGD.ODF 115.5 2001/11/01 01:21:21 PKM SHIP $ */ GRA.GRADE_ID || '-' || INST.INSTANCE_CODE GRADE_PK
, INST.INSTANCE_CODE INSTANCE
, GRA.NAME || '(' || INST.INSTANCE_CODE || ')' NAME
, GRA.NAME || '(' || INST.INSTANCE_CODE || ')' GRADE_DP
, 'ALL' ALL_FK
, GRA.DATE_FROM GRADE_DATE_FROM
, GRA.DATE_TO GRADE_DATE_TO
, GRA.SEQUENCE GRADE_SEQUENCE
, BGR.NAME BUSINESS_GROUP_NAME
, GRA.GRADE_ID GRADE_ID
, BGR.ORGANIZATION_ID BUSINESS_GROUP_ID
, GRD.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
, '_DF:PER:PER_GRADES:GRA'
, '_KF:PER:GRD:GRD'
, GREATEST( NVL(GRA.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(BGR.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(GRD.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, GRA.CREATION_DATE CREATION_DATE
FROM PER_GRADES GRA
, HR_ALL_ORGANIZATION_UNITS BGR
, PER_GRADE_DEFINITIONS GRD
, EDW_LOCAL_INSTANCE INST
WHERE GRA.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND GRA.GRADE_DEFINITION_ID = GRD.GRADE_DEFINITION_ID