ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4173869E053B46B63588994 select distinct PERSON_ID ,val_01 ADDUPDATE ,val_02 MEMREFNUM ,val_03 NINUMBER ,val_04 FORENAME ,val_05 SURNAME ,val_06 ADDLINE1 ,val_07 ADDLINE2 ,val_08 ADDLINE3 ,val_09 ADDLINE4 ,val_10 ADDLINE5 ,val_11 POSTCODE ,val_12 DOB ,val_13 LOCALAUTHNO ,val_14 ESTBNO ,val_15 STARTDATE ,val_16 ENDDATE ,val_17 WDCONFIRM ,val_18 DAYSEXCLUDED ,val_19 FTPTINDI ,val_20 ANNUALFTSAL ,val_21 PTSALPTD ,val_22 ADDLCONPTD ,val_23 OVERTIMEPTD ,val_24 EMAIL ,val_25 EERCONPTD ,val_26 EESCONPTD ,val_27 GENDER ,nvl(val_41,0) PTSALYTD ,nvl(val_42,0) ADDLCONYTD ,nvl(val_43,0) OVERTIMEYTD ,nvl(val_44,0) EERCONYTD ,nvl(val_45,0) EESCONYTD from ben_ext_rslt ber, ben_ext_rslt_dtl berd, fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2 where fcr1.request_id = :P_REQUEST_ID and fcr2.parent_request_id = fcr1.request_id and fcr2.request_id = ber.REQUEST_ID and ber.EXT_RSLT_ID = berd.EXT_RSLT_ID and ber.BUSINESS_GROUP_ID = berd.BUSINESS_GROUP_ID Y PQP PQPMDCRECXLSOP US PQP TP MDC Reconciliation Report - Excel Output Application: Public Sector Payroll Source: PQP TP MDC Reconciliation Report - Excel Output Short Name: PQPMDCRECXLSOP DB package: BI Publisher :p_request_id 1 10 :p_request_id LOV Oracle BEN_MDC_EXT_RSLT Y select request_id id, request_id value, null description from fnd_concurrent_requests where concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs where concurrent_program_name='PQPMDCXTRCT') and status_code='C' order by request_date desc US Request ID