To Find RESPONSIBILITY_KEY using BASEPATH or APPLICATION_SHORT_NAME

SELECT r.responsibility_key,
  fa.APPLICATION_SHORT_NAME
FROM fnd_responsibility r,
  fnd_application_tl a,
  fnd_application fa
WHERE fa.APPLICATION_ID = a.APPLICATION_ID
AND r.application_id    = a.application_id
AND fa.BASEPATH         ='ONT_TOP';


******************************************************************************

QUERY TO CHECK, UPDATE START AND END DATE FOR AN ORDER IN ORACLE(uploaded order)

select r.customer_name,h.cust_po_number, 'PO# '||h.cust_po_number ,'SO# '||h.order_number,h.booked_flag,''''||h.header_id||''''||',',to_char(h.creation_date,'MM-DD-YYYY HH:MI:SS')from oe_order_headers_all h, ra_customers rwhere h.sold_to_org_id = r.customer_idand h.open_flag='Y'--and to_char(h.creation_date,'MMDDYYYY')='MMDDYYYY'-- > sysdate-0.5and h.orig_sys_document_ref like '%XXXX%'--and r.customer_name like'JEW%';--and r.customer_number in(XXX)order by h.creation_date desc;

update oe_order_headers_allset request_date='28-OCT-11'where header_id in ('HEADER_ID');update oe_order_headers_allset attribute2='04-NOV-11'where header_id in ('HEADER_ID');update oe_order_lines_allset request_date='28-OCT-11', SCHEDULE_SHIP_DATE ='28-OCT-11',PROMISE_DATE='28-OCT-11'where header_id in ('HEADER_ID');
update oe_order_lines_allset attribute2='04-NOV-11'where header_id in ('HEADER_ID');


select h.attribute2 hd,l.attribute2 ld,l.request_date,l.SCHEDULE_SHIP_DATE,l.PROMISE_DATE from oe_order_headers_all h,oe_order_lines_all lwhere h.header_id=l.header_idand h.open_flag='Y'and  h.cust_po_number in ('xxxxx');