eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_LOADER_PUB dependencies on QP_LIST_HEADERS_B

Line 167: from qp_list_headers_b

163: l_req_data_counter:=to_number(l_req_data) + 1;
164:
165: select min(list_header_id), max(list_header_id)
166: into l_min_hdr_id, l_max_hdr_id
167: from qp_list_headers_b
168: where request_id = l_request_id;
169:
170: write_log( 'LOW HEADER ID: '||l_min_hdr_id);
171: write_log( 'HIGH HEADER ID: '||l_max_hdr_id);

Line 214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h

210: set used_in_setup='Y'
211: where nvl(used_in_setup,'N')='N'
212: and segment_id in
213: (select a.segment_id
214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
215: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
216: and h.active_flag = 'Y'
217: and c.REQUEST_ID = child_req_rec.request_id --8418006
218: and c.list_header_id = h.list_header_id

Line 229: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

225: set used_in_setup='Y'
226: where nvl(used_in_setup,'N')='N'
227: and segment_id in
228: (select a.segment_id
229: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
230: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
231: and h.active_flag = 'Y'
232: and c.REQUEST_ID = child_req_rec.request_id --8418006
233: and c.list_header_id = h.list_header_id

Line 244: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

240: set used_in_setup='Y'
241: where nvl(used_in_setup,'N')='N'
242: and segment_id in
243: (select a.segment_id
244: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
245: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
246: and h.active_flag = 'Y'
247: and c.REQUEST_ID = child_req_rec.request_id --8418006
248: and c.list_header_id = h.list_header_id

Line 265: FROM qp_list_headers_b

261: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
262: --bug 10634202
263: --for l_list_header_id in l_min_hdr_id..l_max_hdr_id
264: for l_lst_hdr_rec in (SELECT DISTINCT list_header_id
265: FROM qp_list_headers_b
266: WHERE request_id = l_request_id)
267: loop
268: BEGIN
269: --Query modified to consider only those list lines which are updated

Line 318: FROM qp_list_headers_b

314: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' THEN
315: --bug 10634202
316: --for l_list_header_id in l_min_hdr_id..l_max_hdr_id
317: for l_lst_hdr_rec in (SELECT DISTINCT list_header_id
318: FROM qp_list_headers_b
319: WHERE request_id = l_request_id)
320: loop
321: BEGIN
322: --Query modified to consider only those list lines which are updated

Line 429: select 1 from qp_list_headers_b qplh

425: WHERE qpih.name = p_entity_name
426: AND qpih.process_status_flag ='P' --is null
427: AND qpih.interface_action_code ='INSERT'
428: AND EXISTS(
429: select 1 from qp_list_headers_b qplh
430: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
431: );
432: IF SQL%ROWCOUNT > 0 THEN
433: Write_Log('ERROR: Hdr_Ref not Unique');

Line 1052: select 1 from qp_list_headers_b qplh

1048: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))
1049: AND qpih.process_status_flag ='P' --is null
1050: AND qpih.interface_action_code ='INSERT'
1051: AND EXISTS(
1052: select 1 from qp_list_headers_b qplh
1053: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1054: );
1055: IF SQL%ROWCOUNT > 0 THEN
1056: Write_Log('ERROR: Hdr_Ref not Unique');

Line 2092: qp_list_headers_b qplh

2088: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
2089: qpiq.qualifier_attr_value_code
2090: )
2091: from qp_qualifiers qphq,
2092: qp_list_headers_b qplh
2093: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2094: qpiq.orig_sys_qualifier_ref = qphq.orig_sys_qualifier_ref
2095: and qphq.list_header_id = qplh.list_header_id
2096: and qplh.orig_system_header_ref=qpiq.orig_sys_header_ref

Line 3407: qp_list_headers_b qplh

3403: qpip.pricing_attr_value_to_disp
3404: )
3405: --Bug# 5456164 RAVI END
3406: from qp_pricing_attributes qppa,
3407: qp_list_headers_b qplh
3408: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
3409: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
3410: and qppa.list_header_id = qplh.list_header_id
3411: and qplh.orig_system_header_ref=qpip.orig_sys_header_ref

Line 4655: qp_list_headers_b qplh

4651: null,qpip.qualification_ind
4652: )
4653: )
4654: from qp_pricing_attributes qppa,
4655: qp_list_headers_b qplh
4656: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
4657: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
4658: and qppa.list_header_id = qplh.list_header_id
4659: and qplh.orig_system_header_ref=qpip.orig_sys_header_ref

Line 6776: from qp_list_headers_b b, qp_interface_list_headers h

6772:
6773: Delete from qp_list_headers_tl
6774: where list_header_id IN
6775: (Select b.list_header_id
6776: from qp_list_headers_b b, qp_interface_list_headers h
6777: where h.request_id = p_request_id
6778: and b.orig_system_header_ref=h.orig_sys_header_ref
6779: and h.process_status_flag IS NULL
6780: and h.interface_action_code = 'INSERT'

Line 6787: Delete from qp_list_headers_b

6783: select 1 from qp_list_headers qplh
6784: where h.interface_action_code = 'INSERT'
6785: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6786:
6787: Delete from qp_list_headers_b
6788: where orig_system_header_ref IN
6789: (Select orig_sys_header_ref
6790: from qp_interface_list_headers h
6791: where h.request_id = p_request_id