// API callback
related_results_labels({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842"},"updated":{"$t":"2023-12-14T04:33:31.384-08:00"},"category":[{"term":"oracle apps R12"},{"term":"AP"},{"term":"PO"},{"term":"oracle apps"},{"term":"AP Base Tables"},{"term":"Concurrent Program"},{"term":"Approver"},{"term":"Base Table"},{"term":"Finance"},{"term":"HRMS"},{"term":"API"},{"term":"Employee"},{"term":"Query"},{"term":"inventory"},{"term":"invoice"},{"term":"unix"},{"term":"AR"},{"term":"BOM"},{"term":"BPA"},{"term":"Concurrent programs"},{"term":"FNDLOAD"},{"term":"Materialized View"},{"term":"Modifiers"},{"term":"Order Managment"},{"term":"Price List"},{"term":"Qualifiers"},{"term":"R12"},{"term":"SLA"},{"term":"TDS"},{"term":"XDO"},{"term":"XML Publisher Reports"},{"term":"interview"},{"term":"item"},{"term":"ABC ASSIGNMENTS"},{"term":"AOL"},{"term":"Bank Account"},{"term":"Bank Branches information"},{"term":"Bill of Material"},{"term":"Blanket Purchase Order"},{"term":"CGST"},{"term":"CZ"},{"term":"Category"},{"term":"Closing PO using API"},{"term":"Collection"},{"term":"Configurator"},{"term":"Create User"},{"term":"Credit card"},{"term":"Database"},{"term":"Date Tracking"},{"term":"FNDLOAD Scripts"},{"term":"Fmb"},{"term":"Form"},{"term":"GL"},{"term":"GST"},{"term":"Get Password"},{"term":"HTTP"},{"term":"Hold"},{"term":"Initializing session"},{"term":"JAI"},{"term":"Linux"},{"term":"List of tables"},{"term":"MTL"},{"term":"Multi Org"},{"term":"Operating_units"},{"term":"Oracle clone URL"},{"term":"Order To Cash Cycle – O2C"},{"term":"Org_id"},{"term":"P2P"},{"term":"PR"},{"term":"Price List tables"},{"term":"Primary Price list"},{"term":"Product Rent"},{"term":"Purchase Requisition"},{"term":"Purchase order"},{"term":"Query to find Bank"},{"term":"Report"},{"term":"Routing"},{"term":"SCM"},{"term":"SGST"},{"term":"SOAP"},{"term":"SQL"},{"term":"SSH"},{"term":"Sales Order"},{"term":"Secondary Price list"},{"term":"Sequence"},{"term":"Shell Script"},{"term":"Supplier"},{"term":"TAX"},{"term":"TCA"},{"term":"Type"},{"term":"Uncheck ignore flag"},{"term":"User"},{"term":"View"},{"term":"WIP"},{"term":"WSDL"},{"term":"WebService"},{"term":"XML"},{"term":"XML publisher"},{"term":"bursting"},{"term":"ccid"},{"term":"concurrent program parameter"},{"term":"currval"},{"term":"customer"},{"term":"customer account"},{"term":"cvv number"},{"term":"deliveries"},{"term":"delivery"},{"term":"fnd"},{"term":"forms"},{"term":"location"},{"term":"nextval"},{"term":"oracle EBS"},{"term":"oracle R12"},{"term":"organization_id"},{"term":"output path"},{"term":"people"},{"term":"per"},{"term":"projects"},{"term":"putty"},{"term":"qp_list_headers"},{"term":"request_group_name"},{"term":"session in oracle apps"},{"term":"technical"},{"term":"template"},{"term":"value set"},{"term":"wsh"}],"title":{"type":"text","$t":"Oracle Apps -Learn and grow"},"subtitle":{"type":"html","$t":"\"Oracle Apps -Learn and grow\" ,here we are sharing queries,technical and functional knowledge of oracle Apps."},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/-\/Query?alt=json-in-script"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/search\/label\/Query"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Anonymous"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/14708334674681358157"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"3"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"25"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-4540614209677872060"},"published":{"$t":"2023-08-16T07:30:00.001-07:00"},"updated":{"$t":"2023-08-16T07:30:00.144-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Query"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"}],"title":{"type":"text","$t":" SQL Query to Find Lock Sessions in Oracle Apps R12"},"content":{"type":"html","$t":"\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cdiv class=\"post-body entry-content\" style=\"background-color: white; box-sizing: border-box; color: #333333; font-family: arial, helvetica; font-size: 14px; line-height: 1.6em; margin: 0px 0px 0.75em;\"\u003E\u003Cdiv id=\"PostBody\" style=\"box-sizing: border-box;\"\u003E\u003Cdiv dir=\"ltr\" style=\"box-sizing: border-box;\" trbidi=\"on\"\u003E\u003Cdiv style=\"box-sizing: border-box; clear: both; margin: 5px 0px; text-align: center;\"\u003E\u003C\/div\u003ESELECT s.inst_id,\u003Cbr style=\"box-sizing: border-box;\" \/\u003ENVL (s.username, 'Internal') \"User Name\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003Em.SID,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Es.serial#,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Ep.spid \"DB OS Process\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003Em.TYPE,\u003Cbr style=\"box-sizing: border-box;\" \/\u003EDECODE (m.lmode,\u003Cbr style=\"box-sizing: border-box;\" \/\u003E0, 'None',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E1, 'Null',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E2, 'Row Share',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E3, 'Row Excl.',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E4, 'Share',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E5, 'S\/Row Excl.',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E6, 'Exclusive',\u003Cbr style=\"box-sizing: border-box;\" \/\u003Elmode, LTRIM (TO_CHAR (lmode, '990'))\u003Cbr style=\"box-sizing: border-box;\" \/\u003E) \"Lock Type\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003EDECODE (m.request,\u003Cbr style=\"box-sizing: border-box;\" \/\u003E0, 'None',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E1, 'Null',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E2, 'Row Share',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E3, 'Row Excl.',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E4, 'Share',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E5, 'S\/Row Excl.',\u003Cbr style=\"box-sizing: border-box;\" \/\u003E6, 'Exclusive',\u003Cbr style=\"box-sizing: border-box;\" \/\u003Erequest, LTRIM (TO_CHAR (m.request, '990'))\u003Cbr style=\"box-sizing: border-box;\" \/\u003E) \"Lock Request\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003EDECODE (command,\u003Cbr style=\"box-sizing: border-box;\" \/\u003E0, 'None',\u003Cbr style=\"box-sizing: border-box;\" \/\u003EDECODE (m.id2,\u003Cbr style=\"box-sizing: border-box;\" \/\u003E0, dusr.username || '.' || SUBSTR (dobj.NAME, 1, 30),\u003Cbr style=\"box-sizing: border-box;\" \/\u003E'Rollback Segment'\u003Cbr style=\"box-sizing: border-box;\" \/\u003E)\u003Cbr style=\"box-sizing: border-box;\" \/\u003E) \"Object\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003Es.machine \"Application Server\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003Es.process \"Apps OS process\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003Em.ctime,\u003Cbr style=\"box-sizing: border-box;\" \/\u003ENVL (NVL (usr.description, s.action),\u003Cbr style=\"box-sizing: border-box;\" \/\u003E'Database Session'\u003Cbr style=\"box-sizing: border-box;\" \/\u003E) \"Online User,Concurrent\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003ENVL (fnd.responsibility_name, s.module) \"Responsibility,Module\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003E\u003Ccenter style=\"box-sizing: border-box;\"\u003E\u003C\/center\u003E\u003Cbr style=\"box-sizing: border-box;\" \/\u003Efnd.user_form_name \"Form Name\",\u003Cbr style=\"box-sizing: border-box;\" \/\u003ESQL.sql_text \"Statement\"\u003Cbr style=\"box-sizing: border-box;\" \/\u003EFROM gv$session s,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Egv$lock m,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Egv$process p,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Eapps.fnd_form_sessions_v fnd,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Eapps.fnd_user usr,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Egv$sqlarea SQL,\u003Cbr style=\"box-sizing: border-box;\" \/\u003Edba_users dusr,\u003Cbr style=\"box-sizing: border-box;\" \/\u003ESYS.obj$ dobj\u003Cbr style=\"box-sizing: border-box;\" \/\u003EWHERE m.id1 IN (SELECT il.id1\u003Cbr style=\"box-sizing: border-box;\" \/\u003EFROM gv$lock il\u003Cbr style=\"box-sizing: border-box;\" \/\u003EWHERE il.request \u0026lt;\u0026gt; 0)\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND m.SID = s.SID\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND s.paddr = p.addr\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND s.inst_id = p.inst_id\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND SQL.inst_id(+) = s.inst_id\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND SQL.address(+) = s.sql_address\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND SQL.hash_value(+) = s.sql_hash_value\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND s.username != 'SYS'\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND m.lmode != 4\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND fnd.audsid(+) = s.audsid\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND m.inst_id = s.inst_id\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND fnd.user_name = usr.user_name(+)\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND fnd.user_id = usr.user_id(+)\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND dobj.obj#(+) = DECODE (m.id2, 0, m.id1, 1)\u003Cbr style=\"box-sizing: border-box;\" \/\u003EAND dusr.user_id(+) = dobj.owner#\u003Cbr style=\"box-sizing: border-box;\" \/\u003EORDER BY m.id1, m.request ASC, m.SID;\u003C\/div\u003E\u003C\/div\u003E\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/4540614209677872060\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2023\/08\/sql-query-to-find-lock-sessions-in.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4540614209677872060"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4540614209677872060"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2023\/08\/sql-query-to-find-lock-sessions-in.html","title":" SQL Query to Find Lock Sessions in Oracle Apps R12"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-5269780421548465297"},"published":{"$t":"2020-07-02T23:10:00.001-07:00"},"updated":{"$t":"2020-07-02T23:10:07.967-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent programs"},{"scheme":"http://www.blogger.com/atom/ns#","term":"oracle apps R12"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Query"}],"title":{"type":"text","$t":"Query to Find scheduled concurrent program's in Oracle apps"},"content":{"type":"html","$t":"\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003ESELECT fcr.request_id,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EDECODE(fcpt.user_concurrent_program_name,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'Report Set',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'Report Set:' || fcr.description,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Efcpt.user_concurrent_program_name) CONC_PROG_NAME,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Eargument_text PARAMETERS,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003ENVL2(fcr.resubmit_interval,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'PERIODICALLY',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003ENVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EDECODE(NVL2(fcr.resubmit_interval,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'PERIODICALLY',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003ENVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'PERIODICALLY',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'EVERY ' || fcr.resubmit_interval || ' ' ||\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Efcr.resubmit_interval_unit_code || ' FROM ' ||\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Efcr.resubmit_interval_type_code || ' OF PREV RUN',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'ONCE',\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'AT :' ||\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003ETO_CHAR(fcr.requested_start_date, 'DD-MON-RR HH24:MI'),\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003E'EVERY: ' || fcrc.class_info) PROG_SCHEDULE,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Efu.user_name USER_NAME,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Erequested_start_date START_DATE\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EFROM apps.fnd_concurrent_programs_tl fcpt,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Eapps.fnd_concurrent_requests fcr,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Eapps.fnd_user fu,\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003Eapps.fnd_conc_release_classes fcrc\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EWHERE fcpt.application_id = fcr.program_application_id\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcpt.concurrent_program_id = fcr.concurrent_program_id\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcr.requested_by = fu.user_id\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcr.phase_code = 'P'\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcr.requested_start_date \u0026gt; SYSDATE\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcpt.LANGUAGE = 'US'\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcrc.release_class_id(+) = fcr.release_class_id\u003C\/font\u003E\u003C\/div\u003E\u003Cdiv\u003E\u003Cfont face=\"verdana\"\u003EAND fcrc.application_id(+) = fcr.release_class_app_id;\u003C\/font\u003E\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/5269780421548465297\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2020\/07\/query-to-find-scheduled-concurrent.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/5269780421548465297"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/5269780421548465297"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2020\/07\/query-to-find-scheduled-concurrent.html","title":"Query to Find scheduled concurrent program's in Oracle apps"}],"author":[{"name":{"$t":"Adarsh"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/03865349818764326722"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-6132177977991557842.post-4482170992665367909"},"published":{"$t":"2016-09-21T05:54:00.000-07:00"},"updated":{"$t":"2016-09-21T06:01:46.474-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Concurrent Program"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Query"},{"scheme":"http://www.blogger.com/atom/ns#","term":"request_group_name"}],"title":{"type":"text","$t":"Query to Find Responsibilities based on Concurrent Program"},"content":{"type":"html","$t":"\u003Cdiv dir=\"ltr\" style=\"text-align: left;\" trbidi=\"on\"\u003E\n\u003Cbr \/\u003E\n\u003Ch2 style=\"text-align: center;\"\u003E\nQuery to Find Responsibilities based on Concurrent Program Name\u003C\/h2\u003E\nSELECT \u0026nbsp; \u0026nbsp;Distinct frt.responsibility_name, frg.request_group_name,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; frgu.request_unit_type,frgu.request_unit_id,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fcpt.user_concurrent_program_name\u003Cbr \/\u003E\n\u0026nbsp; FROM \u0026nbsp; \u0026nbsp; fnd_Responsibility fr, fnd_responsibility_tl frt,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fnd_request_groups frg, fnd_request_group_units frgu,\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; \u0026nbsp; fnd_concurrent_programs_tl fcpt\u003Cbr \/\u003E\n\u0026nbsp; WHERE \u0026nbsp;frt.responsibility_id = fr.responsibility_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frg.request_group_id = fr.request_group_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frgu.request_group_id = frg.request_group_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.concurrent_program_id = frgu.request_unit_id\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; frt.LANGUAGE = USERENV('LANG')\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.LANGUAGE = USERENV('LANG')\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp; AND \u0026nbsp; \u0026nbsp; fcpt.user_concurrent_program_name = P_conc_prg_name\u003Cbr \/\u003E\n\u0026nbsp; \u0026nbsp;\u003Cbr \/\u003E\n\u003Cdiv\u003E\n\u003Cbr \/\u003E\u003C\/div\u003E\n\u003C\/div\u003E\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/feeds\/4482170992665367909\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2016\/09\/query-to-find-responsibilities-based-on-concurrent.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4482170992665367909"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/6132177977991557842\/posts\/default\/4482170992665367909"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/2016\/09\/query-to-find-responsibilities-based-on-concurrent.html","title":"Query to Find Responsibilities based on Concurrent Program"}],"author":[{"name":{"$t":"Anonymous"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/14708334674681358157"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"0"}}]}});