Skip to main content

Query to get the details of a submitted concurrent program

Query to get the details of a submitted concurrent program

--------------------------------------------------------------------------------------------------------------------------------------
/* Formatted on 2015/03/17 16:40 (Formatter Plus v4.8.8) */
SELECT   fcp.user_concurrent_program_name program_name,
         fcp.concurrent_program_name short_name, fcr.request_id request_id,
         frv.responsibility_name responsibility_name,
         fcr.request_date request_date, fu.user_name request_submitted_by,
         DECODE (fcr.status_code,
                 'A', 'Waiting',
                 'B', 'Resuming',
                 'C', 'Normal',
                 'D', 'Cancelled',
                 'E', 'Error',
                 'F', 'Scheduled',
                 'G', 'Warning',
                 'H', 'On Hold',
                 'I', 'Normal',
                 'M', 'No Manager',
                 'Q', 'Standby',
                 'R', 'Normal',
                 'S', 'Suspended',
                 'T', 'Terminating',
                 'U', 'Disabled',
                 'W', 'Paused',
                 'X', 'Terminated',
                 'Z', 'Waiting'
                ) status_code,
         DECODE (fcr.phase_code,
                 'C', 'Completed',
                 'I', 'Inactive',
                 'P', 'Pending',
                 'R', 'Running'
                ) phase_code,
         fcr.actual_start_date, fcr.actual_completion_date,
         fcr.completion_text completion_status, fcr.logfile_name,
         fcr.outfile_name, fcr.argument1 parameter1, fcr.argument2 parameter2,
         fcr.argument3 parameter3, fcr.argument4 parameter4,
         fcr.argument5 parameter5, fcr.argument6 parameter6,
         fcr.argument7 parameter7, fcr.argument8 parameter8,
         fcr.argument9 parameter9, fcr.argument10 parameter10,
         fcr.argument11 parameter11, fcr.argument12 parameter12,
         fcr.argument13 parameter13, fcr.argument14 parameter14,
         fcr.argument15 parameter15, fcr.argument16 parameter16,
         fcr.argument17 parameter17, fcr.argument18 parameter18,
         fcr.argument19 parameter19, fcr.argument20 parameter20
    FROM apps.fnd_concurrent_programs_vl fcp,
         apps.fnd_concurrent_requests fcr,
         apps.fnd_responsibility_vl frv,
         apps.fnd_user fu
   WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
     AND frv.responsibility_id = fcr.responsibility_id
     AND fcr.requested_by = fu.user_id
--and fcr.request_id = 156574443    --use this condition to check detaiols for particular request
     AND fcp.user_concurrent_program_name = 'XYZ'    --Enter program name here
ORDER BY fcr.request_date;


--------------------------------------------------------------------------------------------------------------------------------------

Comments

Post a Comment

Popular posts from this blog

FND_PROFILE API In Oracle Apps

 FND_PROFILE API In Oracle Apps --------------------------------------------------------------------------------------------------- FND_PROFILE API is used very frequently in oracle apps development. The major purpose of this API is to: ·                      Retrieve user profile values for the current run-time environment ·                      Set user profile values for the current run-time environment FND_PROFILE API has different procedures and functions which are most frequently used. Following are the brief explanation of them: 1. FND_PROFILE.PUT:  This can be used to put a value to the specified user profile option. Example:  FND_Profile.Put(‘PROFILE_NAME’, ‘New_Value’) FND_Profile.Put(’USERNAME’, Usr_Name) FND_Profile.Pu...
Post a Comment
Read more

PO Matching Setting in Purchase Order Shipment Line(2-way,3-way,4-way)

[PO] Matching Setting in Purchase Order Shipment Line Invoice matching can be set in five different areas of Oracle Purchasing: In the list below, a setting at any level will override the settings above it. 1. Oracle Purchasing Options a. Navigate to: Setup > Organizations > Purchasing Options b. Select Default Alternative Region 2. Supplier Information a. Navigate to: Supply Base > Suppliers b. Query on specific supplier c. Click on Open d. Select Receiving Alternative Region 3. Line Types a. Navigate to: Setup > Purchasing > Line Types b. In the Receipt Required field: Yes = 3-way, No = 2-way 4. Items a. Navigate to: Items > Master Items b. Query on specific item c. Select Purchasing Alternative Region d. In the Invoice Matching section: Yes = 3-way, No = 2-way 5. Purchase Order Shipments a. Navigate to: Purchase Orders > Purchase Orders b. Enter (header and) line information c. Click on Shipments button d. Select More Alternative Region Ramification of Invoice ...
Post a Comment
Read more

Query To get the SMTP Server Details for a database server

Query To get the SMTP Server Details for a database server -------------------------------------------------------------------------------------------------------------------------------------- select fscpv.parameter_value "SMTP Host Name"       --SMTP protocol uses default port number 25 for outgoing emails       ,25                    "SMTP Port Number"       ,fscpt.description   from fnd_svc_comp_params_tl fscpt       ,fnd_svc_comp_param_vals fscpv  where fscpt.parameter_id = fscpv.parameter_id    and fscpt.display_name = 'Outbound Server Name' --'Inbound Server Name'    and fscpt.language = 'US'; --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more