VIEW: APPS.PAY_ELE_CLASSIFICATION_RULES_V

Source

View Text - Preformatted

SELECT ECR.ROWID ROW_ID , ECR.ELEMENT_SET_ID , ECR.CLASSIFICATION_ID , ECR.LAST_UPDATE_DATE , ECR.LAST_UPDATED_BY , ECR.LAST_UPDATE_LOGIN , ECR.CREATED_BY , ECR.CREATION_DATE , ECLTL.CLASSIFICATION_NAME , HL.MEANING DEBIT_OR_CREDIT FROM PAY_ELE_CLASSIFICATION_RULES ECR, PAY_ELEMENT_CLASSIFICATIONS_TL ECLTL, PAY_ELEMENT_CLASSIFICATIONS ECL, HR_LOOKUPS HL WHERE ECL.CLASSIFICATION_ID = ECLTL.CLASSIFICATION_ID AND ECLTL.LANGUAGE = USERENV('LANG') AND ECL.CLASSIFICATION_ID = ECR.CLASSIFICATION_ID AND HL.LOOKUP_CODE (+) = ECL.COSTING_DEBIT_OR_CREDIT AND ((HL.LOOKUP_CODE IS NOT NULL AND HL.LOOKUP_TYPE = 'DEBIT_CREDIT') OR (HL.LOOKUP_CODE IS NULL))

View Text - HTML Formatted

SELECT ECR.ROWID ROW_ID
, ECR.ELEMENT_SET_ID
, ECR.CLASSIFICATION_ID
, ECR.LAST_UPDATE_DATE
, ECR.LAST_UPDATED_BY
, ECR.LAST_UPDATE_LOGIN
, ECR.CREATED_BY
, ECR.CREATION_DATE
, ECLTL.CLASSIFICATION_NAME
, HL.MEANING DEBIT_OR_CREDIT
FROM PAY_ELE_CLASSIFICATION_RULES ECR
, PAY_ELEMENT_CLASSIFICATIONS_TL ECLTL
, PAY_ELEMENT_CLASSIFICATIONS ECL
, HR_LOOKUPS HL
WHERE ECL.CLASSIFICATION_ID = ECLTL.CLASSIFICATION_ID
AND ECLTL.LANGUAGE = USERENV('LANG')
AND ECL.CLASSIFICATION_ID = ECR.CLASSIFICATION_ID
AND HL.LOOKUP_CODE (+) = ECL.COSTING_DEBIT_OR_CREDIT
AND ((HL.LOOKUP_CODE IS NOT NULL
AND HL.LOOKUP_TYPE = 'DEBIT_CREDIT') OR (HL.LOOKUP_CODE IS NULL))