DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on OE_SYSTEM_PARAMETERS_ALL

Line 1013: OE_SYSTEM_PARAMETERS_ALL OSP

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
1017: AND OL.link_to_line_id is NULL