DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on OE_BLANKET_LINES_EXT

Line 1007: FROM oe_blanket_lines_all a, oe_blanket_lines_ext b

1003: IF p_pb_input_header_rec.price_based_on = 'BSA' THEN
1004: BEGIN
1005: SELECT a.price_list_id
1006: INTO l_bsa_line_price_list_id
1007: FROM oe_blanket_lines_all a, oe_blanket_lines_ext b
1008: WHERE a.header_id = p_pb_input_header_rec.pl_agr_bsa_id
1009: AND a.line_id = b.line_id
1010: AND a.inventory_item_id = l_item_number_tbl(ii)
1011: AND p_pb_input_header_rec.effective_date BETWEEN