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_PRICING_ATTRIBUTES

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

198: set used_in_setup='Y'
199: where nvl(used_in_setup,'N')='N'
200: and segment_id in
201: (select a.segment_id
202: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
203: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
204: and h.active_flag = 'Y'
205: and c.list_header_id = h.list_header_id
206: and a.segment_mapping_column = c.pricing_attribute

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

212: set used_in_setup='Y'
213: where nvl(used_in_setup,'N')='N'
214: and segment_id in
215: (select a.segment_id
216: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
217: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
218: and h.active_flag = 'Y'
219: and c.list_header_id = h.list_header_id
220: and a.segment_mapping_column = c.product_attribute

Line 2862: select 1 from qp_pricing_attributes qppa

2858: AND pa.interface_action_code IN ('INSERT','UPDATE','DELETE') )
2859: -- Bug 5208480(5208112,4188784) RAVI
2860: AND NOT EXISTS
2861: (
2862: select 1 from qp_pricing_attributes qppa
2863: where qpip.interface_action_code = 'UPDATE'
2864: and qpip.orig_sys_line_ref = qppa.orig_sys_line_ref
2865: and qppa.list_line_id is not null
2866: and qpip.list_line_id <> qppa.list_line_id

Line 2872: select 1 from qp_pricing_attributes qppa

2868: -- Bug# 5246745 RAVI
2869: -- Should not be able to update product attribute context
2870: AND NOT EXISTS
2871: (
2872: select 1 from qp_pricing_attributes qppa
2873: where qpip.interface_action_code = 'UPDATE'
2874: and qpip.orig_sys_line_ref = qppa.orig_sys_line_ref
2875: and qppa.product_attribute_context is not null
2876: and qpip.product_attribute_context <> qppa.product_attribute_context

Line 2882: select 1 from qp_pricing_attributes qppa

2878: -- Bug# 5246745 RAVI
2879: -- Should not be able to update product attribute
2880: AND NOT EXISTS
2881: (
2882: select 1 from qp_pricing_attributes qppa
2883: where qpip.interface_action_code = 'UPDATE'
2884: and qpip.orig_sys_line_ref = qppa.orig_sys_line_ref
2885: and qppa.product_attribute is not null
2886: and qpip.product_attribute <> qppa.product_attribute

Line 2892: select 1 from qp_pricing_attributes qppa

2888: -- Bug# 5246745 RAVI
2889: -- Should not be able to update product attribute Value
2890: AND NOT EXISTS
2891: (
2892: select 1 from qp_pricing_attributes qppa
2893: where qpip.interface_action_code = 'UPDATE'
2894: and qpip.orig_sys_line_ref = qppa.orig_sys_line_ref
2895: and qppa.product_attr_value is not null
2896: and qpip.product_attr_value <> qppa.product_attr_value

Line 3287: from qp_pricing_attributes qppa,

3283: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
3284: qpip.pricing_attr_value_to_disp
3285: )
3286: --Bug# 5456164 RAVI END
3287: from qp_pricing_attributes qppa,
3288: qp_list_headers_b qplh
3289: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
3290: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
3291: and qppa.list_header_id = qplh.list_header_id

Line 4251: select 1 from qp_pricing_attributes qppa

4247: AND pa.orig_sys_line_ref = l.orig_sys_line_ref))
4248: -- Bug 5208480(5208112,4188784) RAVI
4249: AND NOT EXISTS
4250: (
4251: select 1 from qp_pricing_attributes qppa
4252: where qpip.interface_action_code = 'UPDATE'
4253: and qpip.orig_sys_line_ref = qppa.orig_sys_line_ref
4254: and qppa.list_line_id is not null
4255: and qpip.list_line_id <> qppa.list_line_id

Line 4535: from qp_pricing_attributes qppa,

4531: decode(qpip.qualification_ind,QP_BULK_LOADER_PUB.G_NULL_NUMBER,
4532: null,qpip.qualification_ind
4533: )
4534: )
4535: from qp_pricing_attributes qppa,
4536: qp_list_headers_b qplh
4537: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
4538: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
4539: and qppa.list_header_id = qplh.list_header_id

Line 6731: Delete from qp_pricing_attributes

6727: and il.interface_action_code ='INSERT'
6728: and il.orig_sys_header_ref = l.orig_sys_header_ref
6729: and il.orig_sys_line_ref = l.orig_sys_line_ref);
6730:
6731: Delete from qp_pricing_attributes
6732: where pricing_attribute_id IN
6733: (Select pa.pricing_attribute_id
6734: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa
6735: where ipa.request_id = p_request_id

Line 6734: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa

6730:
6731: Delete from qp_pricing_attributes
6732: where pricing_attribute_id IN
6733: (Select pa.pricing_attribute_id
6734: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa
6735: where ipa.request_id = p_request_id
6736: and pa.request_id = p_request_id -- changes made by rassharm 6028305
6737: and ipa.process_status_flag IS NULL
6738: and ipa.interface_action_code ='INSERT'

Line 6779: and not exists (select 'x' from qp_pricing_attributes pa

6775: from qp_list_lines l
6776: where l.request_id = p_request_id
6777: and not exists (select 'x' from qp_rltd_modifiers
6778: where to_rltd_modifier_id = l.list_line_id)
6779: and not exists (select 'x' from qp_pricing_attributes pa
6780: where l.list_line_id = pa.list_line_id
6781: and pa.pricing_attribute_context is null
6782: and pa.pricing_attribute is null
6783: and pa.pricing_attr_value_from is null

Line 6793: and not exists (select 'x' from qp_pricing_attributes pa

6789: from qp_list_lines l
6790: where l.request_id = p_request_id
6791: and exists (select 'x' from qp_rltd_modifiers
6792: where to_rltd_modifier_id = l.list_line_id)
6793: and not exists (select 'x' from qp_pricing_attributes pa
6794: where l.list_line_id = pa.list_line_id
6795: and pa.pricing_attribute_context is not null
6796: and pa.pricing_attribute is not null
6797: and (pa.pricing_attr_value_from is not null

Line 6840: DELETE FROM qp_pricing_attributes

6836: AND orig_sys_line_ref = l_orig_sys_line_ref_tbl(I)
6837: AND request_id = p_request_id; --Bug No: 6235177
6838:
6839: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6840: DELETE FROM qp_pricing_attributes
6841: WHERE list_line_id = l_list_line_id_tbl(I);
6842:
6843: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6844: DELETE FROM qp_list_lines

Line 6860: DELETE FROM qp_pricing_attributes

6856: FROM qp_rltd_modifiers
6857: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6858:
6859: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6860: DELETE FROM qp_pricing_attributes
6861: WHERE list_line_id IN
6862: (SELECT to_rltd_modifier_id
6863: FROM qp_rltd_modifiers
6864: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));

Line 6934: DELETE FROM QP_PRICING_ATTRIBUTES

6930: FOR l_pricing_attr_rec IN c_pricing_attr
6931: LOOP
6932: BEGIN
6933:
6934: DELETE FROM QP_PRICING_ATTRIBUTES
6935: WHERE list_line_id IN
6936: (SELECT r.to_rltd_modifier_id
6937: FROM qp_rltd_modifiers r, qp_list_lines l
6938: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref

Line 6956: DELETE FROM QP_PRICING_ATTRIBUTES

6952: (SELECT list_line_id FROM QP_LIST_LINES l
6953: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6954: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref);
6955:
6956: DELETE FROM QP_PRICING_ATTRIBUTES
6957: WHERE orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6958: AND orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref;
6959:
6960: DELETE FROM QP_LIST_LINES

Line 6970: DELETE FROM QP_PRICING_ATTRIBUTES

6966: END LOOP;
6967:
6968: FOR l_pbh_cline_rec IN c_pbh_child_line
6969: LOOP
6970: DELETE FROM QP_PRICING_ATTRIBUTES
6971: WHERE list_line_id IN
6972: (SELECT to_rltd_modifier_id
6973: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l
6974: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref

Line 6986: DELETE FROM QP_PRICING_ATTRIBUTES

6982: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref
6983: AND l.orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref
6984: AND l.list_line_id = r.from_rltd_modifier_id);
6985:
6986: DELETE FROM QP_PRICING_ATTRIBUTES
6987: WHERE list_line_id IN
6988: (SELECT list_line_id
6989: FROM QP_LIST_LINES
6990: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref