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.

VIEW: APPS.PER_SHARED_TYPES_DFV

Source

View Text - Preformatted


SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'ABSENCE_CATEGORY', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'NATIONALITY', INFORMATION5, 'AE_NATIONALITY', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'CONTACT', INFORMATION3, NULL)), (DECODE (INFORMATION_CATEGORY, 'CONTRACT_STATUS', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'EMPLOYEE_CATG', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'LEAV_REAS', INFORMATION1, 'ES', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'NL_NATIONALITY', INFORMATION1, 'HU_NATIONALITY', INFORMATION1, 'ES_NATIONALITY', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'FI_TRANSFER_OPTIONS', INFORMATION1, 'FI_TERMINATION_OPTIONS', INFORMATION1, 'FI_PAYMENT_OPTIONS', INFORMATION1, 'FI_ENTITLEMENT_OPTIONS', INFORMATION1, 'FI_ACCRUAL_OPTIONS', INFORMATION1, 'FI_ABSENCE_PAYMENT_OPTIONS', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'FI_TERMINATION_OPTIONS', INFORMATION2, 'FI_PAYMENT_OPTIONS', INFORMATION2, 'FI_ABSENCE_PAYMENT_OPTIONS', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'FI_WORKINGTIME_OPTIONS', INFORMATION2, 'FI_TRANSFER_OPTIONS', INFORMATION2, 'FI_ENTITLEMENT_OPTIONS', INFORMATION2, 'FI_ACCRUAL_OPTIONS', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'FI_WORKINGTIME_OPTIONS', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'FREQUENCY', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_ENTITLEMENT_SETUP', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_ORG_CATEGORY', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_PHYSICAL_SHARE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)), (DECODE (INFORMATION_CATEGORY, 'HIERARCHY_TYPE', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'HIERARCHY_TYPE', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'HIERARCHY_TYPE', INFORMATION3, NULL)), (DECODE (INFORMATION_CATEGORY, 'HIERARCHY_TYPE', INFORMATION4, NULL)), (DECODE (INFORMATION_CATEGORY, 'NATIONALITY', INFORMATION3, NULL)), (DECODE (INFORMATION_CATEGORY, 'NATIONALITY', INFORMATION4, NULL)), (DECODE (INFORMATION_CATEGORY, 'NL_EMPLOYEE_CATG', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'NL_EMPLOYMENT_CATG', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'READINESS_LEVEL', INFORMATION1, 'PER_SUCC_PLAN_RISK_LEVEL', INFORMATION1, 'PER_SUCC_PLAN_POTENTIAL', INFORMATION1, 'PER_SP_IMPACT_OF_LOSS', INFORMATION1, 'PER_RETENTION_POTENTIAL', INFORMATION1, 'PERFORMANCE_RATING', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'POSITION_AVAILABILITY_STATUS', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'PQH_CORPS_FILERES', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'QUALIFYING_UNITS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)), (DECODE (INFORMATION_CATEGORY, 'RU_EDUCATION_LEVELS', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'RU_ENTERPRISE_EDUCATION', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'RU_MARITAL_STATUS', INFORMATION1, NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'ABSENCE_CATEGORY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'AE_NATIONALITY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'CONTACT', INFORMATION_CATEGORY || '.' || INFORMATION3,  
      'CONTRACT_STATUS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'EMPLOYEE_CATG', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'ES', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'ES_NATIONALITY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'FI_ABSENCE_PAYMENT_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_ACCRUAL_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_ENTITLEMENT_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_PAYMENT_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_TERMINATION_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_TRANSFER_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FI_WORKINGTIME_OPTIONS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'FREQUENCY', INFORMATION_CATEGORY || '.' || INFORMATION3,  
      'FR_PQH_ENTITLEMENT_SETUP', INFORMATION_CATEGORY || '.' || INFORMATION2,  
      'FR_PQH_ORG_CATEGORY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'FR_PQH_PHYSICAL_SHARE', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'HIERARCHY_TYPE', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4,  
      'HU_NATIONALITY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'LEAV_REAS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'NATIONALITY', INFORMATION_CATEGORY || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5,  
      'NL_EMPLOYEE_CATG', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'NL_EMPLOYMENT_CATG', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'NL_NATIONALITY', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PERFORMANCE_RATING', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PER_RETENTION_POTENTIAL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PER_SP_IMPACT_OF_LOSS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PER_SUCC_PLAN_POTENTIAL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PER_SUCC_PLAN_RISK_LEVEL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'POSITION_AVAILABILITY_STATUS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PQH_CORPS_FILERES', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'QUALIFYING_UNITS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'READINESS_LEVEL', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'RU_EDUCATION_LEVELS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'RU_ENTERPRISE_EDUCATION', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'RU_MARITAL_STATUS', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL)) 
 FROM PER_SHARED_TYPES

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'ABSENCE_CATEGORY'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NATIONALITY'
, INFORMATION5
, 'AE_NATIONALITY'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CONTACT'
, INFORMATION3
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CONTRACT_STATUS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'EMPLOYEE_CATG'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'LEAV_REAS'
, INFORMATION1
, 'ES'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NL_NATIONALITY'
, INFORMATION1
, 'HU_NATIONALITY'
, INFORMATION1
, 'ES_NATIONALITY'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FI_TRANSFER_OPTIONS'
, INFORMATION1
, 'FI_TERMINATION_OPTIONS'
, INFORMATION1
, 'FI_PAYMENT_OPTIONS'
, INFORMATION1
, 'FI_ENTITLEMENT_OPTIONS'
, INFORMATION1
, 'FI_ACCRUAL_OPTIONS'
, INFORMATION1
, 'FI_ABSENCE_PAYMENT_OPTIONS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FI_TERMINATION_OPTIONS'
, INFORMATION2
, 'FI_PAYMENT_OPTIONS'
, INFORMATION2
, 'FI_ABSENCE_PAYMENT_OPTIONS'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FI_WORKINGTIME_OPTIONS'
, INFORMATION2
, 'FI_TRANSFER_OPTIONS'
, INFORMATION2
, 'FI_ENTITLEMENT_OPTIONS'
, INFORMATION2
, 'FI_ACCRUAL_OPTIONS'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FI_WORKINGTIME_OPTIONS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FREQUENCY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_ENTITLEMENT_SETUP'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_ORG_CATEGORY'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_PHYSICAL_SHARE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'HIERARCHY_TYPE'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'HIERARCHY_TYPE'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'HIERARCHY_TYPE'
, INFORMATION3
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'HIERARCHY_TYPE'
, INFORMATION4
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NATIONALITY'
, INFORMATION3
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NATIONALITY'
, INFORMATION4
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NL_EMPLOYEE_CATG'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'NL_EMPLOYMENT_CATG'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'READINESS_LEVEL'
, INFORMATION1
, 'PER_SUCC_PLAN_RISK_LEVEL'
, INFORMATION1
, 'PER_SUCC_PLAN_POTENTIAL'
, INFORMATION1
, 'PER_SP_IMPACT_OF_LOSS'
, INFORMATION1
, 'PER_RETENTION_POTENTIAL'
, INFORMATION1
, 'PERFORMANCE_RATING'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'POSITION_AVAILABILITY_STATUS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'PQH_CORPS_FILERES'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'QUALIFYING_UNITS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'RU_EDUCATION_LEVELS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'RU_ENTERPRISE_EDUCATION'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'RU_MARITAL_STATUS'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'ABSENCE_CATEGORY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'AE_NATIONALITY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'CONTACT'
, INFORMATION_CATEGORY || '.' || INFORMATION3
, 'CONTRACT_STATUS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'EMPLOYEE_CATG'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'ES'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'ES_NATIONALITY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'FI_ABSENCE_PAYMENT_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_ACCRUAL_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_ENTITLEMENT_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_PAYMENT_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_TERMINATION_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_TRANSFER_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FI_WORKINGTIME_OPTIONS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'FREQUENCY'
, INFORMATION_CATEGORY || '.' || INFORMATION3
, 'FR_PQH_ENTITLEMENT_SETUP'
, INFORMATION_CATEGORY || '.' || INFORMATION2
, 'FR_PQH_ORG_CATEGORY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'FR_PQH_PHYSICAL_SHARE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'HIERARCHY_TYPE'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4
, 'HU_NATIONALITY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'LEAV_REAS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'NATIONALITY'
, INFORMATION_CATEGORY || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5
, 'NL_EMPLOYEE_CATG'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'NL_EMPLOYMENT_CATG'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'NL_NATIONALITY'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PERFORMANCE_RATING'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PER_RETENTION_POTENTIAL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PER_SP_IMPACT_OF_LOSS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PER_SUCC_PLAN_POTENTIAL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PER_SUCC_PLAN_RISK_LEVEL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'POSITION_AVAILABILITY_STATUS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PQH_CORPS_FILERES'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'QUALIFYING_UNITS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'READINESS_LEVEL'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'RU_EDUCATION_LEVELS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'RU_ENTERPRISE_EDUCATION'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'RU_MARITAL_STATUS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PER_SHARED_TYPES