// 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\/-\/request_group_name?alt=json-in-script"},{"rel":"alternate","type":"text/html","href":"http:\/\/oracle-apps-learn-and-grow.blogspot.com\/search\/label\/request_group_name"},{"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":"1"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"25"},"entry":[{"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"}}]}});