VIEW: APPS.FND_CONC_REQUESTS_FORM_V

Source

View Text - Preformatted

SELECT R.ROWID Row_ID, R.Request_ID, R.Phase_Code, R.Status_Code, R.Priority_Request_ID, R.Priority, R.Request_Date, R.Requested_By, R.Requested_Start_Date, R.Hold_Flag, R.Enforce_Seriality_Flag, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Implicit_Code, R.Update_Protected, R.Queue_Method_Code, R.Argument_Input_Method_Code, R.Oracle_Id, R.Program_Application_Id, R.Concurrent_Program_Id, R.Responsibility_Application_Id, R.Responsibility_Id, R.Number_Of_Arguments, R.Number_Of_Copies, R.Save_Output_Flag, R.Last_Update_Date, R.Last_Updated_By, R.Last_Update_Login, R.Printer, R.Print_Style, R.Print_Group, R.Request_Class_Application_Id, R.Concurrent_Request_Class_Id, R.Parent_Request_Id, R.Conc_Login_Id, R.Language_Id, R.Description, R.Req_Information, R.Resubmit_Interval, R.Resubmit_Interval_Unit_Code, R.Resubmit_Interval_Type_Code, R.Resubmit_Time, R.Resubmit_End_Date, R.Resubmitted, R.Controlling_Manager, R.Actual_Start_Date, R.Actual_Completion_Date, R.Completion_Text, R.Outcome_Product, R.Outcome_Code, R.Cpu_Seconds, R.Logical_Ios, R.Physical_Ios, R.Logfile_Name, R.Logfile_Node_Name, R.Outfile_Name, R.Outfile_Node_Name, R.Argument_Text, R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, R.Nls_Language, R.Nls_Territory, R.CRM_THRSHLD, R.CRM_TSTMP, R.CRITICAL, R.REQUEST_TYPE, R.ORACLE_PROCESS_ID, R.ORACLE_SESSION_ID, R.OS_PROCESS_ID, R.Print_Job_ID, R.OUTPUT_FILE_TYPE, R.RELEASE_CLASS_APP_ID, R.RELEASE_CLASS_ID, R.STALE_DATE, R.CANCEL_OR_HOLD, R.NOTIFY_ON_PP_ERROR, R.NLS_COMPLIANT, R.CD_ID, R.Request_Limit, R.CRM_Release_Date, R.Post_Request_Status, R.Completion_code, R.Increment_Dates, R.Restart, R.Enable_Trace, R.Resub_Count, R.NLS_Codeset, R.OFile_Size, R.LFile_Size, R.Stale, R.Security_Group_ID, CD.User_CD_NAME, PB.Concurrent_Program_Name Program_Short_Name, PB.Execution_Method_Code, PB.Queue_Method_Code FCP_Queue_Method_Code, PB.Queue_Control_Flag, PB.Run_Alone_Flag Run_Alone, PB.Enabled_Flag Enabled, PB.Srs_Flag Srs_Flag, Decode (R.Description, NULL, PT.User_Concurrent_Program_Name, R.Description||' ('||PT.User_Concurrent_Program_Name||')') Program, PT.User_Concurrent_Program_Name, PB.Printer_Name Fcp_Printer, PB.Output_Print_Style Fcp_Print_Style, PB.Required_Style Fcp_Required_Style, AB.Application_Short_Name, AT.Application_Name, U.User_Name Requestor, S.User_Printer_Style_Name User_Print_Style, Decode (R.Priority_Request_ID, R.Request_ID, NULL, R.Priority_Request_ID) Parent, L1.Meaning Resubmit_Interval_Unit, L2.Meaning Resubmit_Interval_Type, U2.User_Name Updated_By_Name, Fnd_Conc_Request_Pkg.Encode_Attribute_Order( PB.Srs_Flag, R.Requested_By, R.Responsibility_Id, R.Responsibility_Application_Id, R.Program_Application_Id, PB.Concurrent_Program_Name) attribute_order, Flt.description language, R.Org_Id, H.Name, cb.application_id sch_app_id, cb.release_class_id sch_id, cb.release_class_name sch_name, ct.description sch_description, cb.date1 sch_date1, cb.date2 sch_date2, cb.class_type sch_type, cb.class_info sch_curr_values, cb.owner_req_id sch_owner_req_id, 1 sch_exists, DECODE(cb.owner_req_id, NULL, 1, 0) sch_perm From Fnd_Application AB, Fnd_Application_TL AT, Fnd_Concurrent_Programs PB, Fnd_Concurrent_Programs_TL PT, Fnd_User U, Fnd_User U2, Fnd_Printer_styles_tl S, FND_LOOKUP_VALUES L1, FND_LOOKUP_VALUES L2, Fnd_Concurrent_Requests R, Fnd_Conflicts_Domain CD, Fnd_languages fl, Fnd_Languages_tl flt, FND_CONC_RELEASE_CLASSES CB, FND_CONC_RELEASE_CLASSES_TL CT, HR_ALL_ORGANIZATION_UNITS_TL H WHERE PB.Application_ID(+) = R.Program_Application_ID And PB.Concurrent_Program_ID(+) = R.Concurrent_Program_ID And PB.Application_ID = AB.Application_ID(+) And PB.Application_Id = PT.Application_Id(+) And PB.Concurrent_Program_Id = PT.Concurrent_Program_Id(+) And PT.Language(+) = userenv('LANG') And AB.Application_Id = AT.Application_Id(+) And AT.Language(+) = userenv('LANG') And U.User_ID(+) = R.Requested_By And U2.User_ID(+) = R.Last_Updated_By And S.Printer_Style_Name(+) = R.Print_Style And S.language(+) = userenv('LANG') And L1.Lookup_Code(+) = R.Resubmit_Interval_Unit_Code And L1.Lookup_Type(+) = 'CP_RESUBMIT_INTERVAL_UNIT' And L1.language(+) = userenv('LANG') And L1.View_Application_ID(+) = 0 And L1.Security_Group_ID(+) = 0 And L2.Lookup_Code(+) = R.Resubmit_Interval_Type_Code And L2.Lookup_Type(+) = 'CP_RESUBMIT_INTERVAL_TYPE' And L2.LANGUAGE(+) = userenv('LANG') And L2.View_Application_ID(+) = 0 And L2.Security_Group_ID(+) = 0 And CD.cd_id (+) = R.CD_ID AND R.RELEASE_CLASS_ID = cb.release_class_id(+) And R.Release_class_app_id = cb.application_id(+) And ct.language(+) = userenv('LANG') And R.Release_Class_ID = ct.release_class_id(+) And R.Release_class_app_id = ct.application_id(+) And fl.nls_language(+) = r.nls_language And fl.language_code = flt.language_code(+) And flt.language(+) = userenv('LANG') And R.Org_Id = H.Organization_ID (+) And H.Language(+) = userenv('LANG')

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.REQUEST_ID
, R.PHASE_CODE
, R.STATUS_CODE
, R.PRIORITY_REQUEST_ID
, R.PRIORITY
, R.REQUEST_DATE
, R.REQUESTED_BY
, R.REQUESTED_START_DATE
, R.HOLD_FLAG
, R.ENFORCE_SERIALITY_FLAG
, R.SINGLE_THREAD_FLAG
, R.HAS_SUB_REQUEST
, R.IS_SUB_REQUEST
, R.IMPLICIT_CODE
, R.UPDATE_PROTECTED
, R.QUEUE_METHOD_CODE
, R.ARGUMENT_INPUT_METHOD_CODE
, R.ORACLE_ID
, R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.RESPONSIBILITY_ID
, R.NUMBER_OF_ARGUMENTS
, R.NUMBER_OF_COPIES
, R.SAVE_OUTPUT_FLAG
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
, R.PRINTER
, R.PRINT_STYLE
, R.PRINT_GROUP
, R.REQUEST_CLASS_APPLICATION_ID
, R.CONCURRENT_REQUEST_CLASS_ID
, R.PARENT_REQUEST_ID
, R.CONC_LOGIN_ID
, R.LANGUAGE_ID
, R.DESCRIPTION
, R.REQ_INFORMATION
, R.RESUBMIT_INTERVAL
, R.RESUBMIT_INTERVAL_UNIT_CODE
, R.RESUBMIT_INTERVAL_TYPE_CODE
, R.RESUBMIT_TIME
, R.RESUBMIT_END_DATE
, R.RESUBMITTED
, R.CONTROLLING_MANAGER
, R.ACTUAL_START_DATE
, R.ACTUAL_COMPLETION_DATE
, R.COMPLETION_TEXT
, R.OUTCOME_PRODUCT
, R.OUTCOME_CODE
, R.CPU_SECONDS
, R.LOGICAL_IOS
, R.PHYSICAL_IOS
, R.LOGFILE_NAME
, R.LOGFILE_NODE_NAME
, R.OUTFILE_NAME
, R.OUTFILE_NODE_NAME
, R.ARGUMENT_TEXT
, R.ARGUMENT1
, R.ARGUMENT2
, R.ARGUMENT3
, R.ARGUMENT4
, R.ARGUMENT5
, R.ARGUMENT6
, R.ARGUMENT7
, R.ARGUMENT8
, R.ARGUMENT9
, R.ARGUMENT10
, R.ARGUMENT11
, R.ARGUMENT12
, R.ARGUMENT13
, R.ARGUMENT14
, R.ARGUMENT15
, R.ARGUMENT16
, R.ARGUMENT17
, R.ARGUMENT18
, R.ARGUMENT19
, R.ARGUMENT20
, R.ARGUMENT21
, R.ARGUMENT22
, R.ARGUMENT23
, R.ARGUMENT24
, R.ARGUMENT25
, R.NLS_LANGUAGE
, R.NLS_TERRITORY
, R.CRM_THRSHLD
, R.CRM_TSTMP
, R.CRITICAL
, R.REQUEST_TYPE
, R.ORACLE_PROCESS_ID
, R.ORACLE_SESSION_ID
, R.OS_PROCESS_ID
, R.PRINT_JOB_ID
, R.OUTPUT_FILE_TYPE
, R.RELEASE_CLASS_APP_ID
, R.RELEASE_CLASS_ID
, R.STALE_DATE
, R.CANCEL_OR_HOLD
, R.NOTIFY_ON_PP_ERROR
, R.NLS_COMPLIANT
, R.CD_ID
, R.REQUEST_LIMIT
, R.CRM_RELEASE_DATE
, R.POST_REQUEST_STATUS
, R.COMPLETION_CODE
, R.INCREMENT_DATES
, R.RESTART
, R.ENABLE_TRACE
, R.RESUB_COUNT
, R.NLS_CODESET
, R.OFILE_SIZE
, R.LFILE_SIZE
, R.STALE
, R.SECURITY_GROUP_ID
, CD.USER_CD_NAME
, PB.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME
, PB.EXECUTION_METHOD_CODE
, PB.QUEUE_METHOD_CODE FCP_QUEUE_METHOD_CODE
, PB.QUEUE_CONTROL_FLAG
, PB.RUN_ALONE_FLAG RUN_ALONE
, PB.ENABLED_FLAG ENABLED
, PB.SRS_FLAG SRS_FLAG
, DECODE (R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') PROGRAM
, PT.USER_CONCURRENT_PROGRAM_NAME
, PB.PRINTER_NAME FCP_PRINTER
, PB.OUTPUT_PRINT_STYLE FCP_PRINT_STYLE
, PB.REQUIRED_STYLE FCP_REQUIRED_STYLE
, AB.APPLICATION_SHORT_NAME
, AT.APPLICATION_NAME
, U.USER_NAME REQUESTOR
, S.USER_PRINTER_STYLE_NAME USER_PRINT_STYLE
, DECODE (R.PRIORITY_REQUEST_ID
, R.REQUEST_ID
, NULL
, R.PRIORITY_REQUEST_ID) PARENT
, L1.MEANING RESUBMIT_INTERVAL_UNIT
, L2.MEANING RESUBMIT_INTERVAL_TYPE
, U2.USER_NAME UPDATED_BY_NAME
, FND_CONC_REQUEST_PKG.ENCODE_ATTRIBUTE_ORDER( PB.SRS_FLAG
, R.REQUESTED_BY
, R.RESPONSIBILITY_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.PROGRAM_APPLICATION_ID
, PB.CONCURRENT_PROGRAM_NAME) ATTRIBUTE_ORDER
, FLT.DESCRIPTION LANGUAGE
, R.ORG_ID
, H.NAME
, CB.APPLICATION_ID SCH_APP_ID
, CB.RELEASE_CLASS_ID SCH_ID
, CB.RELEASE_CLASS_NAME SCH_NAME
, CT.DESCRIPTION SCH_DESCRIPTION
, CB.DATE1 SCH_DATE1
, CB.DATE2 SCH_DATE2
, CB.CLASS_TYPE SCH_TYPE
, CB.CLASS_INFO SCH_CURR_VALUES
, CB.OWNER_REQ_ID SCH_OWNER_REQ_ID
, 1 SCH_EXISTS
, DECODE(CB.OWNER_REQ_ID
, NULL
, 1
, 0) SCH_PERM
FROM FND_APPLICATION AB
, FND_APPLICATION_TL AT
, FND_CONCURRENT_PROGRAMS PB
, FND_CONCURRENT_PROGRAMS_TL PT
, FND_USER U
, FND_USER U2
, FND_PRINTER_STYLES_TL S
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_CONCURRENT_REQUESTS R
, FND_CONFLICTS_DOMAIN CD
, FND_LANGUAGES FL
, FND_LANGUAGES_TL FLT
, FND_CONC_RELEASE_CLASSES CB
, FND_CONC_RELEASE_CLASSES_TL CT
, HR_ALL_ORGANIZATION_UNITS_TL H
WHERE PB.APPLICATION_ID(+) = R.PROGRAM_APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID(+) = R.CONCURRENT_PROGRAM_ID
AND PB.APPLICATION_ID = AB.APPLICATION_ID(+)
AND PB.APPLICATION_ID = PT.APPLICATION_ID(+)
AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID(+)
AND PT.LANGUAGE(+) = USERENV('LANG')
AND AB.APPLICATION_ID = AT.APPLICATION_ID(+)
AND AT.LANGUAGE(+) = USERENV('LANG')
AND U.USER_ID(+) = R.REQUESTED_BY
AND U2.USER_ID(+) = R.LAST_UPDATED_BY
AND S.PRINTER_STYLE_NAME(+) = R.PRINT_STYLE
AND S.LANGUAGE(+) = USERENV('LANG')
AND L1.LOOKUP_CODE(+) = R.RESUBMIT_INTERVAL_UNIT_CODE
AND L1.LOOKUP_TYPE(+) = 'CP_RESUBMIT_INTERVAL_UNIT'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 0
AND L1.SECURITY_GROUP_ID(+) = 0
AND L2.LOOKUP_CODE(+) = R.RESUBMIT_INTERVAL_TYPE_CODE
AND L2.LOOKUP_TYPE(+) = 'CP_RESUBMIT_INTERVAL_TYPE'
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID(+) = 0
AND L2.SECURITY_GROUP_ID(+) = 0
AND CD.CD_ID (+) = R.CD_ID
AND R.RELEASE_CLASS_ID = CB.RELEASE_CLASS_ID(+)
AND R.RELEASE_CLASS_APP_ID = CB.APPLICATION_ID(+)
AND CT.LANGUAGE(+) = USERENV('LANG')
AND R.RELEASE_CLASS_ID = CT.RELEASE_CLASS_ID(+)
AND R.RELEASE_CLASS_APP_ID = CT.APPLICATION_ID(+)
AND FL.NLS_LANGUAGE(+) = R.NLS_LANGUAGE
AND FL.LANGUAGE_CODE = FLT.LANGUAGE_CODE(+)
AND FLT.LANGUAGE(+) = USERENV('LANG')
AND R.ORG_ID = H.ORGANIZATION_ID (+)
AND H.LANGUAGE(+) = USERENV('LANG')