APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_ATTRIBUTES

Line 2879: DELETE FROM QP_PRICE_BOOK_ATTRIBUTES WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);

2875: END;
2876:
2877: -- Commiting after each delete as it will give rollback segment error if the data is huge
2878:
2879: DELETE FROM QP_PRICE_BOOK_ATTRIBUTES WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);
2880: IF SQL%FOUND THEN
2881: COMMIT;
2882: END IF;
2883:

Line 4538: from QP_PRICE_BOOK_ATTRIBUTES_V pba

4534: PBLinDet.PRICE_BREAK_TYPE "PriceBreakType",
4535: DECODE((SELECT ''X''
4536: from dual
4537: where exists(SELECT ''X''
4538: from QP_PRICE_BOOK_ATTRIBUTES_V pba
4539: where pba.PRICE_BOOK_LINE_DET_ID = PBLinDet.PRICE_BOOK_LINE_DET_ID
4540: and pba.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''PricingAttrEnabled'',''PricingAttrDisabled'') "PricingAttribute",
4541: DECODE((SELECT ''X''
4542: from dual

Line 4629: FROM QP_PRICE_BOOK_ATTRIBUTES_V QPPBATTRS

4625: QPPBATTRS.attribute_value_name "CategoryName",
4626: QPPBATTRS.PRICING_PROD_ATTR_VALUE_FROM "CategoryId")
4627: )
4628: )
4629: FROM QP_PRICE_BOOK_ATTRIBUTES_V QPPBATTRS
4630: WHERE QPPBATTRS.PRICE_BOOK_LINE_DET_ID = -1
4631: AND QPPBATTRS.ATTRIBUTE_TYPE = ''PRODUCT''
4632: AND QPPBATTRS.PRICING_PROD_CONTEXT = ''ITEM''
4633: AND QPPBATTRS.PRICING_PROD_ATTRIBUTE = ''PRICING_ATTRIBUTE2''