APPS.JMF_SHIKYU_ONT_PVT dependencies on QP_PRICE_LIST_PVT

Line 905: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),

901: -- the QP: Item Validation Organization profile option.
902: -- The following query was rewritten to select from the based table
903: -- QP_LIST_LINES, instead of the OE_PRICE_LIST_LINES view.
904:
905: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),
906: operand
907: INTO l_price_list_uom,
908: l_component_price
909: FROM qp_list_lines

Line 911: AND qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id

907: INTO l_price_list_uom,
908: l_component_price
909: FROM qp_list_lines
910: WHERE list_header_id = l_price_list_id
911: AND qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id
912: AND l_ship_date BETWEEN
913: NVL(start_date_active, l_ship_date - 1)
914: AND
915: NVL(end_date_active, l_ship_date + 1);