DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on OE_ORDER_SOURCES

Line 808: Oe_order_Sources OS,

804: SELECT DISTINCT
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'

Line 940: FROM Oe_order_Sources OS,

936: Sum((decode(OL.line_category_code,'RETURN',-1,1)* nvl(OL.Pricing_Quantity,0))*
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,