DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 1066: Aso_quote_lines_all QL,

1062: -- Count(decode(nvl(OH.Booked_Flag,'N'),'N',Null,QH.order_id)) Item_Ordered_Frequency,
1063: SUM(get_item_count(ql.inventory_item_id,nvl(oh.header_id,0))) Item_Ordered_Frequency,
1064: Sum(decode(nvl(OH.Booked_Flag,'N'),'N',0, nvl(QL.Quantity,0))) AS Order_Quantity
1065: FROM Aso_quote_headers_all QH,
1066: Aso_quote_lines_all QL,
1067: OE_Order_Headers_ALL OH,
1068: Fnd_lookups fndlkp
1069: WHERE fndlkp.lookup_type = l_fact_source
1070: AND upper(Qh.Quote_Source_Code) = fndlkp.lookup_code