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.PAY_ELEMENT_TYPE_RULES_V

Source

View Text - Preformatted


SELECT ETR.ROWID ROW_ID , ETR.ELEMENT_TYPE_ID , ETR.ELEMENT_SET_ID , ETR.INCLUDE_OR_EXCLUDE , ETR.LAST_UPDATE_DATE , ETR.LAST_UPDATED_BY , ETR.LAST_UPDATE_LOGIN , ETR.CREATED_BY , ETR.CREATION_DATE , ETTL.ELEMENT_NAME , HL2.MEANING PROCESSING_TYPE , ECTL.CLASSIFICATION_NAME , HL.MEANING INCLUDE_OR_EXCLUDE_MEANING FROM PAY_ELEMENT_TYPE_RULES ETR, PAY_ELEMENT_TYPES_F_TL ETTL, PAY_ELEMENT_TYPES_F ET, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL, PAY_ELEMENT_CLASSIFICATIONS EC, FND_SESSIONS SES, HR_LOOKUPS HL, HR_LOOKUPS HL2 WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID AND ETTL.LANGUAGE = USERENV('LANG') AND EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID AND ECTL.LANGUAGE = USERENV('LANG') AND ET.ELEMENT_TYPE_ID = ETR.ELEMENT_TYPE_ID AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID AND HL.LOOKUP_TYPE = 'INCLUDE_EXCLUDE' AND HL.LOOKUP_CODE = ETR.INCLUDE_OR_EXCLUDE AND HL2.LOOKUP_TYPE = 'PROCESSING_TYPE' AND HL2.LOOKUP_CODE = ET.PROCESSING_TYPE AND SES.SESSION_ID = USERENV('sessionid') AND SES.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ETR.ROWID ROW_ID
, ETR.ELEMENT_TYPE_ID
, ETR.ELEMENT_SET_ID
, ETR.INCLUDE_OR_EXCLUDE
, ETR.LAST_UPDATE_DATE
, ETR.LAST_UPDATED_BY
, ETR.LAST_UPDATE_LOGIN
, ETR.CREATED_BY
, ETR.CREATION_DATE
, ETTL.ELEMENT_NAME
, HL2.MEANING PROCESSING_TYPE
, ECTL.CLASSIFICATION_NAME
, HL.MEANING INCLUDE_OR_EXCLUDE_MEANING
FROM PAY_ELEMENT_TYPE_RULES ETR
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
, FND_SESSIONS SES
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND ET.ELEMENT_TYPE_ID = ETR.ELEMENT_TYPE_ID
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND HL.LOOKUP_TYPE = 'INCLUDE_EXCLUDE'
AND HL.LOOKUP_CODE = ETR.INCLUDE_OR_EXCLUDE
AND HL2.LOOKUP_TYPE = 'PROCESSING_TYPE'
AND HL2.LOOKUP_CODE = ET.PROCESSING_TYPE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE