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 38: from qp_interface_pricing_attribs

34: if l_interface_action_code = 'INSERT' then
35: begin
36: select count(*)
37: into l_count1
38: from qp_interface_pricing_attribs
39: where orig_sys_line_ref = p_orig_sys_line_ref
40: and process_status_flag = 'P'
41: and request_id = p_request_id;
42: exception

Line 52: from qp_interface_pricing_attribs

48: if l_interface_action_code = 'UPDATE' then
49: begin
50: select count(*)
51: into l_count
52: from qp_interface_pricing_attribs
53: where orig_sys_line_ref = p_orig_sys_line_ref
54: and request_id = p_request_id
55: and process_status_flag = 'P'
56: and interface_action_code = 'INSERT';

Line 213: from qp_interface_pricing_attribs a, qp_interface_pricing_attribs b

209: -- Bug 5234939 RAVI START
210: ,a.orig_sys_pricing_attr_ref
211: ,b.orig_sys_pricing_attr_ref
212: -- Bug 5234939 RAVI END
213: from qp_interface_pricing_attribs a, qp_interface_pricing_attribs b
214: where a.request_id = p_request_id
215: and b.request_id = p_request_id
216: and a.process_status_flag ='P'
217: and b.interface_action_code IN ('INSERT', 'UPDATE')

Line 240: from qp_interface_pricing_attribs a, qp_pricing_attributes b

236: -- Bug 5234939 RAVI START
237: ,a.orig_sys_pricing_attr_ref
238: ,b.orig_sys_pricing_attr_ref
239: -- Bug 5234939 RAVI END
240: from qp_interface_pricing_attribs a, qp_pricing_attributes b
241: -- Bug 5234939 RAVI
242: where a.request_id = p_request_id
243: and a.process_status_flag ='P'
244: and b.orig_sys_line_ref <> a.orig_sys_line_ref

Line 252: from qp_interface_pricing_attribs c

248: and b.orig_sys_header_ref = a.orig_Sys_Header_Ref
249: -- Bug 5234939 RAVI
250: AND NOT EXISTS (SELECT /*+ no_unnest index(C QP_INTERFACE_PRCNG_ATTRIBS_N5) */ 'X' --bug 7433219
251:
252: from qp_interface_pricing_attribs c
253: where c.request_id = p_request_id
254: and c.orig_sys_pricing_attr_ref = b.orig_sys_pricing_attr_ref --bug 7433219
255: and c.interface_action_code IN ('UPDATE','DELETE')
256: );

Line 270: from qp_interface_pricing_attribs ipa

266: pricing_attribute,
267: pricing_attr_value_from,
268: pricing_attr_value_to,
269: comparison_operator_code
270: from qp_interface_pricing_attribs ipa
271: where request_id = p_request_id
272: and orig_sys_line_ref = l_orig_sys_line_ref
273: and orig_sys_pricing_attr_ref <> l_orig_sys_pricing_attr_ref
274: and pricing_attribute_context is not null

Line 293: from qp_interface_pricing_attribs c

289: and qpa.pricing_attribute is not null
290: and qpa.orig_sys_pricing_attr_ref <> l_orig_sys_pricing_attr_ref
291: and qpa.orig_sys_pricing_attr_ref NOT IN
292: (Select c.orig_sys_pricing_attr_ref
293: from qp_interface_pricing_attribs c
294: where c.orig_sys_line_ref = l_orig_sys_line_ref
295: and c.interface_action_code IN ('UPDATE','DELETE')
296: );
297: -- Bug 5234939 RAVI END

Line 449: from qp_interface_pricing_attribs a

445: If the line has pricing attributes (old or new) then the null pricing attribute
446: record (the default for the line) should not be considered.
447: **/
448: select count(*) into l_int_pr_attrbs_count
449: from qp_interface_pricing_attribs a
450: where a.orig_sys_line_ref=l_dup_lin_rec.a_orig_sys_line_ref(I)
451: and a.request_id = p_request_id;
452:
453: select count(*) into l_pr_attrbs_count

Line 597: from qp_interface_pricing_attribs

593: if i_mode = 1 then
594: begin
595: select count(*)
596: into l_count1
597: from qp_interface_pricing_attribs
598: where orig_sys_line_ref = l_dup_lin_rec.a_orig_sys_line_ref(I)
599: and process_status_flag = 'P'
600: and request_id = p_request_id;
601:

Line 604: from qp_interface_pricing_attribs

600: and request_id = p_request_id;
601:
602: select count(*)
603: into l_count2
604: from qp_interface_pricing_attribs
605: where orig_sys_line_ref = l_dup_lin_rec.b_orig_sys_line_ref(I)
606: and process_status_flag = 'P'
607: and request_id = p_request_id;
608: exception

Line 2023: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv

2019: l_exist :=0;
2020:
2021: begin
2022: select count(*) into l_exist
2023: from qp_interface_pricing_attribs qipa, mtl_system_items_vl msiv
2024: where qipa.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2025: and qipa.request_id = p_line_rec.request_id(I)
2026: and qipa.product_attribute_context = 'ITEM'
2027: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 2051: from qp_interface_pricing_attribs qipa

2047: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
2048: and msiv.service_item_flag = 'Y'
2049: and qpa.orig_sys_pricing_attr_ref not in (
2050: select qpa.orig_sys_pricing_attr_ref
2051: from qp_interface_pricing_attribs qipa
2052: where qipa.orig_sys_pricing_attr_ref = qpa.orig_sys_pricing_attr_ref
2053: and qipa.interface_action_code = 'DELETE'
2054: and qipa.request_id = p_line_rec.request_id(I));
2055: exception

Line 3464: qp_interface_pricing_attribs pa,

3460: SELECT 'OVERLAP'
3461: FROM qp_list_lines la,
3462: qp_rltd_modifiers ra,
3463: qp_rltd_modifiers rb,
3464: qp_interface_pricing_attribs pa,
3465: qp_pricing_attributes pb
3466: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3467: -- Bug 5246745 Use Composite Index for Ref columns
3468: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3482: from qp_interface_pricing_attribs pia

3478: -- Got Remaining Price Break Lines Values
3479: -- Bug# 5236432 RAVI
3480: AND pb.orig_sys_pricing_attr_ref NOT IN (
3481: select pia.orig_sys_pricing_attr_ref
3482: from qp_interface_pricing_attribs pia
3483: where pia.orig_sys_header_ref=pb.orig_sys_header_ref
3484: and pia.orig_sys_line_ref=pb.orig_sys_line_ref
3485: )
3486: -- Got the remaining Price Break Lines that are not being updated in this request

Line 3524: qp_interface_pricing_attribs pa,

3520: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
3521: FROM qp_list_lines la,
3522: qp_rltd_modifiers ra,
3523: qp_rltd_modifiers rb,
3524: qp_interface_pricing_attribs pa,
3525: qp_pricing_attributes pb
3526: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3527: -- Bug 5246745 Use Composite Index for Ref columns
3528: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3554: qp_interface_pricing_attribs pa,

3550: FROM qp_list_lines la,
3551: qp_list_lines lb,
3552: qp_rltd_modifiers ra,
3553: qp_rltd_modifiers rb,
3554: qp_interface_pricing_attribs pa,
3555: qp_interface_pricing_attribs pb
3556: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3557: -- Bug 5246745 Use Composite Index for Ref columns
3558: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3555: qp_interface_pricing_attribs pb

3551: qp_list_lines lb,
3552: qp_rltd_modifiers ra,
3553: qp_rltd_modifiers rb,
3554: qp_interface_pricing_attribs pa,
3555: qp_interface_pricing_attribs pb
3556: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3557: -- Bug 5246745 Use Composite Index for Ref columns
3558: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3559: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3578: qp_interface_pricing_attribs pa,

3574: SELECT count(*) l_from_value_old
3575: FROM qp_list_lines la,
3576: qp_rltd_modifiers ra,
3577: qp_rltd_modifiers rb,
3578: qp_interface_pricing_attribs pa,
3579: qp_pricing_attributes pb
3580: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3581: -- Bug 5246745 Use Composite Index for Ref columns
3582: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3607: qp_interface_pricing_attribs pa,

3603: FROM qp_list_lines la,
3604: qp_list_lines lb,
3605: qp_rltd_modifiers ra,
3606: qp_rltd_modifiers rb,
3607: qp_interface_pricing_attribs pa,
3608: qp_interface_pricing_attribs pb
3609: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3610: -- Bug 5246745 Use Composite Index for Ref columns
3611: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3608: qp_interface_pricing_attribs pb

3604: qp_list_lines lb,
3605: qp_rltd_modifiers ra,
3606: qp_rltd_modifiers rb,
3607: qp_interface_pricing_attribs pa,
3608: qp_interface_pricing_attribs pb
3609: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3610: -- Bug 5246745 Use Composite Index for Ref columns
3611: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3612: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3632: qp_interface_pricing_attribs pa,

3628: SELECT count(*) l_to_value_old
3629: FROM qp_list_lines la,
3630: qp_rltd_modifiers ra,
3631: qp_rltd_modifiers rb,
3632: qp_interface_pricing_attribs pa,
3633: qp_pricing_attributes pb
3634: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3635: -- Bug 5246745 Use Composite Index for Ref columns
3636: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3661: qp_interface_pricing_attribs pa,

3657: FROM qp_list_lines la,
3658: qp_list_lines lb,
3659: qp_rltd_modifiers ra,
3660: qp_rltd_modifiers rb,
3661: qp_interface_pricing_attribs pa,
3662: qp_interface_pricing_attribs pb
3663: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3664: -- Bug 5246745 Use Composite Index for Ref columns
3665: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3662: qp_interface_pricing_attribs pb

3658: qp_list_lines lb,
3659: qp_rltd_modifiers ra,
3660: qp_rltd_modifiers rb,
3661: qp_interface_pricing_attribs pa,
3662: qp_interface_pricing_attribs pb
3663: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3664: -- Bug 5246745 Use Composite Index for Ref columns
3665: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3666: AND ra.to_rltd_modifier_id = la.list_line_id

Line 3685: qp_interface_pricing_attribs pa,

3681: FROM qp_list_lines la,
3682: qp_list_lines lb,
3683: qp_rltd_modifiers ra,
3684: qp_rltd_modifiers rb,
3685: qp_interface_pricing_attribs pa,
3686: qp_interface_pricing_attribs pb
3687: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3688: -- Bug 5246745 Use Composite Index for Ref columns
3689: AND la.orig_sys_header_ref = p_orig_sys_header_ref

Line 3686: qp_interface_pricing_attribs pb

3682: qp_list_lines lb,
3683: qp_rltd_modifiers ra,
3684: qp_rltd_modifiers rb,
3685: qp_interface_pricing_attribs pa,
3686: qp_interface_pricing_attribs pb
3687: WHERE la.orig_sys_line_ref = p_orig_sys_line_ref
3688: -- Bug 5246745 Use Composite Index for Ref columns
3689: AND la.orig_sys_header_ref = p_orig_sys_header_ref
3690: AND ra.to_rltd_modifier_id = la.list_line_id

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

3725: --Initially setting the message context.
3726:
3727: l_msg_rec.REQUEST_ID := P_PRICING_ATTR_REC.REQUEST_ID(I);
3728: l_msg_rec.ENTITY_TYPE := 'PRL';
3729: l_msg_rec.TABLE_NAME := 'QP_INTERFACE_PRICING_ATTRIBS';
3730: l_msg_rec.ORIG_SYS_HEADER_REF := p_pricing_attr_rec.orig_sys_header_ref(I);
3731: l_msg_rec.ORIG_SYS_LINE_REF := p_pricing_attr_rec.orig_sys_line_ref(I);
3732: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
3733: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := p_pricing_attr_rec.orig_sys_pricing_attr_ref(I);

Line 3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3762: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3763: THEN --Check if item is purchasing enabled
3764: Begin
3765: select count(*) into l_pa_count
3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3767: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3768: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3769: and qipa.product_attribute_context = 'ITEM'
3770: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3782: from qp_interface_pricing_attribs qipa, mtl_system_items msi

3778: End;
3779: ELSE --Check if item is orderable
3780: Begin
3781: select count(*) into l_pa_count
3782: from qp_interface_pricing_attribs qipa, mtl_system_items msi
3783: where qipa.orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3784: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3785: and qipa.product_attribute_context = 'ITEM'
3786: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'

Line 3865: FROM qp_interface_pricing_attribs

3861: IF p_pricing_attr_rec.interface_action_code(I) = 'INSERT' THEN
3862: l_exist:=null;
3863: BEGIN
3864: SELECT count(*) INTO l_exist
3865: FROM qp_interface_pricing_attribs
3866: WHERE request_id = p_pricing_attr_rec.request_id(I)
3867: AND orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
3868: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3869: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 3969: FROM qp_interface_pricing_attribs

3965: qp_bulk_loader_pub.write_log('Count of records in Pricing Attr table with pricing contect/attr/value null' || to_char(l_exist));
3966: l_exist1:=null;
3967: BEGIN
3968: SELECT count(*) INTO l_exist1
3969: FROM qp_interface_pricing_attribs
3970: WHERE request_id = p_pricing_attr_rec.request_id(I)
3971: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3972: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
3973: AND orig_sys_pricing_attr_ref <> p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)

Line 4016: FROM qp_interface_pricing_attribs

4012:
4013: l_exist1:=null;
4014: BEGIN
4015: SELECT count(*) INTO l_exist1
4016: FROM qp_interface_pricing_attribs
4017: WHERE request_id = p_pricing_attr_rec.request_id(I)
4018: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4019: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4020: AND orig_sys_pricing_attr_ref <> p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)

Line 4097: FROM qp_interface_pricing_attribs

4093: BEGIN
4094: l_exist1 := NULL;
4095: SELECT /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N2) */ --7433219
4096: count(*) INTO l_exist1
4097: FROM qp_interface_pricing_attribs
4098: WHERE request_id = p_pricing_attr_rec.request_id(I)
4099: AND process_status_flag = 'P' --is null
4100: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4101: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)

Line 4288: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,

4284: l_exist := 0;
4285: begin
4286: SELECT 1
4287: into l_exist
4288: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d,
4289: qp_segments_b e, qp_pte_segments f
4290: WHERE orig_sys_pricing_attr_ref = p_pricing_attr_rec.orig_sys_pricing_attr_ref(I)
4291: AND b.product_attribute_context = d.prc_context_code
4292: AND b.product_attribute = e.segment_mapping_column

Line 4426: FROM qp_list_lines l, qp_interface_pricing_attribs a

4422: BEGIN
4423: l_count := null;
4424: SELECT count(*)
4425: INTO l_count
4426: FROM qp_list_lines l, qp_interface_pricing_attribs a
4427: WHERE l.orig_sys_line_ref = a.orig_sys_line_ref
4428: AND l.orig_sys_header_ref = a.orig_sys_header_ref
4429: AND a.orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I)
4430: AND a.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context(I)

Line 4517: qp_interface_pricing_attribs pb,

4513: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
4514: UNION
4515: SELECT /*+ leading(la) */ /*DISTINCT pb.pricing_attribute
4516: FROM qp_list_lines la,
4517: qp_interface_pricing_attribs pb,
4518: qp_rltd_modifiers ra
4519: WHERE ra.to_rltd_modifier_id = la.list_line_id
4520: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4521: AND pb.request_id = p_pricing_attr_rec.request_id(I)

Line 4539: qp_interface_pricing_attribs pb

4535: FROM qp_list_lines la,
4536: qp_rltd_modifiers ra,
4537: qp_rltd_modifiers rb,
4538: qp_list_lines lb,
4539: qp_interface_pricing_attribs pb
4540: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND
4541: la.list_line_type_code = 'PLL' AND
4542: la.pricing_phase_id = 1 AND
4543: ra.to_rltd_modifier_id = la.list_line_id AND

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

6111: orig_sys_pricing_attr_ref,error_message)
6112: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6113: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6119: WHERE qpil.request_id = p_request_id

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

6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6119: WHERE qpil.request_id = p_request_id
6120: AND qpip.request_id = p_request_id -- bug no 5881528
6121: AND qpil.process_status_flag ='P' --is null
6122: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6197: orig_sys_pricing_attr_ref,error_message)
6198: SELECT
6199: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6205: WHERE qpil.request_id = p_request_id

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

6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6205: WHERE qpil.request_id = p_request_id
6206: AND qpip.request_id = p_request_id -- bug no 5881528
6207: AND qpil.process_status_flag ='P' --is null
6208: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6463: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6461: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6462: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6463: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6464: WHERE qpil.request_id = p_request_id
6465: AND qpip.request_id = p_request_id -- bug no 5881528
6466: AND qpil.process_status_flag ='P' --is null
6467: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6467: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
6468: AND qpip.pricing_attribute_context IS NULL
6469: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6470: AND EXISTS ( 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 = e.segment_mapping_column
6474: and e.segment_code = b.product_attr_code
6475: AND d.prc_context_id = e.prc_context_id

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

6479: AND f.segment_level <> 'LINE'
6480: AND qpip.rowid = b.rowid
6481: union
6482: SELECT 'x'
6483: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6484: WHERE b.product_attribute_context = d.prc_context_code
6485: AND b.product_attribute is NULL and e.segment_code = b.product_attr_code
6486: AND d.prc_context_id = e.prc_context_id
6487: AND d.prc_context_type = 'PRODUCT'

Line 6512: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6510: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6511: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6512: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6513: WHERE qpil.request_id = p_request_id
6514: AND qpip.request_id = p_request_id -- bug no 5881528
6515: AND qpil.process_status_flag ='P' --is null
6516: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6519: AND qpip.product_attr_code IS NOT NULL
6520: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6521: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6522: AND NOT EXISTS ( SELECT 'x'
6523: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6524: WHERE b.product_attribute_context = d.prc_context_code
6525: AND b.product_attribute = e.segment_mapping_column
6526: and e.segment_code = b.product_attr_code
6527: AND d.prc_context_id = e.prc_context_id

Line 6545: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6543: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6544: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6545: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6546: WHERE qpil.request_id = p_request_id
6547: AND qpip.request_id = p_request_id -- bug no 5881528
6548: AND qpil.process_status_flag ='P' --is null
6549: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6552: AND qpip.product_attr_code IS NOT NULL
6553: AND qpip.product_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6554: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6555: AND NOT EXISTS ( SELECT 'x'
6556: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6557: WHERE b.product_attribute_context = d.prc_context_code
6558: and e.segment_code = b.product_attr_code
6559: AND d.prc_context_id = e.prc_context_id
6560: AND d.prc_context_type = 'PRODUCT'

Line 6577: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6575: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6576: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6577: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6578: WHERE qpil.request_id = p_request_id
6579: AND qpip.request_id = p_request_id -- bug no 5881528
6580: AND qpil.process_status_flag ='P' --is null
6581: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6583: AND qpip.product_attribute IS NOT NULL
6584: AND qpip.product_attr_code IS NULL
6585: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6586: AND NOT EXISTS ( SELECT 'x'
6587: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6588: WHERE b.product_attribute_context = d.prc_context_code
6589: AND b.product_attribute = e.segment_mapping_column
6590: AND d.prc_context_id = e.prc_context_id
6591: AND d.prc_context_type = 'PRODUCT'

Line 6614: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6612: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6613: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6614: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6615: WHERE qpil.request_id = p_request_id
6616: AND qpip.request_id = p_request_id -- bug no 5881528
6617: AND qpil.process_status_flag ='P' --is null
6618: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6621: AND qpip.pricing_attr_code IS NOT NULL
6622: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6623: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6624: AND NOT EXISTS ( SELECT 'x'
6625: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6626: WHERE b.pricing_attribute_context = d.prc_context_code
6627: AND b.pricing_attribute = e.segment_mapping_column
6628: and e.segment_code = b.pricing_attr_code
6629: AND d.prc_context_id = e.prc_context_id

Line 6647: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6645: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6646: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6647: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6648: WHERE qpil.request_id = p_request_id
6649: AND qpip.request_id = p_request_id -- bug no 5881528
6650: AND qpil.process_status_flag ='P' --is null
6651: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6654: AND qpip.pricing_attr_code IS NOT NULL
6655: AND qpip.pricing_attr_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6656: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6657: AND NOT EXISTS ( SELECT 'x'
6658: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6659: WHERE b.pricing_attribute_context = d.prc_context_code
6660: and e.segment_code = b.pricing_attr_code
6661: AND d.prc_context_id = e.prc_context_id
6662: AND d.prc_context_type = 'PRICING_ATTRIBUTE'

Line 6679: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6677: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6678: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6679: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6680: WHERE qpil.request_id = p_request_id
6681: AND qpip.request_id = p_request_id -- bug no 5881528
6682: AND qpil.process_status_flag ='P' --is null
6683: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6685: AND qpip.pricing_attribute IS NOT NULL
6686: AND qpip.pricing_attr_code IS NULL
6687: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6688: AND NOT EXISTS ( SELECT 'x'
6689: FROM qp_interface_pricing_attribs b, qp_prc_contexts_b d, qp_segments_b e, qp_pte_segments f
6690: WHERE b.pricing_attribute_context = d.prc_context_code
6691: AND b.pricing_attribute = e.segment_mapping_column
6692: AND d.prc_context_id = e.prc_context_id
6693: AND d.prc_context_type = 'PRICING_ATTRIBUTE'

Line 6758: UPDATE qp_interface_pricing_attribs a

6754: AND e.request_id = p_request_id );
6755:
6756: ELSIF p_table_type = 'PRICING_ATTRIBS' THEN
6757:
6758: UPDATE qp_interface_pricing_attribs a
6759: SET process_status_flag = NULL --'E'
6760: WHERE a.request_id =p_request_id
6761: AND EXISTS
6762: (SELECT orig_sys_pricing_attr_ref

Line 6767: AND table_name ='QP_INTERFACE_PRICING_ATTRIBS'

6763: FROM qp_interface_errors e
6764: WHERE e.orig_sys_line_ref = a.orig_sys_line_ref
6765: AND e.orig_sys_header_ref = a.orig_sys_header_ref
6766: AND e.orig_sys_pricing_attr_ref = a.orig_sys_pricing_attr_ref
6767: AND table_name ='QP_INTERFACE_PRICING_ATTRIBS'
6768: AND e.request_id = p_request_id );
6769:
6770: END IF;
6771: