SELECT document_num , ( SELECT user_name FROM apps . fnd_user fu WHERE fu . user_id = pcr . created_by) created_by , ( SELECT email_address FROM apps . fnd_user fu WHERE fu . user_id = pcr . created_by) createdby_emailaddress , creation_date , ( SELECT user_name FROM apps . fnd_user fu WHERE fu . user_id = pcr . last_updated_by) last_updated_by , ( SELECT email_address FROM apps . fnd_user fu WHERE fu . user_id = pcr . last_updated_by) updatedby_emailaddress , last_update_date , old_quantity , new_quantity , response_reason FROM apps . po_change_requests pcr WHERE request_status = 'REJECTED' AND last_update_date > sysdate - 30 -- you can change the days depends on
Posts
SELECT a . business_group_id , a . "person_id" , a . assignment_id , a . "employee_number" , a . "full_name" , a . "supervisor_id" , a . "supervisor_emp_no" , a . "supervisor" , a . "organization_id" , a . "position" , LEVEL level1 , connect_by_root supervisor_emp_no top_supervisor , connect_by_iscycle loopback , connect_by_root supervisor_id AS top_supervisor_id , Sys_connect_by_path ( supervisor_emp_no , '/' ) PATH FROM ( SELECT papf . business_group_id , papf . person_id , paaf . assignment_id , papf . employee_number , papf . full_name , paaf . su
We can restrict the Cancelled Lines on PO PDF. By Default, the value for this parameter is set to 'Yes'. We have to set this default value to 'No' in the concurrent program definition using System Administrator (Concurrent > Program > Define), Thus it prevents canceled lines from appearing in the PDF output. Old Default Value Query: Select Meaning from FND_LOOKUPS where lookup_type='YES_NO' and lookup_code='Y' New Default Value Query : Select Meaning from FND_LOOKUPS where lookup_type='YES_NO' and lookup_code='N' This will set the Default Value as 'No', and prevents canceled lines from appearing in the PDF output.