VIEW: APPS.PQP_ASSIGNMENT_ATTRIBUTES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)