DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_LINE_DETAILS

Line 2889: DELETE FROM QP_PRICE_BOOK_LINE_DETAILS 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:
2889: DELETE FROM QP_PRICE_BOOK_LINE_DETAILS WHERE PRICE_BOOK_HEADER_ID in (p_price_book_header_id,d_price_book_header_id);
2890: IF SQL%FOUND THEN
2891: COMMIT;
2892: END IF;
2893:

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: )

Line 4589: FROM QP_PRICE_BOOK_LINE_DETAILS_V PBLinDet

4585: ,
4586: NULL)
4587: )
4588: )
4589: FROM QP_PRICE_BOOK_LINE_DETAILS_V PBLinDet
4590: WHERE PBLinDet.Price_Book_Line_Id = PBLin.Price_Book_Line_Id
4591: )
4592: ),
4593: DECODE((SELECT ''X''