APPS.IBE_REPORTING_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 823: aso_quote_headers_all a,

819: SELECT DISTINCT
820: a.currency_code Transactional_Curr_Code,
821: to_date(pToDate,'yyyy/mm/dd hh24:mi:ss') ordered_date
822: FROM
823: aso_quote_headers_all a,
824: fnd_lookups fndlkp
825: WHERE
826: a.quote_header_id = (SELECT max(quote_header_id) quote_header_id
827: FROM aso_quote_headers_all

Line 827: FROM aso_quote_headers_all

823: aso_quote_headers_all a,
824: fnd_lookups fndlkp
825: WHERE
826: a.quote_header_id = (SELECT max(quote_header_id) quote_header_id
827: FROM aso_quote_headers_all
828: WHERE quote_number = a.quote_number)
829: AND ( (
830: fndlkp.lookup_code = upper(a.quote_source_code)
831: AND a.resource_id IS NULL )

Line 1065: FROM Aso_quote_headers_all QH,

1061: Sum(nvl(QL.Quantity,0)) AS Quote_Quantity,
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