DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_BREAK_LINES

Line 2884: DELETE FROM QP_PRICE_BOOK_BREAK_LINES 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:
2884: DELETE FROM QP_PRICE_BOOK_BREAK_LINES WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);
2885: IF SQL%FOUND THEN
2886: COMMIT;
2887: END IF;
2888:

Line 4544: from QP_PRICE_BOOK_BREAK_LINES_V pbb

4540: and pba.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''PricingAttrEnabled'',''PricingAttrDisabled'') "PricingAttribute",
4541: DECODE((SELECT ''X''
4542: from dual
4543: where exists(SELECT ''X''
4544: from QP_PRICE_BOOK_BREAK_LINES_V pbb
4545: where pbb.PRICE_BOOK_LINE_DET_ID= PBLinDet.PRICE_BOOK_LINE_DET_ID
4546: and pbb.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''BreaksEnabled'',''BreaksDisabled'') "Breaks",
4547: ''MessageCheck'' "Messages",
4548: to_char(PBLinDet.LIST_PRICE,FND_CURRENCY.GET_FORMAT_MASK(PBHDR.CURRENCY_CODE,60)) "ListPriceDisp",

Line 4579: FROM QP_PRICE_BOOK_LINE_DETAILS_V LD, QP_PRICE_BOOK_BREAK_LINES_V pbk, qp_list_lines pll

4575: pbk.APPLICATION_METHOD_NAME "ApplicationMethodName",
4576: pbk.RECURRING_VALUE "RecurringValue")
4577: )
4578: )
4579: FROM QP_PRICE_BOOK_LINE_DETAILS_V LD, QP_PRICE_BOOK_BREAK_LINES_V pbk, qp_list_lines pll
4580: WHERE LD.PRICE_BOOK_LINE_DET_ID = pbk.PRICE_BOOK_LINE_DET_ID
4581: AND ld.list_line_id = pll.list_line_id
4582: AND LD.PRICE_BOOK_LINE_DET_ID = PBLinDet.PRICE_BOOK_LINE_DET_ID
4583: )