eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_REPORTING_PVT dependencies on OE_ORDER_LINES_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 942: Oe_order_lines_all OL,

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,
946: fnd_lookups fndlkp

Line 1012: OE_ORDER_LINES_ALL OL,

1008: return_functional_amount(ol.inventory_item_id,osp.Master_Organization_id,ift.header_id,
1009: ol.item_type_code,OL.line_category_code,
1010: OL.ordered_Quantity,OL.Unit_Selling_Price,ift.conversion_rate) ) Reported_Amount
1011: FROM IBE_ECR_ORDER_HEADERS_FACT ift,
1012: OE_ORDER_LINES_ALL OL,
1013: OE_SYSTEM_PARAMETERS_ALL OSP
1014: WHERE ift.Header_id = OL.Header_id
1015: AND ift.fact_date between pFromDate and pToDate
1016: AND nvl(OL.cancelled_flag,'N') = l_cancelled_flag

Line 1781: from oe_order_lines_all ol

1777: begin
1778:
1779: select Sum((decode(OL.line_category_code,'RETURN',-1,1)* nvl(OL.ordered_Quantity,0))*
1780: (nvl(OL.Unit_Selling_Price,0))) into l_return_amount
1781: from oe_order_lines_all ol
1782: where header_id = p_order_header_id
1783: and exists
1784: ( select line_id from oe_order_lines_all x
1785: where x.inventory_item_id = p_inventory_item_id

Line 1784: ( select line_id from oe_order_lines_all x

1780: (nvl(OL.Unit_Selling_Price,0))) into l_return_amount
1781: from oe_order_lines_all ol
1782: where header_id = p_order_header_id
1783: and exists
1784: ( select line_id from oe_order_lines_all x
1785: where x.inventory_item_id = p_inventory_item_id
1786: and ol.top_model_line_id = x.top_model_line_id
1787: ) ;
1788: