APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_HEADERS_V

Line 983: FROM qp_price_book_headers_vl

979: --Check if a corresponding full price book exists
980: BEGIN
981: SELECT 1
982: INTO l_count
983: FROM qp_price_book_headers_vl
984: WHERE price_book_name = p_pb_input_header_rec.price_book_name
985: AND price_book_type_code = 'F'
986: AND customer_id = p_pb_input_header_rec.customer_attr_value
987: AND rownum = 1;

Line 1396: FROM qp_price_book_headers_vl

1392: --The price book to be re-published must exist
1393: BEGIN
1394: SELECT 1
1395: INTO l_count
1396: FROM qp_price_book_headers_vl
1397: WHERE price_book_name = p_pb_input_header_rec.price_book_name
1398: AND price_book_type_code = p_pb_input_header_rec.price_book_type_code
1399: AND customer_id = p_pb_input_header_rec.customer_attr_value
1400: AND rownum = 1;

Line 1428: FROM qp_price_book_headers_vl

1424: --Check that Price Book(s) to be generated does(do) not exist
1425: BEGIN
1426: SELECT 1
1427: INTO l_count
1428: FROM qp_price_book_headers_vl
1429: WHERE price_book_name = p_pb_input_header_rec.price_book_name
1430: AND price_book_type_code = p_pb_input_header_rec.price_book_type_code
1431: AND customer_id = p_pb_input_header_rec.customer_attr_value
1432: AND rownum = 1;

Line 2857: from QP_PRICE_BOOK_HEADERS_V

2853:
2854: BEGIN
2855: SELECT CUSTOMER_ID,PB_INPUT_HEADER_ID,PRICE_BOOK_NAME,DOCUMENT_ID
2856: into l_customer_id,l_pb_input_header_id ,l_price_book_name,l_document_id
2857: from QP_PRICE_BOOK_HEADERS_V
2858: WHERE PRICE_BOOK_HEADER_ID = p_price_book_header_id;
2859: EXCEPTION
2860: when no_data_found then
2861: null;

Line 2867: FROM QP_PRICE_BOOK_HEADERS_V

2863:
2864: BEGIN
2865: SELECT PB_INPUT_HEADER_ID,PRICE_BOOK_HEADER_ID,DOCUMENT_ID
2866: into d_pb_input_header_id,d_price_book_header_id, d_document_id
2867: FROM QP_PRICE_BOOK_HEADERS_V
2868: WHERE PRICE_BOOK_HEADER_ID <> p_price_book_header_id AND
2869: PRICE_BOOK_NAME = l_price_book_name and
2870: PRICE_BOOK_TYPE_CODE = 'D' and
2871: CUSTOMER_ID = l_customer_id;

Line 4645: FROM QP_PRICE_BOOK_HEADERS_V PBHDR

4641: WHERE PBLin.Price_Book_Header_Id = PBHDR.Price_Book_Header_Id
4642: )
4643: )
4644: ) as "PriceBookHeadersVO"
4645: FROM QP_PRICE_BOOK_HEADERS_V PBHDR
4646: WHERE PRICE_BOOK_HEADER_ID = :PBHDRID');
4647: -- Set the row header to be QP_PRICE_BOOK
4648: DBMS_XMLQUERY.setRowSetTag(l_qryCtx, 'QP_PRICE_BOOK');
4649: DBMS_XMLQUERY.setRowTag(l_qryCtx, NULL);