VIEW: APPS.PAY_RATES_V

Source

View Text - Preformatted

SELECT PR.ROWID ROW_ID , PR.RATE_ID , PPS.NAME PARENT_NAME , HR_U.MEANING UNIT_MEANING , PR.BUSINESS_GROUP_ID , PR.PARENT_SPINE_ID , PR.NAME , PR.RATE_TYPE , PR.RATE_UOM , PR.COMMENTS , PR.REQUEST_ID , PR.PROGRAM_APPLICATION_ID , PR.PROGRAM_ID , PR.PROGRAM_UPDATE_DATE , PR.ATTRIBUTE_CATEGORY , PR.ATTRIBUTE1 , PR.ATTRIBUTE2 , PR.ATTRIBUTE3 , PR.ATTRIBUTE4 , PR.ATTRIBUTE5 , PR.ATTRIBUTE6 , PR.ATTRIBUTE7 , PR.ATTRIBUTE8 , PR.ATTRIBUTE9 , PR.ATTRIBUTE10 , PR.ATTRIBUTE11 , PR.ATTRIBUTE12 , PR.ATTRIBUTE13 , PR.ATTRIBUTE14 , PR.ATTRIBUTE15 , PR.ATTRIBUTE16 , PR.ATTRIBUTE17 , PR.ATTRIBUTE18 , PR.ATTRIBUTE19 , PR.ATTRIBUTE20 , PR.LAST_UPDATE_DATE , PR.LAST_UPDATED_BY , PR.LAST_UPDATE_LOGIN , PR.CREATED_BY , PR.CREATION_DATE , PR.RATE_BASIS , HR_R.MEANING RATE_BASIS_MEANING ,SUBSTR(HR_GENERAL.DECODE_LOOKUP('RATE_TYPE',RATE_TYPE),1,80) RATE_TYPE_MEANING ,PR.OBJECT_VERSION_NUMBER ,PR.ASG_RATE_TYPE ,FND_ART.MEANING ASG_RATE_TYPE_NAME FROM PAY_RATES PR, PER_PARENT_SPINES PPS, HR_LOOKUPS HR_U, HR_LOOKUPS HR_R, FND_LOOKUPS FND_ART WHERE PR.PARENT_SPINE_ID = PPS.PARENT_SPINE_ID (+) AND PR.RATE_UOM = HR_U.LOOKUP_CODE AND HR_U.LOOKUP_TYPE = 'UNITS' AND HR_R.LOOKUP_TYPE (+) = 'RATE_BASIS' AND HR_R.LOOKUP_CODE (+) = PR.RATE_BASIS AND FND_ART.LOOKUP_TYPE (+) = 'PRICE DIFFERENTIALS' AND FND_ART.LOOKUP_CODE (+) = PR.ASG_RATE_TYPE

View Text - HTML Formatted

SELECT PR.ROWID ROW_ID
, PR.RATE_ID
, PPS.NAME PARENT_NAME
, HR_U.MEANING UNIT_MEANING
, PR.BUSINESS_GROUP_ID
, PR.PARENT_SPINE_ID
, PR.NAME
, PR.RATE_TYPE
, PR.RATE_UOM
, PR.COMMENTS
, PR.REQUEST_ID
, PR.PROGRAM_APPLICATION_ID
, PR.PROGRAM_ID
, PR.PROGRAM_UPDATE_DATE
, PR.ATTRIBUTE_CATEGORY
, PR.ATTRIBUTE1
, PR.ATTRIBUTE2
, PR.ATTRIBUTE3
, PR.ATTRIBUTE4
, PR.ATTRIBUTE5
, PR.ATTRIBUTE6
, PR.ATTRIBUTE7
, PR.ATTRIBUTE8
, PR.ATTRIBUTE9
, PR.ATTRIBUTE10
, PR.ATTRIBUTE11
, PR.ATTRIBUTE12
, PR.ATTRIBUTE13
, PR.ATTRIBUTE14
, PR.ATTRIBUTE15
, PR.ATTRIBUTE16
, PR.ATTRIBUTE17
, PR.ATTRIBUTE18
, PR.ATTRIBUTE19
, PR.ATTRIBUTE20
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATED_BY
, PR.LAST_UPDATE_LOGIN
, PR.CREATED_BY
, PR.CREATION_DATE
, PR.RATE_BASIS
, HR_R.MEANING RATE_BASIS_MEANING
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('RATE_TYPE'
, RATE_TYPE)
, 1
, 80) RATE_TYPE_MEANING
, PR.OBJECT_VERSION_NUMBER
, PR.ASG_RATE_TYPE
, FND_ART.MEANING ASG_RATE_TYPE_NAME
FROM PAY_RATES PR
, PER_PARENT_SPINES PPS
, HR_LOOKUPS HR_U
, HR_LOOKUPS HR_R
, FND_LOOKUPS FND_ART
WHERE PR.PARENT_SPINE_ID = PPS.PARENT_SPINE_ID (+)
AND PR.RATE_UOM = HR_U.LOOKUP_CODE
AND HR_U.LOOKUP_TYPE = 'UNITS'
AND HR_R.LOOKUP_TYPE (+) = 'RATE_BASIS'
AND HR_R.LOOKUP_CODE (+) = PR.RATE_BASIS
AND FND_ART.LOOKUP_TYPE (+) = 'PRICE DIFFERENTIALS'
AND FND_ART.LOOKUP_CODE (+) = PR.ASG_RATE_TYPE