APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_VENDOR_SERVICES

Line 393: WSH_ITM_VENDOR_SERVICES wvs

389: wrc.request_set_id
390: FROM
391: WSH_ITM_REQUEST_CONTROL wrc,
392: WSH_ITM_SERVICE_PREFERENCES wsp,
393: WSH_ITM_VENDOR_SERVICES wvs
394: WHERE
395: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
396: nvl(wrc.original_system_reference,-99))
397: AND wrc.application_id = wsp.application_id

Line 524: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';

520: if p_application_id=660 then
521: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
522: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
523: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
524: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
525:
526: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
527: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';
528: END IF;