DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 641: oe_order_headers_all b

637: DECODE (ozf_tp_util_queries.get_quota_unit,
638: 'A', (a.ordered_quantity*a.unit_selling_price)
639: , a.ordered_quantity ) unit
640: FROM oe_order_lines_all a,
641: oe_order_headers_all b
642: WHERE a.open_flag = 'Y'
643: AND a.cancelled_flag = 'N'
644: AND a.booked_flag = 'Y'
645: AND a.ship_to_org_id = p_ship_to_site_use_id