APPS.IBE_REPORTING_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 105: from oe_order_lines_all ol , oe_order_headers_all oh

101:
102:
103: cursor get_count(l_inventory_item_id number,l_header_id number) is
104: select count(distinct nvl(oh.order_number,0))
105: from oe_order_lines_all ol , oe_order_headers_all oh
106: WHERE oh.header_id = l_header_id and
107: oh.header_id = ol.header_id and
108: nvl(OH.cancelled_flag,'N') = 'N' and
109: nvl(oh.booked_flag,'N')= 'Y' and

Line 809: oe_order_headers_all oh,

805: OH.Transactional_Curr_Code,
806: trunc(oh.ordered_date) ordered_date
807: FROM
808: Oe_order_Sources OS,
809: oe_order_headers_all oh,
810: fnd_lookups fndlkp
811: WHERE
812: nvl(oh.booked_flag,'N') = 'Y'
813: AND nvl(oh.cancelled_flag,'N') = 'N'

Line 941: Oe_order_headers_all OH,

937: gl_currency_api.convert_amount_sql(OH.Transactional_Curr_Code,p_currency_code,trunc(oh.ordered_date),
938: g_conversionType,nvl(OL.Unit_Selling_Price,0))) Reported_Amount,
939: hca.customer_class_code, hca.party_id
940: FROM Oe_order_Sources OS,
941: Oe_order_headers_all OH,
942: Oe_order_lines_all OL,
943: hz_cust_accounts hca,
944: hz_cust_site_uses_all hcsu,
945: hz_cust_acct_sites_all hcas,

Line 1067: OE_Order_Headers_ALL OH,

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
1071: AND QH.Creation_Date between pFromDate and pToDate