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_use...
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 , ...
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.