VIEW: APPS.PQP_ASSIGNMENT_ATTRIBUTES_D

Source

View Text - Preformatted

SELECT AAT.ASSIGNMENT_ATTRIBUTE_ID ,AAT.EFFECTIVE_START_DATE ,AAT.EFFECTIVE_END_DATE ,AAT.CONTRACT_TYPE ,AAT.WORK_PATTERN ,AAT.START_DAY ,HRL1.MEANING ,AAT.TP_SAFEGUARDED_GRADE ,AAT.TP_SAFEGUARDED_RATE_TYPE ,PR.NAME TP_SAFEGUARDED_RATE_NAME ,PSP.SPINAL_POINT TP_SAFEGUARDED_SPINAL_POINT ,AAT.TP_ELECTED_PENSION ,AAT.TP_FAST_TRACK ,AAT.TP_HEADTEACHER_GRP_CODE ,AAT.LAST_UPDATE_DATE ,USR.USER_NAME LAST_UPDATED_BY ,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 ,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 ,FND_USER_VIEW USR ,HR_LOOKUPS HRL1 ,PAY_RATES PR ,PER_SPINAL_POINTS PSP WHERE USR.USER_ID (+) = AAT.LAST_UPDATED_BY AND 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_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_IS_TEACHER = HRL1.LOOKUP_CODE(+) AND HRL1.LOOKUP_TYPE(+) = 'PQP_GB_TEACHER_JOB_STATUS' 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.ASSIGNMENT_ATTRIBUTE_ID
, AAT.EFFECTIVE_START_DATE
, AAT.EFFECTIVE_END_DATE
, AAT.CONTRACT_TYPE
, AAT.WORK_PATTERN
, AAT.START_DAY
, HRL1.MEANING
, AAT.TP_SAFEGUARDED_GRADE
, AAT.TP_SAFEGUARDED_RATE_TYPE
, PR.NAME TP_SAFEGUARDED_RATE_NAME
, PSP.SPINAL_POINT TP_SAFEGUARDED_SPINAL_POINT
, AAT.TP_ELECTED_PENSION
, AAT.TP_FAST_TRACK
, AAT.TP_HEADTEACHER_GRP_CODE
, AAT.LAST_UPDATE_DATE
, USR.USER_NAME LAST_UPDATED_BY
, 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
, 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
, FND_USER_VIEW USR
, HR_LOOKUPS HRL1
, PAY_RATES PR
, PER_SPINAL_POINTS PSP
WHERE USR.USER_ID (+) = AAT.LAST_UPDATED_BY
AND 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_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_IS_TEACHER = HRL1.LOOKUP_CODE(+)
AND HRL1.LOOKUP_TYPE(+) = 'PQP_GB_TEACHER_JOB_STATUS'
AND AAT.TP_SAFEGUARDED_RATE_ID=PR.RATE_ID(+)
AND AAT.TP_SAFEGUARDED_SPINAL_POINT_ID=PSP.SPINAL_POINT_ID(+)