Skip to main content

Posts

Showing posts from 2015

Query to find Requisition Change Orders in Rejected Status

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

SQL Query to identify loop in the Employee - Supervisor hierarchy in Oracle Applications

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

How to Restrict the Cancel Lines on PO PDF to Suppliers?

 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.