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_COPY_PRICELIST_PVT dependencies on QP_LIST_HEADERS_B

Line 409: SELECT qp_list_headers_b_s.nextval

405: l_count := 0; --Reset the mapping table count for each discount header
406:
407: --Select next discount_header_id
408:
409: SELECT qp_list_headers_b_s.nextval
410: INTO l_new_discount_header_id
411: FROM dual;
412:
413: --bug#6636843

Line 537: FROM qp_list_headers_b

533: --variable and then using it.
534: --,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id)
535: ,l_new_orig_system_hrd_Ref
536: --fix for bug 4673872
537: FROM qp_list_headers_b
538: WHERE list_header_id = qp_from_discounts_rec.list_header_id;
539:
540:
541: -- Object Security - sfiresto

Line 766: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)
765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
766: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
767: );
768:
769: END LOOP; /* For copying qualifiers */
770:

Line 952: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

948: l_qp_discount_lines_rec.include_on_returns_flag,
949: l_qp_discount_lines_rec.qualification_ind
950: --ENH Upgrade BOAPI for orig_sys...ref RAVI
951: ,to_char(l_new_discount_line_id)
952: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
953: );
954:
955:
956: /*If the discount_line_rec is a Price Break Parent Line or Price Break Line

Line 1108: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

1104: l_pric_attr_value_to_number
1105: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1106: ,to_char(l_new_pricing_attribute_id)
1107: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1108: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1109: );
1110:
1111: END LOOP; /* For copying pricing attributes for each discount line */
1112: -------------------bug 8326619--------------------------------

Line 1138: FROM QP_LIST_HEADERS_B

1134: BEGIN
1135:
1136: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1137: INTO l_active_flag, l_list_type_code
1138: FROM QP_LIST_HEADERS_B
1139: WHERE LIST_HEADER_ID = l_new_discount_header_id;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN

Line 1280: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)
1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1280: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1281: );
1282:
1283: END LOOP; /* For copying qualifiers */---Added for bug 8326619
1284: -------------------bug 8326619--------------------------------

Line 1599: From qp_list_headers_b a

1595: where a.list_header_id =q.list_header_id
1596: And a.list_type_code = 'PRL')
1597: /* and --Commented out for 2200425
1598: Exists (Select Null
1599: From qp_list_headers_b a
1600: Where a.list_header_id = p_from_list_header_id
1601: And a.list_type_code = 'PRL'
1602: )*/
1603: );

Line 1665: SELECT qp_list_headers_b_s.nextval

1661: /** Following code inserts price list header information **/
1662:
1663: -- Get next list_header_id
1664:
1665: SELECT qp_list_headers_b_s.nextval
1666: INTO l_new_list_header_id
1667: FROM dual;
1668:
1669: -- Insert Price List Header information

Line 2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)

2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
2033: );
2034:
2035:
2036: END LOOP;

Line 2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441

2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2580: ,to_char(l_new_list_line_id) --bug#12423441
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2584: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2585: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);

Line 2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)

2760: l_pric_attr_value_to_number
2761: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2762: ,to_char(l_new_pricing_attribute_id)
2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);