View: PQP_ASSIGNMENT_ATTRIBUTES_V

Product:	PQP - Public Sector Payroll
Description:	View of table PQP_ASSIGNMENT_ATTRIBUTES_F.
Implementation/DBA Data:	APPS.PQP_ASSIGNMENT_ATTRIBUTES_V

View Text

SELECT AAT.ROWID
, AAT.ASSIGNMENT_ATTRIBUTE_ID
, AAT.EFFECTIVE_START_DATE
, AAT.EFFECTIVE_END_DATE
, AAT.BUSINESS_GROUP_ID
, AAT.ASSIGNMENT_ID
, AAT.CONTRACT_TYPE
, AAT.WORK_PATTERN
, AAT.START_DAY
, AAT.LAST_UPDATE_DATE
, AAT.LAST_UPDATED_BY
, AAT.LAST_UPDATE_LOGIN
, AAT.CREATED_BY
, AAT.CREATION_DATE
, AAT.OBJECT_VERSION_NUMBER
, AAT.PRIMARY_COMPANY_CAR
, PVD1.REGISTRATION_NUMBER
, PVD1.MAKE
, PVD1.MODEL
, AAT.PRIMARY_CAR_FUEL_BENEFIT
, AAT.PRIMARY_CAPITAL_CONTRIBUTION
, AAT.PRIMARY_PRIVATE_CONTRIBUTION
, AAT.PRIMARY_CLASS_1A
, AAT.SECONDARY_COMPANY_CAR
, PVD2.REGISTRATION_NUMBER
, PVD2.MAKE
, PVD2.MODEL
, AAT.SECONDARY_CAR_FUEL_BENEFIT
, AAT.SECONDARY_CAPITAL_CONTRIBUTION
, AAT.SECONDARY_PRIVATE_CONTRIBUTION
, AAT.SECONDARY_CLASS_1A
, AAT.COMPANY_CAR_CALC_METHOD
, HRL1.MEANING
, AAT.COMPANY_CAR_RATES_TABLE_ID
, UDT1.USER_TABLE_NAME
, AAT.COMPANY_CAR_SECONDARY_TABLE_ID
, UDT2.USER_TABLE_NAME
, AAT.PRIVATE_CAR
, PVD3.REGISTRATION_NUMBER
, PVD3.MAKE
, PVD3.MODEL
, PVD3.ENGINE_CAPACITY_IN_CC
, PVD3.FUEL_TYPE
, HRL3.MEANING
, AAT.PRIVATE_CAR_CALC_METHOD
, HRL2.MEANING
, AAT.PRIVATE_CAR_RATES_TABLE_ID
, UDT3.USER_TABLE_NAME
, AAT.PRIVATE_CAR_ESSENTIAL_TABLE_ID
, UDT4.USER_TABLE_NAME
, AAT.TP_IS_TEACHER
, AAT.TP_SAFEGUARDED_GRADE
, AAT.TP_SAFEGUARDED_GRADE_ID
, AAT.TP_SAFEGUARDED_RATE_TYPE
, AAT.TP_SAFEGUARDED_RATE_ID
, PR.NAME TP_SAFEGUARDED_RATE_NAME
, AAT.TP_SAFEGUARDED_SPINAL_POINT_ID
, PSP.SPINAL_POINT TP_SAFEGUARDED_SPINAL_POINT
, AAT.TP_ELECTED_PENSION
, AAT.TP_FAST_TRACK
, AAT.TP_HEADTEACHER_GRP_CODE
, AAT.AAT_ATTRIBUTE_CATEGORY
, AAT.AAT_ATTRIBUTE1
, AAT.AAT_ATTRIBUTE2
, AAT.AAT_ATTRIBUTE3
, AAT.AAT_ATTRIBUTE4
, AAT.AAT_ATTRIBUTE5
, AAT.AAT_ATTRIBUTE6
, AAT.AAT_ATTRIBUTE7
, AAT.AAT_ATTRIBUTE8
, AAT.AAT_ATTRIBUTE9
, AAT.AAT_ATTRIBUTE10
, AAT.AAT_ATTRIBUTE11
, AAT.AAT_ATTRIBUTE12
, AAT.AAT_ATTRIBUTE13
, AAT.AAT_ATTRIBUTE14
, AAT.AAT_ATTRIBUTE15
, AAT.AAT_ATTRIBUTE16
, AAT.AAT_ATTRIBUTE17
, AAT.AAT_ATTRIBUTE18
, AAT.AAT_ATTRIBUTE19
, AAT.AAT_ATTRIBUTE20
, AAT.AAT_INFORMATION_CATEGORY
, AAT.AAT_INFORMATION1
, AAT.AAT_INFORMATION2
, AAT.AAT_INFORMATION3
, AAT.AAT_INFORMATION4
, AAT.AAT_INFORMATION5
, AAT.AAT_INFORMATION6
, AAT.AAT_INFORMATION7
, AAT.AAT_INFORMATION8
, AAT.AAT_INFORMATION9
, AAT.AAT_INFORMATION10
, AAT.AAT_INFORMATION11
, AAT.AAT_INFORMATION12
, AAT.AAT_INFORMATION13
, AAT.AAT_INFORMATION14
, AAT.AAT_INFORMATION15
, AAT.AAT_INFORMATION16
, AAT.AAT_INFORMATION17
, AAT.AAT_INFORMATION18
, AAT.AAT_INFORMATION19
, AAT.AAT_INFORMATION20
, AAT.LGPS_PROCESS_FLAG
, AAT.LGPS_EXCLUSION_TYPE
, AAT.LGPS_PENSIONABLE_PAY
, AAT.LGPS_TRANS_ARRANG_FLAG
, AAT.LGPS_MEMBERSHIP_NUMBER
FROM PQP_ASSIGNMENT_ATTRIBUTES_F AAT
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
, HR_LOOKUPS HRL3
, PQP_VEHICLE_DETAILS PVD1
, PQP_VEHICLE_DETAILS PVD2
, PQP_VEHICLE_DETAILS PVD3
, PAY_USER_TABLES UDT1
, PAY_USER_TABLES UDT2
, PAY_USER_TABLES UDT3
, PAY_USER_TABLES UDT4
, PAY_RATES PR
, PER_SPINAL_POINTS PSP
WHERE AAT.PRIMARY_COMPANY_CAR = PVD1.VEHICLE_DETAILS_ID(+)
AND AAT.SECONDARY_COMPANY_CAR = PVD2.VEHICLE_DETAILS_ID(+)
AND AAT.PRIVATE_CAR = PVD3.VEHICLE_DETAILS_ID(+)
AND AAT.COMPANY_CAR_CALC_METHOD = HRL1.LOOKUP_CODE(+)
AND HRL1.LOOKUP_TYPE(+) = 'PQP_VEHICLE_CALC_METHOD'
AND AAT.PRIVATE_CAR_CALC_METHOD = HRL2.LOOKUP_CODE(+)
AND HRL2.LOOKUP_TYPE(+) = 'PQP_VEHICLE_CALC_METHOD'
AND PVD3.FUEL_TYPE = HRL3.LOOKUP_CODE(+)
AND HRL3.LOOKUP_TYPE(+) = 'PQP_FUEL_TYPE'
AND AAT.COMPANY_CAR_RATES_TABLE_ID = UDT1.USER_TABLE_ID(+)
AND AAT.COMPANY_CAR_SECONDARY_TABLE_ID = UDT2.USER_TABLE_ID(+)
AND AAT.PRIVATE_CAR_RATES_TABLE_ID = UDT3.USER_TABLE_ID(+)
AND AAT.PRIVATE_CAR_ESSENTIAL_TABLE_ID = UDT4.USER_TABLE_ID(+)
AND AAT.TP_SAFEGUARDED_RATE_ID = PR.RATE_ID(+)
AND AAT.TP_SAFEGUARDED_SPINAL_POINT_ID = PSP.SPINAL_POINT_ID(+)

Columns