DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on OE_BLANKET_LINES_ALL

Line 989: FROM oe_blanket_lines_all a, oe_blanket_lines_ext b

985: IF p_pb_input_header_rec.price_based_on = 'BSA' THEN
986: BEGIN
987: SELECT a.price_list_id
988: INTO l_bsa_line_price_list_id
989: FROM oe_blanket_lines_all a, oe_blanket_lines_ext b
990: WHERE a.header_id = p_pb_input_header_rec.pl_agr_bsa_id
991: AND a.line_id = b.line_id
992: AND a.inventory_item_id = l_item_number_tbl(ii)
993: AND p_pb_input_header_rec.effective_date BETWEEN