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.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1470: oe_order_headers_all oh

1466: NVL(ol.actual_shipment_date,ol.fulfillment_date) conv_date,
1467: oh.transactional_curr_code
1468: FROM ( SELECT /*+ no_merge */ DISTINCT INVENTORY_ITEM_ID FROM OZF_NA_PRODUCTS_TEMP ) na,
1469: oe_order_lines_all ol,
1470: oe_order_headers_all oh
1471: WHERE ol.inventory_item_id = na.inventory_item_id
1472: AND ol.flow_status_code IN ('SHIPPED','CLOSED')
1473: AND ol.cancelled_flag = 'N'
1474: AND ol.line_category_code <> 'RETURN'

Line 1568: oe_order_headers_all oh

1564: NVL(ol.actual_arrival_date,ol.fulfillment_date) conv_date,
1565: oh.transactional_curr_code
1566: FROM ( SELECT /*+ no_merge */ DISTINCT INVENTORY_ITEM_ID FROM OZF_NA_PRODUCTS_TEMP ) NA,
1567: oe_order_lines_all ol,
1568: oe_order_headers_all oh
1569: WHERE ol.inventory_item_id = na.inventory_item_id
1570: AND ol.open_flag = 'N'
1571: AND ol.cancelled_flag = 'N'
1572: AND ol.line_category_code = 'RETURN'