VIEW: APPS.WSH_CC_SERVICE_SETUPS_V

Source

View Text - Preformatted

SELECT wss.rowid row_id ,wss.cc_service_sequence_id ,wss.master_organization_id ,hou1.name master_organization_name ,wss.organization_id ,hou2.name organization_name ,wss.application_id ,fap.application_name ,wss.application_user_id ,fu.user_name ,wss.service_type_code ,wss.service_version ,wss.service_handler ,wss.service_default_threshold ,wss.country_match_flag ,wss.red_flag ,wss.ship_from_country_scheme ,wss.ship_from_country_domain ,wss.ship_to_country_scheme ,wss.ship_to_country_domain ,wss.charge_scheme ,wss.charge_domain ,wss.service_priority ,wss.wf_item_type ,wss.wf_activity ,wss.creation_date ,wss.created_by ,wss.last_update_date ,wss.last_updated_by ,wss.last_update_login from wsh_cc_service_setups wss ,hr_organization_units hou1 ,hr_organization_units hou2 ,fnd_user fu ,fnd_application_tl fap WHERE wss.master_organization_id=hou1.organization_id and wss.organization_id=hou2.organization_id and wss.application_user_id=fu.user_id and wss.application_id = fap.application_id union all select wss.rowid row_id ,wss.cc_service_sequence_id ,wss.master_organization_id ,hou1.name master_organization_name ,wss.organization_id ,hou2.name organization_name ,wss.application_id ,fap.application_name ,wss.application_user_id ,to_char(null)user_name ,wss.service_type_code ,wss.service_version ,wss.service_handler ,wss.service_default_threshold ,wss.country_match_flag ,wss.red_flag ,wss.ship_from_country_scheme ,wss.ship_from_country_domain ,wss.ship_to_country_scheme ,wss.ship_to_country_domain ,wss.charge_scheme ,wss.charge_domain ,wss.service_priority ,wss.wf_item_type ,wss.wf_activity ,wss.creation_date ,wss.created_by ,wss.last_update_date ,wss.last_updated_by ,wss.last_update_login from wsh_cc_service_setups wss ,hr_organization_units hou1 ,hr_organization_units hou2 ,fnd_application_tl fap where wss.master_organization_id=hou1.organization_id and wss.organization_id=hou2.organization_id and wss.application_user_id is null and wss.application_id = fap.application_id union all select wss.rowid row_id ,wss.cc_service_sequence_id ,wss.master_organization_id ,hou1.name master_organization_name ,wss.organization_id ,to_char(null) organization_name ,wss.application_id ,fap.application_name ,wss.application_user_id ,fu.user_name ,wss.service_type_code ,wss.service_version ,wss.service_handler ,wss.service_default_threshold ,wss.country_match_flag ,wss.red_flag ,wss.ship_from_country_scheme ,wss.ship_from_country_domain ,wss.ship_to_country_scheme ,wss.ship_to_country_domain ,wss.charge_scheme ,wss.charge_domain ,wss.service_priority ,wss.wf_item_type ,wss.wf_activity ,wss.creation_date ,wss.created_by ,wss.last_update_date ,wss.last_updated_by ,wss.last_update_login from wsh_cc_service_setups wss ,hr_organization_units hou1 ,fnd_user fu ,fnd_application_tl fap where wss.master_organization_id=hou1.organization_id and wss.organization_id is null and wss.application_user_id=fu.user_id and wss.application_id = fap.application_id union all select wss.rowid row_id ,wss.cc_service_sequence_id ,wss.master_organization_id ,hou1.name master_organization_name ,wss.organization_id ,to_char(null) organization_name ,wss.application_id ,fap.application_name ,wss.application_user_id ,to_char(null) user_name ,wss.service_type_code ,wss.service_version ,wss.service_handler ,wss.service_default_threshold ,wss.country_match_flag ,wss.red_flag ,wss.ship_from_country_scheme ,wss.ship_from_country_domain ,wss.ship_to_country_scheme ,wss.ship_to_country_domain ,wss.charge_scheme ,wss.charge_domain ,wss.service_priority ,wss.wf_item_type ,wss.wf_activity ,wss.creation_date ,wss.created_by ,wss.last_update_date ,wss.last_updated_by ,wss.last_update_login from wsh_cc_service_setups wss ,hr_organization_units hou1 ,fnd_application_tl fap where wss.master_organization_id=hou1.organization_id and wss.organization_id is null and wss.application_user_id is null and wss.application_id = fap.application_id

View Text - HTML Formatted

SELECT WSS.ROWID ROW_ID
, WSS.CC_SERVICE_SEQUENCE_ID
, WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, FU.USER_NAME
, WSS.SERVICE_TYPE_CODE
, WSS.SERVICE_VERSION
, WSS.SERVICE_HANDLER
, WSS.SERVICE_DEFAULT_THRESHOLD
, WSS.COUNTRY_MATCH_FLAG
, WSS.RED_FLAG
, WSS.SHIP_FROM_COUNTRY_SCHEME
, WSS.SHIP_FROM_COUNTRY_DOMAIN
, WSS.SHIP_TO_COUNTRY_SCHEME
, WSS.SHIP_TO_COUNTRY_DOMAIN
, WSS.CHARGE_SCHEME
, WSS.CHARGE_DOMAIN
, WSS.SERVICE_PRIORITY
, WSS.WF_ITEM_TYPE
, WSS.WF_ACTIVITY
, WSS.CREATION_DATE
, WSS.CREATED_BY
, WSS.LAST_UPDATE_DATE
, WSS.LAST_UPDATED_BY
, WSS.LAST_UPDATE_LOGIN
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_USER FU
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WSS.APPLICATION_USER_ID=FU.USER_ID
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WSS.ROWID ROW_ID
, WSS.CC_SERVICE_SEQUENCE_ID
, WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, TO_CHAR(NULL)USER_NAME
, WSS.SERVICE_TYPE_CODE
, WSS.SERVICE_VERSION
, WSS.SERVICE_HANDLER
, WSS.SERVICE_DEFAULT_THRESHOLD
, WSS.COUNTRY_MATCH_FLAG
, WSS.RED_FLAG
, WSS.SHIP_FROM_COUNTRY_SCHEME
, WSS.SHIP_FROM_COUNTRY_DOMAIN
, WSS.SHIP_TO_COUNTRY_SCHEME
, WSS.SHIP_TO_COUNTRY_DOMAIN
, WSS.CHARGE_SCHEME
, WSS.CHARGE_DOMAIN
, WSS.SERVICE_PRIORITY
, WSS.WF_ITEM_TYPE
, WSS.WF_ACTIVITY
, WSS.CREATION_DATE
, WSS.CREATED_BY
, WSS.LAST_UPDATE_DATE
, WSS.LAST_UPDATED_BY
, WSS.LAST_UPDATE_LOGIN
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WSS.APPLICATION_USER_ID IS NULL
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WSS.ROWID ROW_ID
, WSS.CC_SERVICE_SEQUENCE_ID
, WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, FU.USER_NAME
, WSS.SERVICE_TYPE_CODE
, WSS.SERVICE_VERSION
, WSS.SERVICE_HANDLER
, WSS.SERVICE_DEFAULT_THRESHOLD
, WSS.COUNTRY_MATCH_FLAG
, WSS.RED_FLAG
, WSS.SHIP_FROM_COUNTRY_SCHEME
, WSS.SHIP_FROM_COUNTRY_DOMAIN
, WSS.SHIP_TO_COUNTRY_SCHEME
, WSS.SHIP_TO_COUNTRY_DOMAIN
, WSS.CHARGE_SCHEME
, WSS.CHARGE_DOMAIN
, WSS.SERVICE_PRIORITY
, WSS.WF_ITEM_TYPE
, WSS.WF_ACTIVITY
, WSS.CREATION_DATE
, WSS.CREATED_BY
, WSS.LAST_UPDATE_DATE
, WSS.LAST_UPDATED_BY
, WSS.LAST_UPDATE_LOGIN
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, FND_USER FU
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID IS NULL
AND WSS.APPLICATION_USER_ID=FU.USER_ID
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION ALL SELECT WSS.ROWID ROW_ID
, WSS.CC_SERVICE_SEQUENCE_ID
, WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WSS.SERVICE_TYPE_CODE
, WSS.SERVICE_VERSION
, WSS.SERVICE_HANDLER
, WSS.SERVICE_DEFAULT_THRESHOLD
, WSS.COUNTRY_MATCH_FLAG
, WSS.RED_FLAG
, WSS.SHIP_FROM_COUNTRY_SCHEME
, WSS.SHIP_FROM_COUNTRY_DOMAIN
, WSS.SHIP_TO_COUNTRY_SCHEME
, WSS.SHIP_TO_COUNTRY_DOMAIN
, WSS.CHARGE_SCHEME
, WSS.CHARGE_DOMAIN
, WSS.SERVICE_PRIORITY
, WSS.WF_ITEM_TYPE
, WSS.WF_ACTIVITY
, WSS.CREATION_DATE
, WSS.CREATED_BY
, WSS.LAST_UPDATE_DATE
, WSS.LAST_UPDATED_BY
, WSS.LAST_UPDATE_LOGIN
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID IS NULL
AND WSS.APPLICATION_USER_ID IS NULL
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID