VIEW: APPS.WSH_CC_REQUEST_SETUPS_V

Source

View Text - Preformatted

SELECT wrs.rowid row_id ,wrs.cc_request_sequence_id ,wrs.master_organization_id ,hou1.name master_organization_name ,wrs.organization_id ,hou2.name organization_name ,wrs.application_id ,fap.application_name ,wrs.application_user_id ,fu.user_name ,wrs.request_type_code ,wrs.request_version ,wrs.request_language ,wrs.request_date_format ,wrs.request_deployment_mode ,wrs.request_handler ,wrs.request_output_type ,wrs.additional_ece_country_check ,wrs.request_include_flag ,wrs.eccn_catg_set_id ,cat1.category_set_name ,wrs.hts_catg_set_id ,cat2.category_set_name ,wrs.addl_catg_set_id ,cat3.category_set_name ,wrs.creation_date ,wrs.created_by ,wrs.last_update_date ,wrs.last_updated_by ,wrs.last_update_login from wsh_cc_request_setups wrs ,hr_organization_units hou1 ,hr_organization_units hou2 ,fnd_user fu ,mtl_category_sets cat1 ,mtl_category_sets cat2 ,mtl_category_sets cat3 ,fnd_application_tl fap WHERE wrs.master_organization_id=hou1.organization_id and wrs.organization_id=hou2.organization_id and wrs.application_user_id=fu.user_id and wrs.eccn_catg_set_id = cat1.category_set_id(+) and wrs.hts_catg_set_id = cat2.category_set_id(+) and wrs.addl_catg_set_id = cat3.category_set_id(+) and wrs.application_id = fap.application_id union all select wrs.rowid row_id ,wrs.cc_request_sequence_id ,wrs.master_organization_id ,hou1.name master_organization_name ,wrs.organization_id ,hou2.name organization_name ,wrs.application_id ,fap.application_name ,wrs.application_user_id ,to_char(null) user_name ,wrs.request_type_code ,wrs.request_version ,wrs.request_language ,wrs.request_date_format ,wrs.request_deployment_mode ,wrs.request_handler ,wrs.request_output_type ,wrs.additional_ece_country_check ,wrs.request_include_flag ,wrs.eccn_catg_set_id ,cat1.category_set_name ,wrs.hts_catg_set_id ,cat2.category_set_name ,wrs.addl_catg_set_id ,cat3.category_set_name ,wrs.creation_date ,wrs.created_by ,wrs.last_update_date ,wrs.last_updated_by ,wrs.last_update_login from wsh_cc_request_setups wrs ,hr_organization_units hou1 ,hr_organization_units hou2 ,mtl_category_sets cat1 ,mtl_category_sets cat2 ,mtl_category_sets cat3 ,fnd_application_tl fap where wrs.master_organization_id=hou1.organization_id and wrs.organization_id=hou2.organization_id and wrs.application_user_id is null and wrs.eccn_catg_set_id = cat1.category_set_id(+) and wrs.hts_catg_set_id = cat2.category_set_id(+) and wrs.addl_catg_set_id = cat3.category_set_id(+) and wrs.application_id = fap.application_id union all select wrs.rowid row_id ,wrs.cc_request_sequence_id ,wrs.master_organization_id ,hou1.name master_organization_name ,wrs.organization_id ,to_char(null) organization_name ,wrs.application_id ,fap.application_name ,wrs.application_user_id ,fu.user_name ,wrs.request_type_code ,wrs.request_version ,wrs.request_language ,wrs.request_date_format ,wrs.request_deployment_mode ,wrs.request_handler ,wrs.request_output_type ,wrs.additional_ece_country_check ,wrs.request_include_flag ,wrs.eccn_catg_set_id ,cat1.category_set_name ,wrs.hts_catg_set_id ,cat2.category_set_name ,wrs.addl_catg_set_id ,cat3.category_set_name ,wrs.creation_date ,wrs.created_by ,wrs.last_update_date ,wrs.last_updated_by ,wrs.last_update_login from wsh_cc_request_setups wrs ,hr_organization_units hou1 ,fnd_user fu ,mtl_category_sets cat1 ,mtl_category_sets cat2 ,mtl_category_sets cat3 ,fnd_application_tl fap where wrs.master_organization_id=hou1.organization_id and wrs.organization_id is null and wrs.application_user_id = fu.user_id and wrs.eccn_catg_set_id = cat1.category_set_id(+) and wrs.hts_catg_set_id = cat2.category_set_id(+) and wrs.addl_catg_set_id = cat3.category_set_id(+) and wrs.application_id = fap.application_id union all select wrs.rowid row_id ,wrs.cc_request_sequence_id ,wrs.master_organization_id ,hou1.name master_organization_name ,wrs.organization_id ,to_char(null) organization_name ,wrs.application_id ,fap.application_name ,wrs.application_user_id ,to_char(null) user_name ,wrs.request_type_code ,wrs.request_version ,wrs.request_language ,wrs.request_date_format ,wrs.request_deployment_mode ,wrs.request_handler ,wrs.request_output_type ,wrs.additional_ece_country_check ,wrs.request_include_flag ,wrs.eccn_catg_set_id ,cat1.category_set_name ,wrs.hts_catg_set_id ,cat2.category_set_name ,wrs.addl_catg_set_id ,cat3.category_set_name ,wrs.creation_date ,wrs.created_by ,wrs.last_update_date ,wrs.last_updated_by ,wrs.last_update_login from wsh_cc_request_setups wrs ,hr_organization_units hou1 ,mtl_category_sets cat1 ,mtl_category_sets cat2 ,mtl_category_sets cat3 ,fnd_application_tl fap where wrs.master_organization_id=hou1.organization_id and wrs.organization_id is null and wrs.application_user_id is null and wrs.eccn_catg_set_id = cat1.category_set_id(+) and wrs.hts_catg_set_id = cat2.category_set_id(+) and wrs.addl_catg_set_id = cat3.category_set_id(+) and wrs.application_id = fap.application_id

View Text - HTML Formatted

SELECT WRS.ROWID ROW_ID
, WRS.CC_REQUEST_SEQUENCE_ID
, WRS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WRS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WRS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WRS.APPLICATION_USER_ID
, FU.USER_NAME
, WRS.REQUEST_TYPE_CODE
, WRS.REQUEST_VERSION
, WRS.REQUEST_LANGUAGE
, WRS.REQUEST_DATE_FORMAT
, WRS.REQUEST_DEPLOYMENT_MODE
, WRS.REQUEST_HANDLER
, WRS.REQUEST_OUTPUT_TYPE
, WRS.ADDITIONAL_ECE_COUNTRY_CHECK
, WRS.REQUEST_INCLUDE_FLAG
, WRS.ECCN_CATG_SET_ID
, CAT1.CATEGORY_SET_NAME
, WRS.HTS_CATG_SET_ID
, CAT2.CATEGORY_SET_NAME
, WRS.ADDL_CATG_SET_ID
, CAT3.CATEGORY_SET_NAME
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.LAST_UPDATE_LOGIN
FROM WSH_CC_REQUEST_SETUPS WRS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_USER FU
, MTL_CATEGORY_SETS CAT1
, MTL_CATEGORY_SETS CAT2
, MTL_CATEGORY_SETS CAT3
, FND_APPLICATION_TL FAP
WHERE WRS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WRS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WRS.APPLICATION_USER_ID=FU.USER_ID
AND WRS.ECCN_CATG_SET_ID = CAT1.CATEGORY_SET_ID(+)
AND WRS.HTS_CATG_SET_ID = CAT2.CATEGORY_SET_ID(+)
AND WRS.ADDL_CATG_SET_ID = CAT3.CATEGORY_SET_ID(+)
AND WRS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WRS.ROWID ROW_ID
, WRS.CC_REQUEST_SEQUENCE_ID
, WRS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WRS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WRS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WRS.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WRS.REQUEST_TYPE_CODE
, WRS.REQUEST_VERSION
, WRS.REQUEST_LANGUAGE
, WRS.REQUEST_DATE_FORMAT
, WRS.REQUEST_DEPLOYMENT_MODE
, WRS.REQUEST_HANDLER
, WRS.REQUEST_OUTPUT_TYPE
, WRS.ADDITIONAL_ECE_COUNTRY_CHECK
, WRS.REQUEST_INCLUDE_FLAG
, WRS.ECCN_CATG_SET_ID
, CAT1.CATEGORY_SET_NAME
, WRS.HTS_CATG_SET_ID
, CAT2.CATEGORY_SET_NAME
, WRS.ADDL_CATG_SET_ID
, CAT3.CATEGORY_SET_NAME
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.LAST_UPDATE_LOGIN
FROM WSH_CC_REQUEST_SETUPS WRS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, MTL_CATEGORY_SETS CAT1
, MTL_CATEGORY_SETS CAT2
, MTL_CATEGORY_SETS CAT3
, FND_APPLICATION_TL FAP
WHERE WRS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WRS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WRS.APPLICATION_USER_ID IS NULL
AND WRS.ECCN_CATG_SET_ID = CAT1.CATEGORY_SET_ID(+)
AND WRS.HTS_CATG_SET_ID = CAT2.CATEGORY_SET_ID(+)
AND WRS.ADDL_CATG_SET_ID = CAT3.CATEGORY_SET_ID(+)
AND WRS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WRS.ROWID ROW_ID
, WRS.CC_REQUEST_SEQUENCE_ID
, WRS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WRS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WRS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WRS.APPLICATION_USER_ID
, FU.USER_NAME
, WRS.REQUEST_TYPE_CODE
, WRS.REQUEST_VERSION
, WRS.REQUEST_LANGUAGE
, WRS.REQUEST_DATE_FORMAT
, WRS.REQUEST_DEPLOYMENT_MODE
, WRS.REQUEST_HANDLER
, WRS.REQUEST_OUTPUT_TYPE
, WRS.ADDITIONAL_ECE_COUNTRY_CHECK
, WRS.REQUEST_INCLUDE_FLAG
, WRS.ECCN_CATG_SET_ID
, CAT1.CATEGORY_SET_NAME
, WRS.HTS_CATG_SET_ID
, CAT2.CATEGORY_SET_NAME
, WRS.ADDL_CATG_SET_ID
, CAT3.CATEGORY_SET_NAME
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.LAST_UPDATE_LOGIN
FROM WSH_CC_REQUEST_SETUPS WRS
, HR_ORGANIZATION_UNITS HOU1
, FND_USER FU
, MTL_CATEGORY_SETS CAT1
, MTL_CATEGORY_SETS CAT2
, MTL_CATEGORY_SETS CAT3
, FND_APPLICATION_TL FAP
WHERE WRS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WRS.ORGANIZATION_ID IS NULL
AND WRS.APPLICATION_USER_ID = FU.USER_ID
AND WRS.ECCN_CATG_SET_ID = CAT1.CATEGORY_SET_ID(+)
AND WRS.HTS_CATG_SET_ID = CAT2.CATEGORY_SET_ID(+)
AND WRS.ADDL_CATG_SET_ID = CAT3.CATEGORY_SET_ID(+)
AND WRS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WRS.ROWID ROW_ID
, WRS.CC_REQUEST_SEQUENCE_ID
, WRS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WRS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WRS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WRS.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WRS.REQUEST_TYPE_CODE
, WRS.REQUEST_VERSION
, WRS.REQUEST_LANGUAGE
, WRS.REQUEST_DATE_FORMAT
, WRS.REQUEST_DEPLOYMENT_MODE
, WRS.REQUEST_HANDLER
, WRS.REQUEST_OUTPUT_TYPE
, WRS.ADDITIONAL_ECE_COUNTRY_CHECK
, WRS.REQUEST_INCLUDE_FLAG
, WRS.ECCN_CATG_SET_ID
, CAT1.CATEGORY_SET_NAME
, WRS.HTS_CATG_SET_ID
, CAT2.CATEGORY_SET_NAME
, WRS.ADDL_CATG_SET_ID
, CAT3.CATEGORY_SET_NAME
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.LAST_UPDATE_LOGIN
FROM WSH_CC_REQUEST_SETUPS WRS
, HR_ORGANIZATION_UNITS HOU1
, MTL_CATEGORY_SETS CAT1
, MTL_CATEGORY_SETS CAT2
, MTL_CATEGORY_SETS CAT3
, FND_APPLICATION_TL FAP
WHERE WRS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WRS.ORGANIZATION_ID IS NULL
AND WRS.APPLICATION_USER_ID IS NULL
AND WRS.ECCN_CATG_SET_ID = CAT1.CATEGORY_SET_ID(+)
AND WRS.HTS_CATG_SET_ID = CAT2.CATEGORY_SET_ID(+)
AND WRS.ADDL_CATG_SET_ID = CAT3.CATEGORY_SET_ID(+)
AND WRS.APPLICATION_ID = FAP.APPLICATION_ID