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_VALIDATE dependencies on QP_INTERFACE_PRICING_ATTRIBS

Line 151: * in qp_interface_pricing_attribs */

147: PROCEDURE dup_line_check(p_request_id NUMBER)
148: IS
149: /* This cursor gives lines which got atleast one
150: * duplicate pricing attibute with another line
151: * in qp_interface_pricing_attribs */
152: CURSOR c_dup_line_rec IS
153: SELECT distinct a_attr.orig_sys_header_ref,
154: a_attr.orig_sys_line_ref, --first line
155: b_attr.orig_sys_line_ref --second line

Line 156: FROM qp_interface_pricing_attribs a_attr,

152: CURSOR c_dup_line_rec IS
153: SELECT distinct a_attr.orig_sys_header_ref,
154: a_attr.orig_sys_line_ref, --first line
155: b_attr.orig_sys_line_ref --second line
156: FROM qp_interface_pricing_attribs a_attr,
157: qp_interface_pricing_attribs b_attr
158: WHERE a_attr.request_id = p_request_id
159: AND b_attr.request_id = p_request_id
160: AND a_attr.process_status_flag = 'P'

Line 157: qp_interface_pricing_attribs b_attr

153: SELECT distinct a_attr.orig_sys_header_ref,
154: a_attr.orig_sys_line_ref, --first line
155: b_attr.orig_sys_line_ref --second line
156: FROM qp_interface_pricing_attribs a_attr,
157: qp_interface_pricing_attribs b_attr
158: WHERE a_attr.request_id = p_request_id
159: AND b_attr.request_id = p_request_id
160: AND a_attr.process_status_flag = 'P'
161: AND b_attr.process_status_flag = 'P'

Line 196: FROM qp_interface_pricing_attribs a_attr,

192: CURSOR c_dup_line_rec1 IS
193: SELECT DISTINCT a_attr.orig_sys_header_ref,
194: a_attr.orig_sys_line_ref,
195: b_attr.orig_sys_line_ref
196: FROM qp_interface_pricing_attribs a_attr,
197: qp_pricing_attributes b_attr
198: WHERE a_attr.request_id = p_request_id
199: AND a_attr.process_status_flag = 'P'
200: AND a_attr.interface_action_code IN ('INSERT', 'UPDATE')

Line 209: FROM qp_interface_pricing_attribs c

205: AND b_attr.product_attr_value = a_attr.product_attr_value
206: AND Nvl(b_attr.product_uom_code, '*') = Nvl(a_attr.product_uom_code, '*')
207: AND NOT EXISTS( /* should not consider pricing attribute which */
208: SELECT 'X' /* going to be updated or deleted */
209: FROM qp_interface_pricing_attribs c
210: WHERE c.request_id = p_request_id
211: AND c.orig_sys_pricing_attr_ref = b_attr.orig_sys_pricing_attr_ref
212: AND c.interface_action_code IN ('UPDATE', 'DELETE')
213: )

Line 235: * union b/w qp_interface_pricing_attribs and qp_pricing_attributes

231: )
232: ;
233:
234: /* gives all pricing attribute of a line
235: * union b/w qp_interface_pricing_attribs and qp_pricing_attributes
236: */
237: CURSOR c_pricing_attr(l_orig_sys_line_ref VARCHAR2) IS
238: /* take attibute from qp_interface_pricing_attribs */
239: SELECT pricing_attribute_context,

Line 238: /* take attibute from qp_interface_pricing_attribs */

234: /* gives all pricing attribute of a line
235: * union b/w qp_interface_pricing_attribs and qp_pricing_attributes
236: */
237: CURSOR c_pricing_attr(l_orig_sys_line_ref VARCHAR2) IS
238: /* take attibute from qp_interface_pricing_attribs */
239: SELECT pricing_attribute_context,
240: pricing_attribute,
241: pricing_attr_value_from,
242: pricing_attr_value_to,

Line 244: FROM qp_interface_pricing_attribs

240: pricing_attribute,
241: pricing_attr_value_from,
242: pricing_attr_value_to,
243: comparison_operator_code
244: FROM qp_interface_pricing_attribs
245: WHERE request_id = p_request_id
246: AND orig_sys_line_ref = l_orig_sys_line_ref
247: AND pricing_attribute_context IS NOT NULL
248: AND pricing_attribute IS NOT NULL

Line 250: UNION /* union with qp_interface_pricing_attribs */

246: AND orig_sys_line_ref = l_orig_sys_line_ref
247: AND pricing_attribute_context IS NOT NULL
248: AND pricing_attribute IS NOT NULL
249:
250: UNION /* union with qp_interface_pricing_attribs */
251:
252: SELECT pricing_attribute_context,
253: pricing_attribute,
254: pricing_attr_value_from,

Line 264: FROM qp_interface_pricing_attribs c

260: AND qpa.pricing_attribute IS NOT NULL
261: AND NOT EXISTS ( /* do not take an attribute from */
262: SELECT 1 /* qp_pricing_attributes if that going to */
263: /* be updated or deleted */
264: FROM qp_interface_pricing_attribs c
265: WHERE c.orig_sys_line_ref = l_orig_sys_line_ref
266: AND c.interface_action_code IN ('UPDATE', 'DELETE')
267: AND c.orig_sys_pricing_attr_ref = qpa.orig_sys_pricing_attr_ref
268: )

Line 310: /* First we check for duplicates in qp_interface_pricing_attribs(i_mode = 1)

306: l_dummy VARCHAR2(2);
307:
308: l_routine VARCHAR2(230) := 'DUP_LINE_CHECK ';
309: BEGIN
310: /* First we check for duplicates in qp_interface_pricing_attribs(i_mode = 1)
311: * then in qp_pricing_attributes(i_mode = 2) */
312: qp_bulk_loader_pub.write_log('In ' || l_routine);
313: FOR i_mode IN 1..2
314: LOOP

Line 1867: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv

1863: l_exist :=0;
1864:
1865: begin
1866: select count(*) into l_exist
1867: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv
1868: where qipa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1869: and qipa.request_id = p_line_rec.request_id(I)
1870: and qipa.product_attribute_context = 'ITEM'
1871: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 1895: from qp_interface_pricing_attribs qipa

1891: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
1892: and msiv.service_item_flag = 'Y'
1893: and qpa.orig_sys_pricing_attr_ref not in (
1894: select qpa.orig_sys_pricing_attr_ref
1895: from qp_interface_pricing_attribs qipa
1896: where qipa.orig_sys_pricing_attr_ref = qpa.orig_sys_pricing_attr_ref
1897: and qipa.interface_action_code = 'DELETE'
1898: and qipa.request_id = p_line_rec.request_id(I));
1899: exception

Line 3352: qp_interface_pricing_attribs pa,

3348: SELECT 'OVERLAP'
3349: FROM qp_list_lines la,
3350: qp_rltd_modifiers ra,
3351: qp_rltd_modifiers rb,
3352: qp_interface_pricing_attribs pa,
3353: qp_pricing_attributes pb
3354: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3355: -- Bug 5246745 Use Composite Index for Ref columns
3356: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3370: from qp_interface_pricing_attribs pia

3366: -- Got Remaining Price Break Lines Values
3367: -- Bug# 5236432 RAVI
3368: AND pb.orig_sys_pricing_attr_ref NOT IN (
3369: select pia.orig_sys_pricing_attr_ref
3370: from qp_interface_pricing_attribs pia
3371: where pia.orig_sys_header_ref=pb.orig_sys_header_ref
3372: and pia.orig_sys_line_ref=pb.orig_sys_line_ref
3373: )
3374: -- Got the remaining Price Break Lines that are not being updated in this request

Line 3412: qp_interface_pricing_attribs pa,

3408: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3409: FROM qp_list_lines la,
3410: qp_rltd_modifiers ra,
3411: qp_rltd_modifiers rb,
3412: qp_interface_pricing_attribs pa,
3413: qp_pricing_attributes pb
3414: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3415: -- Bug 5246745 Use Composite Index for Ref columns
3416: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3442: qp_interface_pricing_attribs pa,

3438: FROM qp_list_lines la,
3439: qp_list_lines lb,
3440: qp_rltd_modifiers ra,
3441: qp_rltd_modifiers rb,
3442: qp_interface_pricing_attribs pa,
3443: qp_interface_pricing_attribs pb
3444: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3445: -- Bug 5246745 Use Composite Index for Ref columns
3446: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3443: qp_interface_pricing_attribs pb

3439: qp_list_lines lb,
3440: qp_rltd_modifiers ra,
3441: qp_rltd_modifiers rb,
3442: qp_interface_pricing_attribs pa,
3443: qp_interface_pricing_attribs pb
3444: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3445: -- Bug 5246745 Use Composite Index for Ref columns
3446: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3447: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3466: qp_interface_pricing_attribs pa,

3462: SELECT count(*) l_from_value_old
3463: FROM qp_list_lines la,
3464: qp_rltd_modifiers ra,
3465: qp_rltd_modifiers rb,
3466: qp_interface_pricing_attribs pa,
3467: qp_pricing_attributes pb
3468: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3469: -- Bug 5246745 Use Composite Index for Ref columns
3470: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3495: qp_interface_pricing_attribs pa,

3491: FROM qp_list_lines la,
3492: qp_list_lines lb,
3493: qp_rltd_modifiers ra,
3494: qp_rltd_modifiers rb,
3495: qp_interface_pricing_attribs pa,
3496: qp_interface_pricing_attribs pb
3497: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3498: -- Bug 5246745 Use Composite Index for Ref columns
3499: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3496: qp_interface_pricing_attribs pb

3492: qp_list_lines lb,
3493: qp_rltd_modifiers ra,
3494: qp_rltd_modifiers rb,
3495: qp_interface_pricing_attribs pa,
3496: qp_interface_pricing_attribs pb
3497: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3498: -- Bug 5246745 Use Composite Index for Ref columns
3499: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3500: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3520: qp_interface_pricing_attribs pa,

3516: SELECT count(*) l_to_value_old
3517: FROM qp_list_lines la,
3518: qp_rltd_modifiers ra,
3519: qp_rltd_modifiers rb,
3520: qp_interface_pricing_attribs pa,
3521: qp_pricing_attributes pb
3522: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3523: -- Bug 5246745 Use Composite Index for Ref columns
3524: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3549: qp_interface_pricing_attribs pa,

3545: FROM qp_list_lines la,
3546: qp_list_lines lb,
3547: qp_rltd_modifiers ra,
3548: qp_rltd_modifiers rb,
3549: qp_interface_pricing_attribs pa,
3550: qp_interface_pricing_attribs pb
3551: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3552: -- Bug 5246745 Use Composite Index for Ref columns
3553: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3550: qp_interface_pricing_attribs pb

3546: qp_list_lines lb,
3547: qp_rltd_modifiers ra,
3548: qp_rltd_modifiers rb,
3549: qp_interface_pricing_attribs pa,
3550: qp_interface_pricing_attribs pb
3551: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3552: -- Bug 5246745 Use Composite Index for Ref columns
3553: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3554: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3573: qp_interface_pricing_attribs pa,

3569: FROM qp_list_lines la,
3570: qp_list_lines lb,
3571: qp_rltd_modifiers ra,
3572: qp_rltd_modifiers rb,
3573: qp_interface_pricing_attribs pa,
3574: qp_interface_pricing_attribs pb
3575: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3576: -- Bug 5246745 Use Composite Index for Ref columns
3577: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3574: qp_interface_pricing_attribs pb

3570: qp_list_lines lb,
3571: qp_rltd_modifiers ra,
3572: qp_rltd_modifiers rb,
3573: qp_interface_pricing_attribs pa,
3574: qp_interface_pricing_attribs pb
3575: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3576: -- Bug 5246745 Use Composite Index for Ref columns
3577: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3578: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3617: l_msg_rec.TABLE_NAME := 'QP_INTERFACE_PRICING_ATTRIBS';

3613: --Initially setting the message context.
3614:
3615: l_msg_rec.REQUEST_ID := P_PRICING_ATTR_REC.REQUEST_ID(I);
3616: l_msg_rec.ENTITY_TYPE := 'PRL';
3617: l_msg_rec.TABLE_NAME := 'QP_INTERFACE_PRICING_ATTRIBS';
3618: l_msg_rec.ORIG_SYS_HEADER_REF := p_pricing_attr_rec.orig_sys_header_ref(I);
3619: l_msg_rec.ORIG_SYS_LINE_REF := p_pricing_attr_rec.orig_sys_line_ref(I);
3620: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
3621: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := p_pricing_attr_rec.orig_sys_pricing_attr_ref(I);

Line 3654: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3650: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3651: THEN --Check if item is purchasing enabled
3652: Begin
3653: select count(*) into l_pa_count
3654: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3655: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3656: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3657: and qipa.product_attribute_context = 'ITEM'
3658: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3670: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3666: End;
3667: ELSE --Check if item is orderable
3668: Begin
3669: select count(*) into l_pa_count
3670: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3671: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3672: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3673: and qipa.product_attribute_context = 'ITEM'
3674: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3753: FROM qp_interface_pricing_attribs

3749: IF p_pricing_attr_rec.interface_action_code(I) = 'INSERT' THEN
3750: l_exist:=null;
3751: BEGIN
3752: SELECT count(*) INTO l_exist
3753: FROM qp_interface_pricing_attribs
3754: WHERE request_id = p_pricing_attr_rec.request_id(I)
3755: AND orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3756: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3757: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 3857: FROM qp_interface_pricing_attribs

3853: qp_bulk_loader_pub.write_log('Count of records in Pricing Attr table with pricing contect/attr/value null' || to_char(l_exist));
3854: l_exist1:=null;
3855: BEGIN
3856: SELECT count(*) INTO l_exist1
3857: FROM qp_interface_pricing_attribs
3858: WHERE request_id = p_pricing_attr_rec.request_id(I)
3859: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3860: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
3861: AND orig_sys_pricing_attr_ref <> p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)

Line 3904: FROM qp_interface_pricing_attribs

3900:
3901: l_exist1:=null;
3902: BEGIN
3903: SELECT count(*) INTO l_exist1
3904: FROM qp_interface_pricing_attribs
3905: WHERE request_id = p_pricing_attr_rec.request_id(I)
3906: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3907: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
3908: AND orig_sys_pricing_attr_ref <> p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)

Line 3985: FROM qp_interface_pricing_attribs

3981: BEGIN
3982: l_exist1 := NULL;
3983: SELECT /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N2) */ --7433219
3984: count(*) INTO l_exist1
3985: FROM qp_interface_pricing_attribs
3986: WHERE request_id = p_pricing_attr_rec.request_id(I)
3987: AND process_status_flag = 'P' --is null
3988: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3989: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)

Line 4176: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,

4172: l_exist := 0;
4173: begin
4174: SELECT 1
4175: into l_exist
4176: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,
4177: qp_segments_b e, qp_pte_segments f
4178: WHERE orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
4179: AND b.product_attribute_context = d.prc_context_code
4180: AND b.product_attribute = e.segment_mapping_column

Line 4412: FROM qp_list_lines l, qp_interface_pricing_attribs a

4408: BEGIN
4409: l_count := null;
4410: SELECT count(*)
4411: INTO l_count
4412: FROM qp_list_lines l, qp_interface_pricing_attribs a
4413: WHERE l.orig_sys_line_ref = a.orig_sys_line_ref
4414: AND l.orig_sys_header_ref = a.orig_sys_header_ref
4415: AND a.orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I)
4416: AND a.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context(I)

Line 4505: qp_interface_pricing_attribs pb,

4501: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
4502: UNION
4503: SELECT /*+ leading(la) */ /*DISTINCT pb.pricing_attribute
4504: FROM qp_list_lines la,
4505: qp_interface_pricing_attribs pb,
4506: qp_rltd_modifiers ra
4507: WHERE ra.to_rltd_modifier_id = la.list_line_id
4508: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4509: AND pb.request_id = p_pricing_attr_rec.request_id(I)

Line 4527: qp_interface_pricing_attribs pb

4523: FROM qp_list_lines la,
4524: qp_rltd_modifiers ra,
4525: qp_rltd_modifiers rb,
4526: qp_list_lines lb,
4527: qp_interface_pricing_attribs pb
4528: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4529: la.list_line_type_code = 'PLL' AND
4530: la.pricing_phase_id = 1 AND
4531: ra.to_rltd_modifier_id = la.list_line_id AND

Line 6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',

6099: orig_sys_pricing_attr_ref,error_message)
6100: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6107: WHERE qpil.request_id = p_request_id

Line 6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6107: WHERE qpil.request_id = p_request_id
6108: AND qpip.request_id = p_request_id -- bug no 5881528
6109: AND qpil.process_status_flag ='P' --is null
6110: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',

6185: orig_sys_pricing_attr_ref,error_message)
6186: SELECT
6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6193: WHERE qpil.request_id = p_request_id

Line 6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6193: WHERE qpil.request_id = p_request_id
6194: AND qpip.request_id = p_request_id -- bug no 5881528
6195: AND qpil.process_status_flag ='P' --is null
6196: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6451: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6448: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6449: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6450: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6451: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6452: WHERE qpil.request_id = p_request_id
6453: AND qpip.request_id = p_request_id -- bug no 5881528
6454: AND qpil.process_status_flag ='P' --is null
6455: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6459: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6455: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
6456: AND qpip.pricing_attribute_context IS NULL
6457: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6458: AND EXISTS ( SELECT 'x'
6459: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6460: WHERE b.product_attribute_context = d.prc_context_code
6461: AND b.product_attribute = e.segment_mapping_column
6462: and e.segment_code = b.product_attr_code
6463: AND d.prc_context_id = e.prc_context_id

Line 6471: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6467: AND f.segment_level <> 'LINE'
6468: AND qpip.rowid = b.rowid
6469: union
6470: SELECT 'x'
6471: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6472: WHERE b.product_attribute_context = d.prc_context_code
6473: AND b.product_attribute is NULL and e.segment_code = b.product_attr_code
6474: AND d.prc_context_id = e.prc_context_id
6475: AND d.prc_context_type = 'PRODUCT'

Line 6500: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6497: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6498: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6499: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6500: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6501: WHERE qpil.request_id = p_request_id
6502: AND qpip.request_id = p_request_id -- bug no 5881528
6503: AND qpil.process_status_flag ='P' --is null
6504: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6511: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6507: AND qpip.product_attr_code IS NOT NULL
6508: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6509: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6510: AND NOT EXISTS ( SELECT 'x'
6511: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6512: WHERE b.product_attribute_context = d.prc_context_code
6513: AND b.product_attribute = e.segment_mapping_column
6514: and e.segment_code = b.product_attr_code
6515: AND d.prc_context_id = e.prc_context_id

Line 6533: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6530: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6531: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6532: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6533: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6534: WHERE qpil.request_id = p_request_id
6535: AND qpip.request_id = p_request_id -- bug no 5881528
6536: AND qpil.process_status_flag ='P' --is null
6537: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6544: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6540: AND qpip.product_attr_code IS NOT NULL
6541: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6542: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6543: AND NOT EXISTS ( SELECT 'x'
6544: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6545: WHERE b.product_attribute_context = d.prc_context_code
6546: and e.segment_code = b.product_attr_code
6547: AND d.prc_context_id = e.prc_context_id
6548: AND d.prc_context_type = 'PRODUCT'

Line 6565: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6562: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6563: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6564: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6565: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6566: WHERE qpil.request_id = p_request_id
6567: AND qpip.request_id = p_request_id -- bug no 5881528
6568: AND qpil.process_status_flag ='P' --is null
6569: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6575: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6571: AND qpip.product_attribute IS NOT NULL
6572: AND qpip.product_attr_code IS NULL
6573: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6574: AND NOT EXISTS ( SELECT 'x'
6575: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6576: WHERE b.product_attribute_context = d.prc_context_code
6577: AND b.product_attribute = e.segment_mapping_column
6578: AND d.prc_context_id = e.prc_context_id
6579: AND d.prc_context_type = 'PRODUCT'

Line 6602: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6599: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6600: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6601: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6602: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6603: WHERE qpil.request_id = p_request_id
6604: AND qpip.request_id = p_request_id -- bug no 5881528
6605: AND qpil.process_status_flag ='P' --is null
6606: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6613: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6609: AND qpip.pricing_attr_code IS NOT NULL
6610: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6611: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6612: AND NOT EXISTS ( SELECT 'x'
6613: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6614: WHERE b.pricing_attribute_context = d.prc_context_code
6615: AND b.pricing_attribute = e.segment_mapping_column
6616: and e.segment_code = b.pricing_attr_code
6617: AND d.prc_context_id = e.prc_context_id

Line 6635: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6632: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6633: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6634: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6635: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6636: WHERE qpil.request_id = p_request_id
6637: AND qpip.request_id = p_request_id -- bug no 5881528
6638: AND qpil.process_status_flag ='P' --is null
6639: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6646: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6642: AND qpip.pricing_attr_code IS NOT NULL
6643: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6644: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6645: AND NOT EXISTS ( SELECT 'x'
6646: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6647: WHERE b.pricing_attribute_context = d.prc_context_code
6648: and e.segment_code = b.pricing_attr_code
6649: AND d.prc_context_id = e.prc_context_id
6650: AND d.prc_context_type = 'PRICING_ATTRIBUTE'

Line 6667: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6664: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6665: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6666: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6667: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6668: WHERE qpil.request_id = p_request_id
6669: AND qpip.request_id = p_request_id -- bug no 5881528
6670: AND qpil.process_status_flag ='P' --is null
6671: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6677: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f

6673: AND qpip.pricing_attribute IS NOT NULL
6674: AND qpip.pricing_attr_code IS NULL
6675: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6676: AND NOT EXISTS ( SELECT 'x'
6677: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6678: WHERE b.pricing_attribute_context = d.prc_context_code
6679: AND b.pricing_attribute = e.segment_mapping_column
6680: AND d.prc_context_id = e.prc_context_id
6681: AND d.prc_context_type = 'PRICING_ATTRIBUTE'

Line 6746: UPDATE qp_interface_pricing_attribs a

6742: AND e.request_id = p_request_id );
6743:
6744: ELSIF p_table_type = 'PRICING_ATTRIBS' THEN
6745:
6746: UPDATE qp_interface_pricing_attribs a
6747: SET process_status_flag = NULL --'E'
6748: WHERE a.request_id =p_request_id
6749: AND EXISTS
6750: (SELECT orig_sys_pricing_attr_ref

Line 6755: AND table_name ='QP_INTERFACE_PRICING_ATTRIBS'

6751: FROM qp_interface_errors e
6752: WHERE e.orig_sys_line_ref = a.orig_sys_line_ref
6753: AND e.orig_sys_header_ref = a.orig_sys_header_ref
6754: AND e.orig_sys_pricing_attr_ref = a.orig_sys_pricing_attr_ref
6755: AND table_name ='QP_INTERFACE_PRICING_ATTRIBS'
6756: AND e.request_id = p_request_id
6757: AND NVL(e.message_type, 'E') = 'E' --bug no: 9652756 - only if this is an error. b/c warning messages also goes into errors table
6758: );
6759: