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 122: from qp_list_lines

118:
119: Begin
120: SELECT start_date_active, end_date_active
121: into l_sdate, l_edate
122: from qp_list_lines
123: where orig_sys_line_ref=p_orig_sys_line_ref2
124: and orig_sys_header_ref = p_orig_sys_header_ref;
125: Exception
126: When no_data_found then

Line 581: from qp_rltd_modifiers qrm, qp_list_lines b

577: if i_mode = 2 then
578: begin
579: select 'x'
580: into l_dummy
581: from qp_rltd_modifiers qrm, qp_list_lines b
582: where b.orig_sys_header_ref = l_dup_lin_rec.orig_sys_header_ref(I)
583: and b.orig_sys_line_ref = l_dup_lin_rec.b_orig_sys_line_ref(I)
584: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'
585: and qrm.to_rltd_modifier_id = b.list_line_id;

Line 1867: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;

1863: l_msg_rec QP_BULK_MSG.Msg_Rec_Type;
1864: l_dummy NUMBER;
1865: l_dummy_1 NUMBER;
1866: l_exist NUMBER;
1867: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;
1868: l_art_opr QP_LIST_LINES.arithmetic_operator%type;
1869: l_list_header_id NUMBER:=null;
1870: l_orig_sys_header_ref VARCHAR2(50) := NULL;
1871: l_start_date date;

Line 1868: l_art_opr QP_LIST_LINES.arithmetic_operator%type;

1864: l_dummy NUMBER;
1865: l_dummy_1 NUMBER;
1866: l_exist NUMBER;
1867: l_pb_type_code QP_LIST_LINES.price_break_type_code%type;
1868: l_art_opr QP_LIST_LINES.arithmetic_operator%type;
1869: l_list_header_id NUMBER:=null;
1870: l_orig_sys_header_ref VARCHAR2(50) := NULL;
1871: l_start_date date;
1872: l_line_flex_enabled VARCHAR2(1);

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

1885: BEGIN
1886:
1887: qp_bulk_loader_pub.write_log('Entering Entity Line');
1888:
1889: l_line_flex_enabled := get_flex_enabled_flag('QP_LIST_LINES');
1890: qp_bulk_loader_pub.write_log('Flex enabled '||l_line_flex_enabled);
1891:
1892: FOR I IN 1..p_line_rec.orig_sys_line_ref.count
1893: LOOP

Line 1907: select qp_list_lines_s.nextval

1903: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;
1904:
1905: /*-- populating some internal fields --*/
1906: If p_line_rec.interface_action_code(I)='INSERT' THEN
1907: select qp_list_lines_s.nextval
1908: into p_line_rec.list_line_id(I)
1909: from dual;
1910: end if;
1911: p_line_rec.list_line_no(I):= p_line_rec.list_line_id(I);

Line 2083: from qp_list_lines

2079: qp_bulk_loader_pub.write_log('Line ref'|| p_line_rec.orig_sys_line_ref(I));
2080:
2081: BEGIN
2082: select count(*) into l_exist
2083: from qp_list_lines
2084: where orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2085: and orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I) ;
2086:
2087: EXCEPTION

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

2167: -- Bug# 5228560 RAVI START
2168: l_dummy:= null;
2169:
2170: select count(*) into l_dummy
2171: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2172: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2173: -- Bug 5246745 Use Composite Index for Ref columns
2174: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2175: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2193: p_LINE_rec.price_break_type_code(I) = 'POINT')
2194: THEN
2195: -- SELECT count(*)
2196: -- INTO l_dummy
2197: -- FROM qp_list_lines pl, qp_list_lines cl,qp_rltd_modifiers rtd
2198: -- WHERE pl.orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2199: -- AND rtd.from_rltd_modifier_id = pl.list_line_id
2200: -- AND cl.list_line_id = rtd.to_rltd_modifier_id
2201: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);

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

2218: IF p_LINE_rec.arithmetic_operator(I) = 'BLOCK_PRICE' THEN
2219: l_dummy := null;
2220: IF p_LINE_rec.price_break_type_code(I) = 'RANGE' THEN
2221: select count(*) into l_dummy
2222: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2223: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2224: -- Bug 5246745 Use Composite Index for Ref columns
2225: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2226: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2237:
2238: l_dummy := null;
2239: IF p_LINE_rec.price_break_type_code(I) = 'POINT' THEN
2240: select count(*) into l_dummy
2241: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2242: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2243: -- Bug 5246745 Use Composite Index for Ref columns
2244: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2245: and l1.list_line_id=l3.FROM_RLTD_MODIFIER_ID

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

2337:
2338: --Get the PBH details
2339: SELECT L2.price_break_type_code, L2.arithmetic_operator
2340: INTO l_pb_type_code, l_art_opr
2341: from qp_list_lines l1, qp_list_lines l2, qp_rltd_modifiers l3
2342: where l1.orig_sys_line_ref=p_LINE_rec.orig_sys_line_ref(I)
2343: -- Bug 5246745 Use Composite Index for Ref columns
2344: and l1.orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2345: and l1.list_line_id=l3.TO_RLTD_MODIFIER_ID

Line 2551: from qp_list_lines

2547: IF l_PBH_start_date is null THEN
2548: BEGIN
2549: select start_date_active, end_date_active
2550: into l_PBH_start_date, l_PBH_end_date
2551: from qp_list_lines
2552: where orig_sys_line_ref=p_line_rec.PRICE_BREAK_HEADER_REF(I)
2553: -- Bug 5246745 Use Composite Index for Ref columns
2554: and orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I);
2555: EXCEPTION

Line 2578: (p_flex_name =>'QP_LIST_LINES'

2574: IF l_line_flex_enabled = 'Y' THEN
2575: qp_bulk_loader_pub.write_log( 'Line Flex enabled ');
2576:
2577: IF NOT Init_Desc_Flex
2578: (p_flex_name =>'QP_LIST_LINES'
2579: ,p_context => p_line_rec.context(i)
2580: ,p_attribute1 => p_line_rec.attribute1(i)
2581: ,p_attribute2 => p_line_rec.attribute2(i)
2582: ,p_attribute3 => p_line_rec.attribute3(i)

Line 3461: FROM qp_list_lines la,

3457: /**
3458: Check for overlap of price breaks
3459: **/
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

Line 3521: FROM qp_list_lines la,

3517: **/
3518: SELECT count(*) old_break_pa_count,
3519: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
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

Line 3550: FROM qp_list_lines la,

3546: p_orig_sys_header_ref VARCHAR2) IS
3547: SELECT count(*) new_break_pa_count,
3548: min(to_number(pb.pricing_attr_value_from)) new_break_low_value,
3549: max(to_number(pb.pricing_attr_value_to)) new_break_high_value
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,

Line 3551: qp_list_lines lb,

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

Line 3575: FROM qp_list_lines la,

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

Line 3603: FROM qp_list_lines la,

3599: Cursor C_from_value_new(p_orig_sys_line_ref VARCHAR2,
3600: -- Bug 5246745 Use Composite Index for Ref columns
3601: p_orig_sys_header_ref VARCHAR2) IS
3602: SELECT count(*) l_from_value_new
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,

Line 3604: qp_list_lines lb,

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

Line 3629: FROM qp_list_lines la,

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

Line 3657: FROM qp_list_lines la,

3653: Cursor C_to_value_new(p_orig_sys_line_ref VARCHAR2,
3654: -- Bug 5246745 Use Composite Index for Ref columns
3655: p_orig_sys_header_ref VARCHAR2) IS
3656: SELECT count(*) l_to_value_new
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,

Line 3658: qp_list_lines lb,

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

Line 3681: FROM qp_list_lines la,

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

Line 3682: qp_list_lines lb,

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

Line 3741: from qp_list_lines

3737: --List Line ID
3738: BEGIN
3739: select list_line_id
3740: into p_pricing_attr_rec.list_line_id(I)
3741: from qp_list_lines
3742: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
3743: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
3744:
3745: EXCEPTION

Line 4320: FROM qp_list_lines l, qp_rltd_modifiers r

4316: --Bug# 5528754 RAVI
4317: --Check if the pricing attribute is for a PRICE BREAK
4318: SELECT r.rltd_modifier_grp_type
4319: INTO l_pa_price_break
4320: FROM qp_list_lines l, qp_rltd_modifiers r
4321: WHERE l.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4322: -- Bug 5246745 Use Composite Index for Ref columns
4323: AND l.orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4324: AND r.to_rltd_modifier_id = l.list_line_id

Line 4352: FROM qp_list_lines

4348: IF p_pricing_attr_rec.process_status_flag(I)='P' THEN -- IS NULL THEN
4349:
4350: SELECT primary_uom_flag
4351: INTO l_primary_uom_flag
4352: FROM qp_list_lines
4353: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id(I);
4354:
4355: IF l_primary_uom_flag = 'Y'
4356: AND p_PRICING_ATTR_rec.product_attribute(I) <> 'PRICING_ATTRIBUTE3' THEN

Line 4363: FROM qp_list_lines l, qp_pricing_attributes a

4359: -- Bug# 5228284 RAVI
4360: -- Do not consider the line if it's already the primary flag
4361: SELECT count(*)
4362: INTO l_count
4363: FROM qp_list_lines l, qp_pricing_attributes a
4364: WHERE l.list_line_id = a.list_line_id
4365: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id(I)
4366: AND a.product_attribute_context=p_PRICING_ATTR_rec.product_attribute_context(I)
4367: AND a.product_attribute = p_PRICING_ATTR_rec.product_attribute(I)

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

4498: l_count:=null;
4499: /* SELECT COUNT(1) INTO l_count
4500: FROM
4501: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ /*DISTINCT pb.pricing_attribute
4502: FROM qp_list_lines la,
4503: qp_pricing_attributes pb,
4504: qp_rltd_modifiers ra
4505: WHERE ra.to_rltd_modifier_id = la.list_line_id
4506: AND pb.list_line_id = ra.to_rltd_modifier_id

Line 4508: from qp_rltd_modifiers, qp_list_lines

4504: qp_rltd_modifiers ra
4505: WHERE ra.to_rltd_modifier_id = la.list_line_id
4506: AND pb.list_line_id = ra.to_rltd_modifier_id
4507: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4508: from qp_rltd_modifiers, qp_list_lines
4509: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4510: -- Bug 5246745 Use Composite Index for Ref columns
4511: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4512: and to_rltd_modifier_id = list_line_id)

Line 4516: FROM qp_list_lines la,

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

Line 4524: from qp_rltd_modifiers, qp_list_lines

4520: AND pb.orig_sys_line_ref = la.orig_sys_line_ref
4521: AND pb.request_id = p_pricing_attr_rec.request_id(I)
4522: AND pb.process_status_flag = 'P' --IS NULL
4523: AND ra.from_rltd_modifier_id = (select from_rltd_modifier_id
4524: from qp_rltd_modifiers, qp_list_lines
4525: where orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4526: -- Bug 5246745 Use Composite Index for Ref columns
4527: and orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I)
4528: and to_rltd_modifier_id = list_line_id)

Line 4535: FROM qp_list_lines la,

4531:
4532: SELECT COUNT(1) INTO l_count
4533: FROM
4534: (SELECT /*+ ordered leading(la) index(pb QP_INTERFACE_PRCNG_ATTRIBS_N4) */ DISTINCT pb.pricing_attribute
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

Line 4538: qp_list_lines lb,

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

Line 4552: FROM qp_list_lines la,

4548: pb.process_status_flag = 'P' AND --IS NULL AND
4549: rb.rltd_modifier_grp_type = 'PRICE BREAK'
4550: UNION
4551: SELECT /*+ leading(la) */ DISTINCT pb.pricing_attribute
4552: FROM qp_list_lines la,
4553: qp_pricing_attributes pb,
4554: qp_rltd_modifiers ra,
4555: qp_rltd_modifiers rb
4556: WHERE la.orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I) AND