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_LIST_LINES

Line 70: FROM qp_list_lines a

66: THEN
67: BEGIN --begin2
68: SELECT Nvl(a.start_date_active, l_min_date), Nvl(a.end_date_active, l_max_date)
69: INTO l_b_start_date_active, l_b_end_date_active
70: FROM qp_list_lines a
71: WHERE a.orig_sys_header_ref = p_orig_sys_header_ref
72: AND a.orig_sys_line_ref = p_orig_sys_line_ref_b;
73: EXCEPTION --begin2
74: WHEN No_Data_Found

Line 76: qp_bulk_loader_pub.write_log(l_routine || ' date not found in qp_list_lines and qp_interface_list_lines');

72: AND a.orig_sys_line_ref = p_orig_sys_line_ref_b;
73: EXCEPTION --begin2
74: WHEN No_Data_Found
75: THEN
76: qp_bulk_loader_pub.write_log(l_routine || ' date not found in qp_list_lines and qp_interface_list_lines');
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END; --begin2
79: END; --begin1
80:

Line 379: qp_list_lines b

375: THEN
376: BEGIN
377: SELECT 'X' INTO l_dummy
378: FROM qp_rltd_modifiers qrm,
379: qp_list_lines b
380: WHERE b.orig_sys_header_ref = l_dup_line_rec.orig_sys_header_ref(i)
381: AND b.orig_sys_line_ref = l_dup_line_rec.b_orig_sys_line_ref(i)
382: AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
383: AND qrm.to_rltd_modifier_id = b.list_line_id;

Line 1711: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;

1707: l_msg_rec QP_BULK_MSG.Msg_Rec_Type;
1708: l_dummy NUMBER;
1709: l_dummy_1 NUMBER;
1710: l_exist NUMBER;
1711: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;
1712: l_art_opr QP_LIST_LINES.arithmetic_operator%type;
1713: l_list_header_id NUMBER:=null;
1714: l_orig_sys_header_ref VARCHAR2(50) := NULL;
1715: l_start_date date;

Line 1712: l_art_opr QP_LIST_LINES.arithmetic_operator%type;

1708: l_dummy NUMBER;
1709: l_dummy_1 NUMBER;
1710: l_exist NUMBER;
1711: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;
1712: l_art_opr QP_LIST_LINES.arithmetic_operator%type;
1713: l_list_header_id NUMBER:=null;
1714: l_orig_sys_header_ref VARCHAR2(50) := NULL;
1715: l_start_date date;
1716: l_line_flex_enabled VARCHAR2(1);

Line 1733: l_line_flex_enabled := get_flex_enabled_flag('QP_LIST_LINES');

1729: BEGIN
1730:
1731: qp_bulk_loader_pub.write_log('Entering Entity Line');
1732:
1733: l_line_flex_enabled := get_flex_enabled_flag('QP_LIST_LINES');
1734: qp_bulk_loader_pub.write_log('Flex enabled '||l_line_flex_enabled);
1735:
1736: FOR I IN 1..p_line_rec.orig_sys_line_ref.count
1737: LOOP

Line 1751: select qp_list_lines_s.nextval

1747: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;
1748:
1749: /*-- populating some internal fields --*/
1750: If p_line_rec.interface_action_code(I)='INSERT' THEN
1751: select qp_list_lines_s.nextval
1752: into p_line_rec.list_line_id(I)
1753: from dual;
1754: end if;
1755: p_line_rec.list_line_no(I):= p_line_rec.list_line_id(I);

Line 1927: from qp_list_lines

1923: qp_bulk_loader_pub.write_log('Line ref'|| p_line_rec.orig_sys_line_ref(I));
1924:
1925: BEGIN
1926: select count(*) into l_exist
1927: from qp_list_lines
1928: where orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1929: and orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I) ;
1930:
1931: EXCEPTION

Line 1978: from qp_list_lines qpll

1974: /*If p_line_rec.interface_action_code(I)='UPDATE' THEN
1975: l_exist:= NULL;
1976:
1977: select 1 INTO l_exist
1978: from qp_list_lines qpll
1979: WHERE qpll.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1980: and qpll.list_line_id is not null
1981: and qpll.list_line_id <> p_line_rec.list_line_id(I);
1982:

Line 2043: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2039: -- Bug# 5228560 RAVI START
2040: l_dummy:= null;
2041:
2042: select count(*) into l_dummy
2043: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2044: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2045: -- Bug 5246745 Use Composite Index for Ref columns
2046: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2047: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2069: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd

2065: p_LINE_rec.price_break_type_code(I) = 'POINT')
2066: THEN
2067: -- SELECT count(*)
2068: -- INTO l_dummy
2069: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd
2070: -- WHERE pl.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2071: -- AND rtd.from_rltd_modifier_id = pl.list_line_id
2072: -- AND cl.list_line_id = rtd.to_rltd_modifier_id
2073: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);

Line 2094: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2090: IF p_LINE_rec.arithmetic_operator(I) = 'BLOCK_PRICE' THEN
2091: l_dummy := null;
2092: IF p_LINE_rec.price_break_type_code(I) = 'RANGE' THEN
2093: select count(*) into l_dummy
2094: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2095: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2096: -- Bug 5246745 Use Composite Index for Ref columns
2097: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2098: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2113: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2109:
2110: l_dummy := null;
2111: IF p_LINE_rec.price_break_type_code(I) = 'POINT' THEN
2112: select count(*) into l_dummy
2113: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2114: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2115: -- Bug 5246745 Use Composite Index for Ref columns
2116: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2117: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

Line 2213: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3

2209:
2210: --Get the PBH details
2211: SELECT L2.price_break_type_code, L2.arithmetic_operator
2212: INTO l_pb_type_code, l_art_opr
2213: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2214: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2215: -- Bug 5246745 Use Composite Index for Ref columns
2216: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2217: and l1.list_line_id=l3.TO_RLTD_MODIFIER_ID

Line 2423: from qp_list_lines

2419: IF l_PBH_start_date is null THEN
2420: BEGIN
2421: select start_date_active, end_date_active
2422: into l_PBH_start_date, l_PBH_end_date
2423: from qp_list_lines
2424: where orig_sys_line_ref=p_line_rec.PRICE_BREAK_HEADER_REF(I)
2425: -- Bug 5246745 Use Composite Index for Ref columns
2426: and orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I);
2427: EXCEPTION

Line 2450: (p_flex_name =>'QP_LIST_LINES'

2446: IF l_line_flex_enabled = 'Y' THEN
2447: qp_bulk_loader_pub.write_log( 'Line Flex enabled ');
2448:
2449: IF NOT Init_Desc_Flex
2450: (p_flex_name =>'QP_LIST_LINES'
2451: ,p_context => p_line_rec.context(i)
2452: ,p_attribute1 => p_line_rec.attribute1(i)
2453: ,p_attribute2 => p_line_rec.attribute2(i)
2454: ,p_attribute3 => p_line_rec.attribute3(i)

Line 3349: FROM qp_list_lines la,

3345: /**
3346: Check for overlap of price breaks
3347: **/
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

Line 3409: FROM qp_list_lines la,

3405: **/
3406: SELECT count(*) old_break_pa_count,
3407: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
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

Line 3438: FROM qp_list_lines la,

3434: p_orig_sys_header_ref VARCHAR2) IS
3435: SELECT count(*) new_break_pa_count,
3436: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3437: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
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,

Line 3439: qp_list_lines lb,

3435: SELECT count(*) new_break_pa_count,
3436: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3437: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
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

Line 3463: FROM qp_list_lines la,

3459: Cursor C_from_value_old(p_orig_sys_line_ref VARCHAR2,
3460: -- Bug 5246745 Use Composite Index for Ref columns
3461: p_orig_sys_header_ref VARCHAR2) IS
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

Line 3491: FROM qp_list_lines la,

3487: Cursor C_from_value_new(p_orig_sys_line_ref VARCHAR2,
3488: -- Bug 5246745 Use Composite Index for Ref columns
3489: p_orig_sys_header_ref VARCHAR2) IS
3490: SELECT count(*) l_from_value_new
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,

Line 3492: qp_list_lines lb,

3488: -- Bug 5246745 Use Composite Index for Ref columns
3489: p_orig_sys_header_ref VARCHAR2) IS
3490: SELECT count(*) l_from_value_new
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

Line 3517: FROM qp_list_lines la,

3513: Cursor C_to_value_old(p_orig_sys_line_ref VARCHAR2,
3514: -- Bug 5246745 Use Composite Index for Ref columns
3515: p_orig_sys_header_ref VARCHAR2) IS
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

Line 3545: FROM qp_list_lines la,

3541: Cursor C_to_value_new(p_orig_sys_line_ref VARCHAR2,
3542: -- Bug 5246745 Use Composite Index for Ref columns
3543: p_orig_sys_header_ref VARCHAR2) IS
3544: SELECT count(*) l_to_value_new
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,

Line 3546: qp_list_lines lb,

3542: -- Bug 5246745 Use Composite Index for Ref columns
3543: p_orig_sys_header_ref VARCHAR2) IS
3544: SELECT count(*) l_to_value_new
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

Line 3569: FROM qp_list_lines la,

3565: p_orig_sys_header_ref VARCHAR2,
3566: p_request_id number) IS -- changes done by rassharm for bug no 6028305
3567: SELECT /*+ leading(la) index(pa QP_INTERFACE_PRCNG_ATTRIBS_N4) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ --7433219
3568: 'OVERLAP'
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,

Line 3570: qp_list_lines lb,

3566: p_request_id number) IS -- changes done by rassharm for bug no 6028305
3567: SELECT /*+ leading(la) index(pa QP_INTERFACE_PRCNG_ATTRIBS_N4) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ --7433219
3568: 'OVERLAP'
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

Line 3629: from qp_list_lines

3625: --List Line ID
3626: BEGIN
3627: select list_line_id
3628: into p_pricing_attr_rec.list_line_id(I)
3629: from qp_list_lines
3630: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3631: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
3632:
3633: EXCEPTION

Line 4206: SELECT /+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) / --bug 9247305

4202: THEN
4203: BEGIN
4204: --Bug# 5528754 RAVI
4205: --Check if the pricing attribute is for a PRICE BREAK
4206: SELECT /*+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) */ --bug 9247305
4207: r.rltd_modifier_grp_type
4208: INTO l_pa_price_break
4209: FROM qp_list_lines l, qp_rltd_modifiers r
4210: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)

Line 4209: FROM qp_list_lines l, qp_rltd_modifiers r

4205: --Check if the pricing attribute is for a PRICE BREAK
4206: SELECT /*+ index(l qp_list_lines_n11) index(r qp_rltd_modifiers_n2) */ --bug 9247305
4207: r.rltd_modifier_grp_type
4208: INTO l_pa_price_break
4209: FROM qp_list_lines l, qp_rltd_modifiers r
4210: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4211: -- Bug 5246745 Use Composite Index for Ref columns
4212: AND l.orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4213: AND r.to_rltd_modifier_id = l.list_line_id

Line 4242: FROM qp_list_lines

4238: IF p_pricing_attr_rec.process_status_flag(I)='P' THEN -- IS NULL THEN
4239:
4240: /* SELECT primary_uom_flag
4241: INTO l_primary_uom_flag
4242: FROM qp_list_lines
4243: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id(I);
4244:
4245: IF l_primary_uom_flag = 'Y'
4246: AND p_PRICING_ATTR_rec.product_attribute(I) <> 'PRICING_ATTRIBUTE3' THEN

Line 4253: FROM qp_list_lines l, qp_pricing_attributes a

4249: -- Bug# 5228284 RAVI
4250: -- Do not consider the line if it's already the primary flag
4251: SELECT count(*)
4252: INTO l_count
4253: FROM qp_list_lines l, qp_pricing_attributes a
4254: WHERE l.list_line_id = a.list_line_id
4255: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id(I)
4256: AND a.product_attribute_context=p_PRICING_ATTR_rec.product_attribute_context(I)
4257: AND a.product_attribute = p_PRICING_ATTR_rec.product_attribute(I)

Line 4271: FROM qp_list_lines

4267: */
4268: BEGIN
4269: SELECT primary_uom_flag
4270: INTO l_primary_uom_flag
4271: FROM qp_list_lines
4272: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id(I);
4273: EXCEPTION
4274: WHEN OTHERS THEN
4275: qp_bulk_loader_pub.write_log('9458481/10152629 smbalara 1 ');

Line 4283: from qp_list_lines

4279: qp_bulk_loader_pub.write_log('9458481/10152629 smbalara 2 :'||l_primary_uom_flag);
4280: --check for dates overlapping for lines with primary uom flag checked --smbalara 9458481/10152629 START
4281: select start_date_active, end_date_active , revision, list_header_id
4282: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
4283: from qp_list_lines
4284: where list_line_id = p_PRICING_ATTR_rec.list_line_id(I);
4285:
4286: IF l_primary_uom_flag = 'Y' AND p_PRICING_ATTR_rec.product_attribute(I) <> 'PRICING_ATTRIBUTE3' THEN
4287: qp_bulk_loader_pub.write_log('9458481/10152629 smbalara 3 ');

Line 4292: from qp_pricing_attributes b, qp_list_lines c

4288: l_count:=null;
4289: for c1 in
4290: (
4291: select b.list_line_id col2
4292: from qp_pricing_attributes b, qp_list_lines c
4293: where b.list_line_id <> p_PRICING_ATTR_rec.list_line_id(I)
4294: and b.list_line_id=c.list_line_id
4295: and c.primary_uom_flag='Y'
4296: and b.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context(I)

Line 4310: from qp_list_lines

4306: /*--------------------------------------------*/
4307: begin
4308: SELECT start_date_active, end_date_active
4309: into l_sdate, l_edate
4310: from qp_list_lines
4311: where list_line_id = c1.col2;
4312:
4313: exception
4314: when no_data_found then

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 4490: FROM qp_list_lines la,

4486: l_count:=null;
4487: /* SELECT COUNT(1) INTO l_count
4488: FROM
4489: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ /*DISTINCT pb.pricing_attribute
4490: FROM qp_list_lines la,
4491: qp_pricing_attributes pb,
4492: qp_rltd_modifiers ra
4493: WHERE ra.to_rltd_modifier_id = la.list_line_id
4494: AND pb.list_line_id = ra.to_rltd_modifier_id

Line 4496: from qp_rltd_modifiers, qp_list_lines

4492: qp_rltd_modifiers ra
4493: WHERE ra.to_rltd_modifier_id = la.list_line_id
4494: AND pb.list_line_id = ra.to_rltd_modifier_id
4495: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4496: from qp_rltd_modifiers, qp_list_lines
4497: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4498: -- Bug 5246745 Use Composite Index for Ref columns
4499: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4500: and to_rltd_modifier_id = list_line_id)

Line 4504: FROM qp_list_lines la,

4500: and to_rltd_modifier_id = list_line_id)
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

Line 4512: from qp_rltd_modifiers, qp_list_lines

4508: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4509: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4510: AND pb.process_status_flag = 'P' --IS NULL
4511: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4512: from qp_rltd_modifiers, qp_list_lines
4513: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4514: -- Bug 5246745 Use Composite Index for Ref columns
4515: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4516: and to_rltd_modifier_id = list_line_id)

Line 4523: FROM qp_list_lines la,

4519:
4520: SELECT COUNT(1) INTO l_count
4521: FROM
4522: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
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

Line 4526: qp_list_lines lb,

4522: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
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

Line 4540: FROM qp_list_lines la,

4536: pb.process_status_flag = 'P' AND --IS NULL AND
4537: rb.rltd_modifier_grp_type = 'PRICE BREAK'
4538: UNION
4539: SELECT /*+ leading(la) */ DISTINCT pb.pricing_attribute
4540: FROM qp_list_lines la,
4541: qp_pricing_attributes pb,
4542: qp_rltd_modifiers ra,
4543: qp_rltd_modifiers rb
4544: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND