tag:blogger.com,1999:blog-61164169746026321702024-03-19T01:48:23.776-07:00Oracle ApplicationsThis website is for Oracle Apps and Oracle Developer's both Budding , Newbie to Oracle and Oracle applications those who want to become Apps Developer's.Unknownnoreply@blogger.comBlogger136125tag:blogger.com,1999:blog-6116416974602632170.post-31287106397364552342020-08-30T23:09:00.000-07:002020-08-30T23:09:02.582-07:00How to find the Oracle user id and the description of the Oracle User <p> SELECT * FROM FND_ORACLE_USERID</p>Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-20559449457112217922020-08-30T23:05:00.000-07:002020-08-30T23:05:01.406-07:00To find the concurrent request Arguments<p> To find the current request arguments in 2 ways. </p><p>1.SELECT ARGUMENT_TEXT, ARGUMENT1,ARGUMENT2,ARGUMENT3, ARGUMENT4,ARGUMENT5 FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = 4532223</p><p>2. select * from FND_CONC_REQUEST_ARGUMENTS WHERE REQUEST_ID = 112581918</p>Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-4360547003877526212019-10-29T02:17:00.001-07:002019-10-29T02:17:47.769-07:00API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER<div dir="ltr"><br clear="all"><div>Below script is used for updating User end date </div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><font color="#666666"><br></font></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><font color="#666666"><br></font></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">DECLARE<br> lc_user_name VARCHAR2(100) := 'SGUDURU';<br> ld_user_end_date DATE := SYSDATE+1000;<br>BEGIN<br> fnd_user_pkg.updateuser<br> ( x_user_name => lc_user_name,<br> x_owner => NULL,<br> x_unencrypted_password => NULL,<br> x_start_date => NULL,<br> x_end_date => sysdate+1000,<br> x_password_date => sysdate+1000,<br> x_password_lifespan_days => NULL,<br> x_employee_id => NULL,<br> x_email_address => NULL<br> );<br><br> COMMIT;<br><br>EXCEPTION<br> WHEN OTHERS THEN<br> ROLLBACK;<br> DBMS_OUTPUT.PUT_LINE(SQLERRM);<br>END;<br>/<font color="#666666"><br></font></div></div> Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-6116416974602632170.post-60915308506852082642018-04-18T04:30:00.001-07:002018-04-18T04:30:26.669-07:00SQL Query to find Request Set for the given concurrent program<div dir="ltr">SQL Query to find Request Set for the given concurrent program :<div><br><div><br></div><div><div>SELECT</div><div> DISTINCT user_request_set_name</div><div>FROM</div><div> fnd_request_sets_tl rs,</div><div> fnd_request_set_programs rsp,</div><div> fnd_concurrent_programs_tl cp</div><div>WHERE</div><div> rsp.concurrent_program_id = cp.concurrent_program_id</div><div> AND rs.request_set_id = rsp.request_set_id</div><div> AND upper(user_concurrent_program_name) = upper(:enter_prog_name)</div><div> ;</div></div></div></div> Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6116416974602632170.post-69124290018390119682018-04-05T04:57:00.001-07:002018-04-05T04:57:15.780-07:00Script to Change Password of user from Backend In Oracle Applications Using API<div dir="ltr"><div>SET serveroutput ON;</div><div>DECLARE</div><div> v_user_name VARCHAR2(30):= UPPER('SGUDURU');</div><div> v_new_password VARCHAR2(30):= 'welcome1';</div><div> v_status BOOLEAN;</div><div>BEGIN</div><div> v_status := fnd_user_pkg.ChangePassword ( username => v_user_name, </div><div> newpassword => v_new_password </div><div> );</div><div> IF v_status =TRUE THEN</div><div> dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);</div><div> COMMIT;</div><div> ELSE</div><div> DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));</div><div> ROLLBACK;</div><div> END IF;</div><div>END;</div></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-15563307211166613372018-04-05T04:48:00.001-07:002018-04-05T04:48:52.056-07:00Query to list Active Responsibilities of a Active User In Oracle Applications<div dir="ltr"><br><div><div>SELECT fu.user_name,</div><div> frv.responsibility_name,</div><div> frv.responsibility_key,</div><div> TO_CHAR (furgd.start_date, 'DD-MON-YYYY') "START_DATE",</div><div> TO_CHAR (furgd.end_date, 'DD-MON-YYYY') "END_DATE"</div><div>FROM fnd_user fu,</div><div> fnd_user_resp_groups_direct furgd,</div><div> fnd_responsibility_vl frv</div><div>WHERE fu.user_id = furgd.user_id</div><div>AND furgd.responsibility_id = frv.responsibility_id</div><div>AND furgd.end_date IS NULL</div><div>AND fu.user_name = '&user_name'</div><div>AND furgd.start_date <= sysdate</div><div>AND NVL(furgd.end_date, sysdate + 1) > sysdate</div><div>AND fu.start_date <= sysdate</div><div>AND NVL(fu.end_date, sysdate + 1) > sysdate</div><div>AND frv.start_date <= sysdate</div><div>AND NVL(frv.end_date, sysdate + 1) > sysdate;</div></div></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-39210690302851533372018-03-25T21:28:00.001-07:002018-03-25T21:28:01.432-07:00How to get table to index structure like toad<div dir="ltr" style="text-align: left;" trbidi="on">
Here is the built in which will give you the table or index structure .<br />
<br />
How to get tables / Index structure.<br />
SELECT to_char(DBMS_METADATA.GET_DDL ('INDEX', index_name,index_owner))<br />
FROM dba_indexes<br />
WHERE table_owner=upper('APPS');<br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
SELECT to_char(DBMS_METADATA.GET_DDL ('TABLE', TABLE_name, table_owner))<br />
FROM dba_TABLES<br />
WHERE table_owner=upper('ONT');</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-75655347570598146202018-01-30T23:07:00.001-08:002018-01-30T23:07:05.322-08:00PL/SQL Script to Add System Administrator in Oracle Applications<div dir="ltr">BEGIN<br>fnd_user_pkg.addresp ('SGUDURU','SYSADMIN','SYSTEM_ADMINISTRATOR','STANDARD','Add Responsibility to USER using pl/sql',SYSDATE,SYSDATE + 100);<br>commit;<br>dbms_output.put_line('Responsibility Added Successfully');<br>exception<br> WHEN others THEN<br> dbms_output.put_line(' Responsibility is not added due to ' || SQLCODE || substr(SQLERRM, 1, 100));<br> ROLLBACK;<br>END;<br> <br></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-14427643462877700872018-01-30T23:05:00.001-08:002018-01-30T23:05:32.186-08:00Pl/SQL Script to Create user in Oracle applications<div dir="ltr">DECLARE<br> v_user_name VARCHAR2(30):=UPPER('SGUDURU');<br> v_password VARCHAR2(30):='ORACLE123';<br> v_session_id INTEGER := USERENV('sessionid');<br>BEGIN<br> fnd_user_pkg.createuser (<br> x_user_name => v_user_name,<br> x_owner => NULL,<br> x_unencrypted_password => v_password,<br> x_session_number => v_session_id,<br> x_start_date => SYSDATE,<br> x_end_date => NULL<br> );<br> COMMIT;<br> DBMS_OUTPUT.put_line ('User:'||v_user_name||'Created Successfully');<br>EXCEPTION<br> WHEN OTHERS THEN<br> DBMS_OUTPUT.put_line ('Unable to create User due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));<br> ROLLBACK;<br>END;<br></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-69815483241634801722018-01-22T02:00:00.003-08:002018-01-22T02:00:38.962-08:00How to rebuild a partitioned index<div dir="ltr" style="text-align: left;" trbidi="on">
alter index my_ind1 rebuild partition P_1 ;<br />
<br />
<br /></div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-56152082048726729032018-01-02T23:09:00.002-08:002018-01-02T23:09:54.744-08:00How to verify the xml template file <div dir="ltr" style="text-align: left;" trbidi="on">
select * from apps.xdo_templates_vl where template_name like '%Service Contract%'</div>
Anonymousnoreply@blogger.com14tag:blogger.com,1999:blog-6116416974602632170.post-24426974539244787232018-01-02T23:06:00.002-08:002018-01-02T23:06:33.983-08:00How to find the oracle workflow version using sql query<div dir="ltr" style="text-align: left;" trbidi="on">
select * from WF_RESOURCES where NAME = 'WF_VERSION' and language = 'US'</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-7807497514440009052017-10-31T10:02:00.001-07:002017-10-31T10:02:51.352-07:00Oracle Applications front end URL from Back end<div dir="ltr"><div><div><strong></strong>SELECT profile_option_value<br>FROM fnd_profile_option_values<br>WHERE profile_option_id=<br>(SELECT profile_option_id<br>FROM fnd_profile_options WHERE <br>profile_option_name = 'APPS_FRAMEWORK_AGENT')<br>AND level_value = 0;<br><br></div>Or <br><br>SELECT home_url FROM icx_parameters;<br><br></div>In Some cases above query may not work properly.<br></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-28188559019714672962017-08-22T14:36:00.001-07:002017-08-22T14:36:29.695-07:00Query to find current running SQL for given Concurrent Program<div dir="ltr">SELECT a.address,<br> s.status,<br> s.username,<br> s.osuser,<br> a.sql_text,<br> s.SID<br>FROM v$sql a,<br> v$session s<br>WHERE s.sql_address = a.address<br>AND s.SID IN<br> (SELECT d.SID<br> FROM apps.fnd_concurrent_requests a,<br> apps.fnd_concurrent_processes b,<br> v$process c,<br> v$session d<br> --v$sql e<br> WHERE a.controlling_manager = b.concurrent_process_id<br> AND c.pid = b.oracle_process_id<br> AND d.paddr = c.addr<br> --AND d.sql_address = e.address<br> AND a.request_id = 10803707 (provide the actual request id)<br> and a.PHASE_CODE = 'R'<br> )<br></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-82552092112833555822017-08-22T14:34:00.001-07:002017-08-22T14:34:40.432-07:00Query to find Indexed Column names in table<div dir="ltr">SELECT c.index_name, i.uniqueness, c.column_name<br>FROM user_indexes i, user_ind_columns c<br>WHERE i.index_name = c.index_name<br> AND i.table_name = UPPER(:P_TABLE_NAME)<br>ORDER BY c.index_name, c.column_position;<br></div> Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6116416974602632170.post-68361859492362020212016-11-01T21:30:00.002-07:002016-11-01T21:30:49.609-07:00What is hold in OM ? What are the types of Holds in Order Management.<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
A Hold is to stop an order, return, order line, or return
line from continuing to progress through its life cycle. <o:p></o:p></div>
<div class="MsoNormal">
A Hold can be applied manually to a specific order by
querying the order and then selecting the apply holds screen or can be applied
automatically based on set of criteria
defined by the user (Hold source setup). User can define as many different
Holds based on the business needs of the user/ company. <o:p></o:p></div>
<div class="MsoNormal">
User can not apply a hold if the order has been pick
released. <o:p></o:p></div>
<div class="MsoNormal">
Types of Holds in Order Management <o:p></o:p></div>
<div class="MsoNormal">
<b>Credit Check Hold<o:p></o:p></b></div>
<div class="MsoNormal">
Order Entry performs
an automatic credit check on the active customers, based on credit rules and
credit limits defined by the user in your system. You can set credit limits for
a total of all the customer's orders and of individual order amounts.<o:p></o:p></div>
<div class="MsoNormal">
<b>General Services
Administration (GSA) Violation Hold <o:p></o:p></b></div>
<div class="MsoNormal">
The GSA hold
ensures that a specific group of customers always receives the best pricing. <o:p></o:p></div>
<div class="MsoNormal">
<b>Configurations Holds<o:p></o:p></b></div>
<div class="MsoNormal">
If the
configuration is invalid this hold will be applied on the order to prevent
further processing.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymousnoreply@blogger.com1tag:blogger.com,1999:blog-6116416974602632170.post-14192176448758702072015-09-20T23:36:00.004-07:002015-09-20T23:36:42.311-07:00How to progress Errored workflow using back end api<div dir="ltr" style="text-align: left;" trbidi="on">
DECLARE<br />
CURSOR c1<br />
IS<br />
SELECT c.INSTANCE_LABEL,a.line_id<br />
FROM oe_order_lines_all a,<br />
apps.wf_item_activity_statuses b,<br />
apps.wf_process_activities c<br />
WHERE header_id = 602953547<br />
and b.item_key = to_char(a.line_id)<br />
and b.item_type ='OEOL'<br />
and b.activity_status='ERROR'<br />
and b.process_activity = c.instance_id;<br />
<br />
BEGIN<br />
FOR c1_rec IN c1<br />
LOOP<br />
wf_engine.handleerror (<br />
'OEOL',<br />
TO_CHAR (c1_rec.line_id),<br />
C1_REC.INSTANCE_LABEL,<br />
'RETRY',<br />
NULL<br />
);<br />
END LOOP;<br />
commit;<br />
EXCEPTION<br />
WHEN OTHERS<br />
THEN<br />
DBMS_OUTPUT.put_line (SQLERRM);<br />
END;</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-16094005220278334192015-07-22T09:12:00.003-07:002015-07-22T09:12:32.626-07:00How to release the Hold automatically when it reaches the hold until date<div dir="ltr" style="text-align: left;" trbidi="on">
If any of the user enters the Hold Until date while applying the Hold then the hold should be released automatically when it reaches to the Hold Until Date. <div>
<br /></div>
<div>
The below concurrent program should be scheduled based on the requirement. So that the program will check are there any holds which are reached hold until date and ready to release the holds. </div>
<div>
<br /></div>
<div>
Concurrent Program Name : Release Expired Hold</div>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-44485851914500544122015-03-13T10:08:00.004-07:002015-03-13T10:08:53.013-07:00How to raise business event manually using script<div dir="ltr" style="text-align: left;" trbidi="on">
DECLARE<br />
l_event_name VARCHAR2 (240)<br />
:= 'oracle.apps.ont.genesis.outbound.update';<br />
l_event_parameter_list wf_parameter_list_t := wf_parameter_list_t ();<br />
<br />
BEGIN<br />
wf_event.addparametertolist (<br />
p_name=> 'HEADER_ID',<br />
p_value=> '96567456745',<br />
p_parameterlist=> l_event_parameter_list<br />
);<br />
wf_event.addparametertolist (<br />
p_name=> 'LINE_ID',<br />
p_value=> '865875768',<br />
p_parameterlist=> l_event_parameter_list<br />
);<br />
wf_event.addparametertolist (<br />
p_name=> 'HOLD_SOURCE_ID',<br />
p_value=>'54326456',<br />
p_parameterlist=> l_event_parameter_list<br />
);<br />
wf_event.addparametertolist (<br />
p_name=> 'CHANGE_TYPE',<br />
p_value=> 'APPLY',<br />
p_parameterlist=> l_event_parameter_list<br />
);<br />
<br />
BEGIN<br />
wf_event.RAISE (<br />
p_event_name=> l_event_name,<br />
p_event_key=> SYS_GUID (),<br />
p_parameters=> l_event_parameter_list<br />
);<br />
EXCEPTION<br />
WHEN OTHERS<br />
THEN<br />
DBMS_OUTPUT.put_line (<br />
' Unexpected Error : '<br />
|| SUBSTR (SQLERRM, 1, 250)<br />
);<br />
END;<br />
<br />
<br />
COMMIT;<br />
l_event_parameter_list.DELETE;<br />
EXCEPTION<br />
WHEN OTHERS<br />
THEN<br />
DBMS_OUTPUT.put_line (<br />
' Unexpected Error in main block : '<br />
|| SUBSTR (SQLERRM, 1, 250)<br />
);<br />
END;<br />
<div>
<br /></div>
</div>
Anonymousnoreply@blogger.com2tag:blogger.com,1999:blog-6116416974602632170.post-74374859104611750282015-01-08T10:25:00.001-08:002015-01-08T10:25:24.831-08:00Concurrent Request Status Codes<div dir="ltr"><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><b><u><span style="color:blue;font-family:Arial,sans-serif;font-size:11pt">Concurrent Request Status Codes:</span></u></b></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><br></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><b><span style="font-family:'Courier New';font-size:8pt">SELECT</span></b><span style="font-family:'Courier New';font-size:8pt"> LOOKUP_CODE STATUS_CODE, MEANING<br> <b>FROM</b> FND_LOOKUP_VALUES<br> <b>WHERE</b> LOOKUP_TYPE = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'CP_STATUS_CODE'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> ENABLED_FLAG = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'Y'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> VIEW_APPLICATION_ID = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">0</span><span style="font-family:'Courier New';font-size:8pt"><br><b>ORDER</b> <b>BY</b> LOOKUP_CODE;</span></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><br></div><table border="0" cellpadding="0" cellspacing="0" class="" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px;border-collapse:collapse;width:187px"><tbody><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt;background:rgb(102,0,102)"><div align="center" class="MsoNormal" style="text-align:center"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">STATUS_CODE</span></b></div></td><td nowrap valign="bottom" width="91" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:67.95pt;background:rgb(102,0,102)"><div class="MsoNormal"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">MEANING</span></b></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">A</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Waiting</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">B</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Resuming</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">C</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">D</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Cancelled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">E</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Error</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">G</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Warning</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">H</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">On Hold</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">I</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">M</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">No Manager</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">P</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Scheduled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">Q</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Standby</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">R</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">S</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Suspended</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">T</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Terminating</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">U</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Disabled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">W</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Paused</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">X</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Terminated</span></div></td></tr><tr style="height:12pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:12pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">Z</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:12pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Waiting</span></div></td></tr></tbody></table><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><br></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><b><u><span style="color:blue;font-family:Arial,sans-serif;font-size:11pt">Concurrent Request Phase Codes:</span></u></b></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><br></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><b><span style="font-family:'Courier New';font-size:8pt">SELECT</span></b><span style="font-family:'Courier New';font-size:8pt"> LOOKUP_CODE PHASE_CODE, MEANING<br> <b>FROM</b> FND_LOOKUP_VALUES<br> <b>WHERE</b> LOOKUP_TYPE = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'CP_PHASE_CODE'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> ENABLED_FLAG = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'Y'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> VIEW_APPLICATION_ID = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">0</span><span style="font-family:'Courier New';font-size:8pt"><br><b>ORDER</b> <b>BY</b> PHASE_CODE;</span></div><div class="MsoNormal" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px"><br></div><table border="0" cellpadding="0" cellspacing="0" class="" style="font-family:Cousine;font-size:13px;line-height:18.4799995422363px;border-collapse:collapse;width:140px"><tbody><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt;background:rgb(102,0,102)"><div align="center" class="MsoNormal" style="text-align:center"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">STATUS_CODE</span></b></div></td><td nowrap valign="bottom" width="57" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:43pt;background:rgb(102,0,102)"><div class="MsoNormal"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">MEANING</span></b></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">C</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Completed</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">I</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Inactive</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">P</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Pending</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">R</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Running</span></div></td></tr></tbody></table></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-42715519226103315462014-12-15T08:42:00.004-08:002014-12-15T08:42:46.307-08:00How to find the inbound and out bound mailer details<div dir="ltr" style="text-align: left;" trbidi="on">
SELECT b.component_name,<br />
c.parameter_name,<br />
a.parameter_value<br />
FROM apps.fnd_svc_comp_param_vals a,<br />
apps.fnd_svc_components b,<br />
apps.fnd_svc_comp_params_b c<br />
WHERE b.component_id = a.component_id<br />
AND b.component_type = c.component_type<br />
AND c.parameter_id = a.parameter_id<br />
AND c.encrypted_flag = 'N'<br />
AND b.component_name like '%Mailer%'<br />
AND c.parameter_name in ('INBOUND_SERVER','OUTBOUND_SERVER', 'REPLYTO')<br />
ORDER BY c.parameter_name;</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-23543492817948651082014-11-23T22:27:00.001-08:002014-11-23T22:27:56.118-08:00Concurrent Request Status and Phase Codes<div dir="ltr"><h3 class="" itemprop="name" style="margin:0.75em 0px 0px;font-weight:normal;font-stretch:normal;font-size:22px;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif">Concurrent Request Status and Phase Codes</h3><div class="" style="line-height:1.6;margin:0px 0px 1.5em;font-size:11px;font-family:Cousine"><div class=""></div></div><div class="" id="post-body-5524492864851566198" itemprop="description articleBody" style="width:520px;font-size:13px;line-height:1.4;font-family:Cousine"><div dir="ltr"><div class="MsoNormal"></div><div class="MsoNormal"><b><u><span style="color:blue;font-family:Arial,sans-serif;font-size:11pt">Concurrent Request Status Codes:</span></u></b></div><div class="MsoNormal"><br></div><div class="MsoNormal"><b><span style="font-family:'Courier New';font-size:8pt">SELECT</span></b><span style="font-family:'Courier New';font-size:8pt"> LOOKUP_CODE STATUS_CODE, MEANING<br> <b>FROM</b> FND_LOOKUP_VALUES<br> <b>WHERE</b> LOOKUP_TYPE = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'CP_STATUS_CODE'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> ENABLED_FLAG = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'Y'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> VIEW_APPLICATION_ID = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">0</span><span style="font-family:'Courier New';font-size:8pt"><br><b>ORDER</b> <b>BY</b> LOOKUP_CODE;</span></div><div class="MsoNormal"><br></div><table border="0" cellpadding="0" cellspacing="0" class="" style="border-collapse:collapse;width:187px"><tbody><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt;background:rgb(102,0,102)"><div align="center" class="MsoNormal" style="text-align:center"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">STATUS_CODE</span></b></div></td><td nowrap valign="bottom" width="91" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:67.95pt;background:rgb(102,0,102)"><div class="MsoNormal"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">MEANING</span></b></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">A</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Waiting</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">B</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Resuming</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">C</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">D</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Cancelled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">E</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Error</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">G</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Warning</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">H</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">On Hold</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">I</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">M</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">No Manager</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">P</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Scheduled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">Q</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Standby</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">R</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Normal</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">S</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Suspended</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">T</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Terminating</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">U</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Disabled</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">W</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Paused</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">X</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Terminated</span></div></td></tr><tr style="height:12pt"><td nowrap valign="bottom" width="96" style="border:1pt solid windowtext;height:12pt;padding:0in 5.4pt;width:72.3pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">Z</span></div></td><td nowrap valign="bottom" width="91" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:12pt;padding:0in 5.4pt;width:67.95pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt"> Waiting</span></div></td></tr></tbody></table><div class="MsoNormal"><br></div><div class="MsoNormal"><b><u><span style="color:blue;font-family:Arial,sans-serif;font-size:11pt">Concurrent Request Phase Codes:</span></u></b></div><div class="MsoNormal"><br></div><div class="MsoNormal"><b><span style="font-family:'Courier New';font-size:8pt">SELECT</span></b><span style="font-family:'Courier New';font-size:8pt"> LOOKUP_CODE PHASE_CODE, MEANING<br> <b>FROM</b> FND_LOOKUP_VALUES<br> <b>WHERE</b> LOOKUP_TYPE = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'CP_PHASE_CODE'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> ENABLED_FLAG = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">'Y'</span><span style="font-family:'Courier New';font-size:8pt"><br> <b>AND</b> VIEW_APPLICATION_ID = </span><span style="color:rgb(0,0,240);font-family:'Courier New';font-size:8pt">0</span><span style="font-family:'Courier New';font-size:8pt"><br><b>ORDER</b> <b>BY</b> PHASE_CODE;</span></div><div class="MsoNormal"><br></div><table border="0" cellpadding="0" cellspacing="0" class="" style="border-collapse:collapse;width:140px"><tbody><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt;background:rgb(102,0,102)"><div align="center" class="MsoNormal" style="text-align:center"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">STATUS_CODE</span></b></div></td><td nowrap valign="bottom" width="57" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:43pt;background:rgb(102,0,102)"><div class="MsoNormal"><b><span style="color:white;font-family:Arial,sans-serif;font-size:8pt">MEANING</span></b></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">C</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Completed</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">I</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Inactive</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">P</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Pending</span></div></td></tr><tr style="height:11.25pt"><td nowrap valign="bottom" width="83" style="border:1pt solid windowtext;height:11.25pt;padding:0in 5.4pt;width:62pt"><div align="center" class="MsoNormal" style="text-align:center"><span style="font-family:Arial,sans-serif;font-size:8pt">R</span></div></td><td nowrap valign="bottom" width="57" style="border-style:none solid solid none;border-bottom-color:windowtext;border-bottom-width:1pt;border-right-color:windowtext;border-right-width:1pt;height:11.25pt;padding:0in 5.4pt;width:43pt"><div class="MsoNormal"><span style="font-family:Arial,sans-serif;font-size:8pt">Running</span></div></td></tr></tbody></table></div></div></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-29666647526950196752014-11-04T01:19:00.003-08:002014-11-04T01:19:12.276-08:00checking the Environment Variable from back end query<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="sql" style="-webkit-box-shadow: rgba(0, 0, 0, 0) 0px 0px 0px !important; background-attachment: initial !important; background-clip: initial !important; background-image: initial !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-bottom-left-radius: 0px !important; border-bottom-right-radius: 0px !important; border-top-left-radius: 0px !important; border-top-right-radius: 0px !important; border: none !important; box-shadow: rgba(0, 0, 0, 0) 0px 0px 0px !important; clear: none !important; color: #110000; font-size: 12px; font-stretch: inherit; line-height: 16px !important; overflow: visible !important; padding: 0px 4px !important; vertical-align: baseline; width: auto !important; word-wrap: break-word;"><span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span> variable_name<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">,</span>
<span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">VALUE</span>
<span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">FROM</span> apps<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">.</span>fnd_env_context
<span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">WHERE</span> concurrent_process_id <span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">=</span>
<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span> <span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">MAX</span><span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">(</span>concurrent_process_id<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">)</span> <span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">FROM</span> apps<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">.</span>fnd_env_context
<span style="border: 0px; color: #66cc66; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">)</span>
<span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">ORDER</span> <span style="border: 0px; color: #993333; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: bold; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">BY</span> variable_name;</pre>
</div>
Anonymousnoreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-76583895702542874102014-07-16T06:44:00.001-07:002014-07-16T06:44:22.996-07:00To Find Latest Query Executing/Running in Database for Specific Concurrent Request<div dir="ltr"><h2 style="margin:0px 0px 1em;font-size:11px;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;color:rgb(0,0,0)">Find Latest Query Executing/Running in Database for Specific Concurrent Request</h2><span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px">If one concurrent request is running and you want to find currently which query of that request is running in session then you can run below query in toad or sql developer by putting request ifd of that concurrent request-</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <br></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"><br></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt">select</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> to_char(inst_id) rac_inst_id,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> to_char(sid) sid,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> to_char(serial#) serial#,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> sql_text</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt">from</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> apps.fnd_concurrent_requests fcr,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> gv$session vs,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> v$sqltext vq</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt">where</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> vs.process = fcr.os_process_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and vs.sql_address = vq.address</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcr.status_code = 'R'</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcr.phase_code = 'R'</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and request_id in</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> (select fcr.request_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> from (select /*+ index (fcr1 FND_CONCURRENT_REQUESTS_N3) */</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> fcr1.request_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> from fnd_concurrent_requests fcr1</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> where 1=1</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> start with fcr1.request_id = <strong>&request_id</strong></span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> connect by prior fcr1.request_id = fcr1.parent_request_id) x,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> fnd_concurrent_requests fcr,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> fnd_concurrent_programs fcp,</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> fnd_concurrent_programs_tl fcptl</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> where fcr.request_id = x.request_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcr.concurrent_program_id = fcp.concurrent_program_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcr.program_application_id = fcp.application_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcp.application_id = fcptl.application_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcp.concurrent_program_id = fcptl.concurrent_program_id</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt"> and fcptl.language = 'US')</span></div><div class="MsoNormal" style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px;margin:0in 0in 0pt"> <span style="color:black;font-family:Verdana,sans-serif;font-size:10pt">Order By Serial#;</span></div><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px">This will be very useful for debugging purposes means we can derive what part of code is taking time or where program got stuck and for other purposes.</span><br> </div> Subhashhttp://www.blogger.com/profile/04462739867501945031noreply@blogger.com0tag:blogger.com,1999:blog-6116416974602632170.post-69512729304472542302014-07-16T06:43:00.001-07:002014-07-16T06:43:09.892-07:00SQL Query to Find Scheduled Concurrent Programs in System<div dir="ltr"><div><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="line-height:18.479999542236328px">SQL Query to Find Scheduled Concurrent Programs in System</span></font><br></div><div><font face="Arial, Tahoma, Helvetica, FreeSans, sans-serif"><span style="line-height:18.479999542236328px"><br> </span></font></div><span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px">SELECT fcr.request_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fcpt.user_concurrent_program_name|| NVL2(fcr.description, ' (' || fcr.description || ')', NULL) conc_prog</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fu.user_name requestor</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fu.description requested_by</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fu.email_address</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , frt.responsibility_name requested_by_resp</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , trim(fl.meaning) status</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fcr.phase_code</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fcr.status_code</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fcr.argument_text "PARAMETERS"</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , TO_CHAR(fcr.request_date, 'DD-MON-YYYY HH24:MI:SS') requested</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , TO_CHAR(fcr.requested_start_date, 'DD-MON-YYYY HH24:MI:SS') requested_start </span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , TO_CHAR((fcr.requested_start_date), 'HH24:MI:SS') start_time</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , DECODE(fcr.hold_flag, 'Y', 'Yes', 'N', 'No') on_hold</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , CASE</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> WHEN fcr.hold_flag = 'Y'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> Then Substr(</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> fu.description</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , 0</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , 40</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> )</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> END last_update_by</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , CASE</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> WHEN fcr.hold_flag = 'Y'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> THEN fcr.last_update_date</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> END last_update_date</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fcr.increment_dates</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , CASE WHEN fcrc.CLASS_INFO IS NULL THEN</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'Yes: ' || TO_CHAR(fcr.requested_start_date, 'DD-MON-YYYY HH24:MI:SS')</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> ELSE</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'n/a'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> END run_once</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , CASE WHEN fcrc.class_type = 'P' THEN</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'Repeat every ' ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> substr(fcrc.class_info, 1, instr(fcrc.class_info, ':') - 1) ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, instr(fcrc.class_info, ':', 1, 1) + 1, 1),</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'N', ' minutes',</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'M', ' months',</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'H', ' hours',</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'D', ' days') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, instr(fcrc.class_info, ':', 1, 2) + 1, 1),</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'S', ' from the start of the prior run',</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'C', ' from the completion of the prior run')</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> ELSE</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'n/a'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> END set_days_of_week</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , CASE WHEN fcrc.class_type = 'S' AND instr(substr(fcrc.class_info, 33),'1',1) > 0 THEN</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'Days of week: ' ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 33, 1), '1', 'Sun, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 34, 1), '1', 'Mon, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 35, 1), '1', 'Tue, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 36, 1), '1', 'Wed, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 37, 1), '1', 'Thu, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 38, 1), '1', 'Fri, ') ||</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> decode(substr(fcrc.class_info, 39, 1), '1', 'Sat ')</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> ELSE</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> 'n/a'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> end days_of_week </span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> FROM fnd_concurrent_requests fcr</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_user fu</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_concurrent_programs fcp</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_concurrent_programs_tl fcpt</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_printer_styles_tl fpst</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_conc_release_classes fcrc</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_responsibility_tl frt</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> , fnd_lookups fl</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> WHERE fcp.application_id = fcpt.application_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.requested_by = fu.user_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.concurrent_program_id = fcp.concurrent_program_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.program_application_id = fcp.application_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.concurrent_program_id = fcpt.concurrent_program_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.responsibility_id = frt.responsibility_id</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.print_style = fpst.printer_style_name(+)</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.release_class_id = fcrc.release_class_id(+)</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.status_code = fl.lookup_code</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fl.lookup_type = 'CP_STATUS_CODE'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND fcr.phase_code = 'P'</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> AND 1=1</span><br style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px"> <span style="font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:18.479999542236328px">Order By Fu.Description, Fcr.Requested_Start_Date Asc;</span><br></div> Subhashhttp://www.blogger.com/profile/04462739867501945031noreply@blogger.com0