Oracle Apps - To know the responsibility of user

Hi Folks,

 Below is the query to know the responsibility of user

   SELECT fu.user_name, fu.start_date user_startdate, fu.end_date user_enddate,

       fr.responsibility_name, furgd.start_date, furgd.end_date,

       fu.email_address,trunc(sysdate)

  FROM fnd_user fu,

       fnd_user_resp_groups_direct furgd,

       fnd_responsibility_tl fr

 WHERE fr.responsibility_id = furgd.responsibility_id

   AND fu.user_id = furgd.user_id

 and fu.user_name = :User_name

   AND fr.LANGUAGE = 'US'

Oracle Apps - How do get PO details based on Requisition Number

Hi Folks,

Below is the query to get PO details based on Requisition Number

SELECT poh.segment1, prha.segment1 RequisitionNumber,poh.*

FROM   apps.po_headers_all poh

,      apps.po_lines_all pol

,      apps.po_distributions_all pod

,      apps.po_req_distributions_all prda

,      apps.po_requisition_lines_all prla

,      apps.po_requisition_headers_all prha

WHERE  poh.po_header_id = pol.po_header_id

AND    pol.po_line_id = pod.po_line_id

AND    pod.req_distribution_id = prda.distribution_id

AND    prda.requisition_line_id = prla.requisition_line_id

AND    prla.requisition_header_id = prha.requisition_header_id

AND    prha.segment1= :Requisition_Number

order by prha.LAST_UPDATE_DATE desc

Oracle Apps - How do get Requisition details based on PO Number

HI Folks

Below is the query to get Requisition details based on PO Number

select prha.segment1 Requisition_Number,poh.*

from po_requisition_headers_all prha,

     po_requisition_lines_all prla,

     po_req_distributions_all prda,

     po_distributions_all pda,

     PO_HEADERS_ALL poh

where poh.po_header_id =pda.po_header_id

and pda.req_distribution_id = prda.distribution_id

and prda.requisition_line_id = prla.requisition_line_id

and prla.requisition_header_id = prha.requisition_header_id

and poh.segment1 = :PO_Number

Check User's Profile Value

HI Folks,

To check user profile value's through query.

 SELECT   p.user_profile_option_name, '3 - User', u.user_name, v.level_value,

         v.profile_option_value

    FROM fnd_profile_option_values v, fnd_profile_options_vl p, fnd_user u

   WHERE v.profile_option_id = p.profile_option_id

     AND (v.level_id = 10004 AND u.user_id = v.level_value)

     AND u.user_name = :'User_ Name'

--AND P.USER_PROFILE_OPTION_NAME LIKE '%FND: View Object Max Fetch Size%'

ORDER BY 1, 2, 3