eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.EDWBV_HR_ASCH_ASG_CHNG_LCV

Source

View Text - Preformatted


SELECT /**************************************/ /* Select Dimension level Primary Key */ /* and other standard parameters */ /**************************************/ t1.lookup_code||'-'||t2.lookup_code||'-'||t3.lookup_code ||'-'||t4.lookup_code||'-'||t5.lookup_code||'-' ||t6.lookup_code||'-'||t7.lookup_code||'-'||instance_code asg_change_pk ,'ALL' all_fk ,t1.creation_date ,NVL(t1.last_update_date,to_date('01-01-2000','DD-MM-YYYY')) ,instance_code instance ,t1.lookup_code||'-'||t2.lookup_code||'-'||t3.lookup_code ||'-'||t4.lookup_code||'-'||t5.lookup_code||'-' ||t6.lookup_code||'-'||t7.lookup_code ||'('||instance_code||')' name ,t1.lookup_code||'-'||t2.lookup_code||'-'||t3.lookup_code ||'-'||t4.lookup_code||'-'||t5.lookup_code||'-' ||t6.lookup_code||'-'||t7.lookup_code ||'('||instance_code||')' asg_change_dp /**************************************/ /* Dimension Specific parameters */ /**************************************/ ,t1.lookup org_change_flag ,t2.lookup job_change_flag ,t3.lookup pos_change_flag ,t4.lookup grd_change_flag ,t5.lookup geog_change_flag ,t6.lookup other_change_flag ,t7.lookup change_status ,NULL asg_change_code FROM (SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code ,last_update_date ,creation_date FROM hr_lookups WHERE lookup_type = 'YES_NO') t1 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t2 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t3 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t4 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t5 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t6 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup ,lookup_code FROM hr_lookups WHERE lookup_type = 'YES_NO') t7 ,edw_local_instance inst

View Text - HTML Formatted

SELECT /**************************************/ /* SELECT DIMENSION LEVEL PRIMARY KEY */ /*
AND OTHER STANDARD PARAMETERS */ /**************************************/ T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE||'-'||INSTANCE_CODE ASG_CHANGE_PK
, 'ALL' ALL_FK
, T1.CREATION_DATE
, NVL(T1.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, INSTANCE_CODE INSTANCE
, T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE ||'('||INSTANCE_CODE||')' NAME
, T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE ||'('||INSTANCE_CODE||')' ASG_CHANGE_DP /**************************************/ /* DIMENSION SPECIFIC PARAMETERS */ /**************************************/
, T1.LOOKUP ORG_CHANGE_FLAG
, T2.LOOKUP JOB_CHANGE_FLAG
, T3.LOOKUP POS_CHANGE_FLAG
, T4.LOOKUP GRD_CHANGE_FLAG
, T5.LOOKUP GEOG_CHANGE_FLAG
, T6.LOOKUP OTHER_CHANGE_FLAG
, T7.LOOKUP CHANGE_STATUS
, NULL ASG_CHANGE_CODE
FROM (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
, LAST_UPDATE_DATE
, CREATION_DATE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T1
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T2
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T3
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T4
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T5
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T6
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T7
, EDW_LOCAL_INSTANCE INST