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

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 458: select 1 from qp_list_headers qplh

454: AND qpih.interface_action_code IN ('INSERT','UPDATE','DELETE')
455: -- Bug 5208480(5208112,4188784) RAVI
456: -- Should not be able to update list type code
457: AND NOT EXISTS(
458: select 1 from qp_list_headers qplh
459: where qpih.interface_action_code = 'UPDATE'
460: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
461: and qplh.list_type_code <> qpih.list_type_code
462: )

Line 465: select 1 from qp_list_headers qplh

461: and qplh.list_type_code <> qpih.list_type_code
462: )
463: -- Should not be able to update list header id
464: AND NOT EXISTS(
465: select 1 from qp_list_headers qplh
466: where qpih.interface_action_code = 'UPDATE'
467: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
468: and qpih.list_header_id is not null
469: and qplh.list_header_id <> qpih.list_header_id

Line 476: select 1 from qp_list_headers qplh

472: --Bug#5208112 RAVI
473: --Validation shifted to QP_BULK_VALIDATE package.
474: /**
475: AND NOT EXISTS(
476: select 1 from qp_list_headers qplh
477: where qpih.interface_action_code = 'UPDATE'
478: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
479: and qpih.rounding_factor is not null
480: and qplh.rounding_factor <> qpih.rounding_factor

Line 486: select 1 from qp_list_headers qplh

482: **/
483: -- Bug# 5246745 RAVI
484: -- Should not be able to update list source code
485: AND NOT EXISTS(
486: select 1 from qp_list_headers qplh
487: where qpih.interface_action_code = 'UPDATE'
488: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
489: and qpih.list_source_code is not null
490: and qplh.list_source_code <> qpih.list_source_code

Line 495: select 1 from qp_list_headers qplh

491: )
492: -- Bug# 5246745 RAVI
493: -- Should not be able to update list source code
494: AND NOT EXISTS(
495: select 1 from qp_list_headers qplh
496: where qpih.interface_action_code = 'UPDATE'
497: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
498: and qpih.source_system_code is not null
499: and qplh.source_system_code <> qpih.source_system_code

Line 504: select 1 from qp_list_headers qplh

500: )
501: -- Bug# 5246745 RAVI
502: -- Should not be able to update list source code
503: AND NOT EXISTS(
504: select 1 from qp_list_headers qplh
505: where qpih.interface_action_code = 'UPDATE'
506: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
507: and qpih.source_system_code is not null
508: and qplh.source_system_code <> qpih.source_system_code

Line 511: select 1 from qp_list_headers qplh

507: and qpih.source_system_code is not null
508: and qplh.source_system_code <> qpih.source_system_code
509: )
510: AND NOT EXISTS(
511: select 1 from qp_list_headers qplh
512: where qpih.interface_action_code = 'INSERT'
513: -- ENH undo alcoa changes RAVI
514: /**
515: The key between interface and qp tables is only orig_sys_hdr_ref

Line 1020: from qp_list_headers qplh

1016: null,
1017: qpih.global_flag
1018: )
1019: )
1020: from qp_list_headers qplh
1021: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1022: )
1023: where qpih.request_id = l_request_id
1024: and qpih.process_status_flag = 'P'

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 1081: select 1 from qp_list_headers qplh

1077: AND nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
1078: AND qpih.interface_action_code IN ('INSERT','UPDATE','DELETE')
1079: -- Bug 5208480(5208112,4188784) RAVI
1080: AND NOT EXISTS(
1081: select 1 from qp_list_headers qplh
1082: where qpih.interface_action_code = 'UPDATE'
1083: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1084: and qplh.list_type_code <> qpih.list_type_code
1085: )

Line 1087: select 1 from qp_list_headers qplh

1083: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1084: and qplh.list_type_code <> qpih.list_type_code
1085: )
1086: AND NOT EXISTS(
1087: select 1 from qp_list_headers qplh
1088: where qpih.interface_action_code = 'UPDATE'
1089: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1090: and qpih.list_header_id is not null
1091: and qplh.list_header_id <> qpih.list_header_id

Line 1094: select 1 from qp_list_headers qplh

1090: and qpih.list_header_id is not null
1091: and qplh.list_header_id <> qpih.list_header_id
1092: )
1093: AND NOT EXISTS(
1094: select 1 from qp_list_headers qplh
1095: where qpih.interface_action_code = 'UPDATE'
1096: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1097: and qpih.rounding_factor is not null
1098: and qplh.rounding_factor <> qpih.rounding_factor

Line 1103: select 1 from qp_list_headers qplh

1099: )
1100: -- Bug# 5246745 RAVI
1101: -- Should not be able to update list source code
1102: AND NOT EXISTS(
1103: select 1 from qp_list_headers qplh
1104: where qpih.interface_action_code = 'UPDATE'
1105: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1106: and qpih.list_source_code is not null
1107: and qplh.list_source_code <> qpih.list_source_code

Line 1112: select 1 from qp_list_headers qplh

1108: )
1109: -- Bug# 5246745 RAVI
1110: -- Should not be able to update list source code
1111: AND NOT EXISTS(
1112: select 1 from qp_list_headers qplh
1113: where qpih.interface_action_code = 'UPDATE'
1114: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1115: and qpih.source_system_code is not null
1116: and qplh.source_system_code <> qpih.source_system_code

Line 1121: select 1 from qp_list_headers qplh

1117: )
1118: -- Bug# 5246745 RAVI
1119: -- Should not be able to update list source code
1120: AND NOT EXISTS(
1121: select 1 from qp_list_headers qplh
1122: where qpih.interface_action_code = 'UPDATE'
1123: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1124: and qpih.source_system_code is not null
1125: and qplh.source_system_code <> qpih.source_system_code

Line 1128: select 1 from qp_list_headers qplh

1124: and qpih.source_system_code is not null
1125: and qplh.source_system_code <> qpih.source_system_code
1126: )
1127: AND NOT EXISTS(
1128: select 1 from qp_list_headers qplh
1129: where qpih.interface_action_code = 'INSERT'
1130: -- ENH undo alcoa changes RAVI
1131: /**
1132: The key between interface and qp tables is only orig_sys_hdr_ref

Line 1637: from qp_list_headers qplh

1633: null,
1634: qpih.global_flag
1635: )
1636: )
1637: from qp_list_headers qplh
1638: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1639: )
1640: where qpih.request_id = l_request_id
1641: and qpih.process_status_flag = 'P'

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 2945: from qp_list_headers qplh,

2941: null,
2942: qpil.substitution_value
2943: )
2944: )
2945: from qp_list_headers qplh,
2946: qp_list_lines qpll
2947: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2948: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2949: and qpll.list_header_id = qplh.list_header_id

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 4326: from qp_list_headers qplh,

4322: null,
4323: qpil.substitution_value
4324: )
4325: )
4326: from qp_list_headers qplh,
4327: qp_list_lines qpll
4328: where -- CAUSES FTS AS NO INDEX ON LINE_REF
4329: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
4330: and qpll.list_header_id = qplh.list_header_id

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 6773: Delete from qp_list_headers_tl

6769: IS
6770: BEGIN
6771: write_log('Entering POST_CLEANUP');
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

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 6783: select 1 from qp_list_headers qplh

6779: and h.process_status_flag IS NULL
6780: and h.interface_action_code = 'INSERT'
6781: -- 6028305
6782: AND NOT EXISTS(
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

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

Line 6796: select 1 from qp_list_headers qplh

6792: and h.process_status_flag IS NULL
6793: and h.interface_action_code = 'INSERT'
6794: -- 6028305
6795: AND NOT EXISTS(
6796: select 1 from qp_list_headers qplh
6797: where h.interface_action_code = 'INSERT'
6798: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6799:
6800: Delete from qp_qualifiers