APPS.WSH_ITM_RESUBMIT dependencies on WSH_ITM_RESPONSE_HEADERS

Line 194: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS

190: -- Name
191: -- Resubmit_Requests
192: -- Purpose
193: -- This procedure selects all the eligible records from the tables
194: -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
195: -- and WSH_ITM_RESPONSE_LINES for Resubmit.
196: -- For every record, it first updates the process_flag in the table
197: -- WSH_ITM_REQUEST_CONTROL to 0, meaning RESUBMIT
198: --

Line 263: WSH_ITM_RESPONSE_HEADERS wrh

259: SELECT DISTINCT
260: wrc.request_control_id
261: FROM
262: WSH_ITM_REQUEST_CONTROL wrc,
263: WSH_ITM_RESPONSE_HEADERS wrh
264: WHERE
265: wrc.response_header_id = wrh.response_header_id
266: AND nvl(wrh.vendor_id,-99) = nvl(p_vendor_id, nvl(wrh.vendor_id,-99))
267: AND nvl(wrh.error_type,-99) = nvl(p_error_type, nvl(wrh.error_type,-99))

Line 306: ', WSH_ITM_RESPONSE_HEADERS wrh '||

302: IF p_application_id = 660 THEN --{
303:
304: l_sql_string := 'SELECT DISTINCT wrc.request_control_id '||
305: 'FROM WSH_ITM_REQUEST_CONTROL wrc '||
306: ', WSH_ITM_RESPONSE_HEADERS wrh '||
307: ', OE_ORDER_HEADERS_ALL oh ';
308:
309: IF (p_party_type IS NOT NULL) OR (p_party_id IS NOT NULL) THEN
310: l_sql_string := l_sql_string || ', WSH_ITM_PARTIES wp ';

Line 344: ' , WSH_ITM_RESPONSE_HEADERS wrh '||

340: END IF;
341: l_sql_string := l_sql_string || ' UNION '||
342: ' SELECT DISTINCT wrc.request_control_id '||
343: ' FROM WSH_ITM_REQUEST_CONTROL wrc '||
344: ' , WSH_ITM_RESPONSE_HEADERS wrh '||
345: ' , WSH_ITM_RESPONSE_LINES wrl '||
346: ' , OE_ORDER_LINES_ALL ol ';
347: IF (p_party_type IS NOT NULL) OR (p_party_id IS NOT NULL) THEN
348: l_sql_string := l_sql_string || ', WSH_ITM_PARTIES wp ';