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 400: SELECT qp_list_headers_b_s.nextval

396: l_count := 0; --Reset the mapping table count for each discount header
397:
398: --Select next discount_header_id
399:
400: SELECT qp_list_headers_b_s.nextval
401: INTO l_new_discount_header_id
402: FROM dual;
403:
404: --bug#6636843

Line 528: FROM qp_list_headers_b

524: --variable and then using it.
525: --,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(l_new_discount_header_id)
526: ,l_new_orig_system_hrd_Ref
527: --fix for bug 4673872
528: FROM qp_list_headers_b
529: WHERE list_header_id = qp_from_discounts_rec.list_header_id;
530:
531:
532: -- Object Security - sfiresto

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

753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)
756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
757: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
758: );
759:
760: END LOOP; /* For copying qualifiers */
761:

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

939: l_qp_discount_lines_rec.include_on_returns_flag,
940: l_qp_discount_lines_rec.qualification_ind
941: --ENH Upgrade BOAPI for orig_sys...ref RAVI
942: ,to_char(l_new_discount_line_id)
943: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
944: );
945:
946:
947: /*If the discount_line_rec is a Price Break Parent Line or Price Break Line

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

1095: l_pric_attr_value_to_number
1096: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1097: ,to_char(l_new_pricing_attribute_id)
1098: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1099: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1100: );
1101:
1102: END LOOP; /* For copying pricing attributes for each discount line */
1103:

Line 1417: From qp_list_headers_b a

1413: where a.list_header_id =q.list_header_id
1414: And a.list_type_code = 'PRL')
1415: /* and --Commented out for 2200425
1416: Exists (Select Null
1417: From qp_list_headers_b a
1418: Where a.list_header_id = p_from_list_header_id
1419: And a.list_type_code = 'PRL'
1420: )*/
1421: );

Line 1483: SELECT qp_list_headers_b_s.nextval

1479: /** Following code inserts price list header information **/
1480:
1481: -- Get next list_header_id
1482:
1483: SELECT qp_list_headers_b_s.nextval
1484: INTO l_new_list_header_id
1485: FROM dual;
1486:
1487: -- Insert Price List Header information

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

1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1849: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
1850: );
1851:
1852:
1853: END LOOP;

Line 2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)

2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);

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

2577: l_pric_attr_value_to_number
2578: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2579: ,to_char(l_new_pricing_attribute_id)
2580: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);