Useful query to get user id, responsibility id and application id in EBS.

To know about User Id use below Query:-

SQL> select user_id from fnd_user where user_name=’DOYEN’;

To know about Responsibility id use below Query:-

SQL> select responsibility_id,RESPONSIBILITY_NAME from fnd_responsibility_vl where responsibility_name like ‘%India%Local%Payables%’;

To Know about Application id use below Query:-

SQL>select APPLICATION_ID from fnd_responsibility_vl where responsibility_id=50366;

To Know about Org id from po:-

SQL>select org_id from po_headers_all where segment1=’&PO’;

To know about Requisition Org id from requisition number:-

$SQL>select hr.name, prh.segment1, prh.org_id from po_requisition_headers_all prh, hr_all_organization_units hr where prh.org_id = hr.organization_id and prh.segment1 = ‘&Enter_Req_Number’;