APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_VENDOR_SERVICES

Line 410: WSH_ITM_VENDOR_SERVICES wvs

406: wrc.request_set_id
407: FROM
408: WSH_ITM_REQUEST_CONTROL wrc,
409: WSH_ITM_SERVICE_PREFERENCES wsp,
410: WSH_ITM_VENDOR_SERVICES wvs
411: WHERE
412: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
413: nvl(wrc.original_system_reference,-99))
414: AND wrc.application_id = wsp.application_id

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

537: if p_application_id=660 then
538: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
539: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
540: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
541: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
542:
543: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
544: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';
545: END IF;