DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on OE_ORDER_LINES_ALL

Line 640: FROM oe_order_lines_all a,

636: , fnd_profile.value('OZF_TP_COMMON_UOM') ) to_unit,
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'