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 1573: oe_order_headers_all oh

1569: ol.shipping_quantity_uom2, -- Catch Weight ER
1570: ol.fulfillment_base -- Catch Weight ER
1571: FROM ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) na,
1572: oe_order_lines_all ol,
1573: oe_order_headers_all oh
1574: WHERE ol.inventory_item_id = na.inventory_item_id
1575: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1576: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <> 'RETURN'
1577: AND OL.ACTUAL_SHIPMENT_DATE IS NOT NULL

Line 1605: oe_order_headers_all oh

1601: ol.shipping_quantity_uom2, -- Catch Weight ER
1602: ol.fulfillment_base -- Catch Weight ER
1603: FROM ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) na,
1604: oe_order_lines_all ol,
1605: oe_order_headers_all oh
1606: WHERE ol.inventory_item_id = na.inventory_item_id
1607: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1608: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <> 'RETURN'
1609: AND OL.ACTUAL_SHIPMENT_DATE IS NULL

Line 1633: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH

1629: OL.SHIPPING_QUANTITY_UOM2, -- Catch Weight ER
1630: OL.FULFILLMENT_BASE -- Catch Weight ER
1631: FROM
1632: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) NA,
1633: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH
1634: WHERE
1635: OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1636: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1637: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <>'RETURN'

Line 1656: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH

1652: OL.SHIPPING_QUANTITY_UOM2, -- Catch Weight ER
1653: OL.FULFILLMENT_BASE -- Catch Weight ER
1654: FROM
1655: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) NA,
1656: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH
1657: WHERE
1658: OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1659: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1660: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <>'RETURN'

Line 1683: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH

1679: OL.SHIPPING_QUANTITY_UOM2, -- Catch Weight ER
1680: OL.FULFILLMENT_BASE -- Catch Weight ER
1681: FROM
1682: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) NA,
1683: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH
1684: WHERE
1685: OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1686: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1687: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <>'RETURN'

Line 1705: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH

1701: OL.SHIPPING_QUANTITY_UOM2, -- Catch Weight ER
1702: OL.FULFILLMENT_BASE -- Catch Weight ER
1703: FROM
1704: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) NA,
1705: OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH
1706: WHERE
1707: OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1708: --AND OL.FLOW_STATUS_CODE IN ('SHIPPED','CLOSED') --kdass - commented for bug 14777031
1709: AND OL.CANCELLED_FLAG = 'N' AND OL.LINE_CATEGORY_CODE <>'RETURN'

Line 1801: -- oe_order_headers_all oh

1797: -- NVL(ol.actual_arrival_date,ol.fulfillment_date) conv_date,
1798: -- oh.transactional_curr_code
1799: -- FROM ( SELECT /*+ no_merge */ DISTINCT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP ) NA,
1800: -- oe_order_lines_all ol,
1801: -- oe_order_headers_all oh
1802: -- WHERE ol.inventory_item_id = na.inventory_item_id
1803: -- AND ol.open_flag = 'N'
1804: -- AND ol.cancelled_flag = 'N'
1805: -- AND ol.line_category_code = 'RETURN'

Line 1836: OE_ORDER_HEADERS_ALL OH

1832: OH.TRANSACTIONAL_CURR_CODE
1833: FROM
1834: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP) NA,
1835: OE_ORDER_LINES_ALL OL,
1836: OE_ORDER_HEADERS_ALL OH
1837: WHERE OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1838: AND OL.OPEN_FLAG = 'N'
1839: AND OL.CANCELLED_FLAG = 'N'
1840: AND OL.LINE_CATEGORY_CODE = 'RETURN'

Line 1868: OE_ORDER_HEADERS_ALL OH

1864: OH.TRANSACTIONAL_CURR_CODE
1865: FROM
1866: ( SELECT INVENTORY_ITEM_ID FROM OZF_NA_UNIQUE_PRODUCTS_TEMP) NA,
1867: OE_ORDER_LINES_ALL OL,
1868: OE_ORDER_HEADERS_ALL OH
1869: WHERE OL.INVENTORY_ITEM_ID = NA.INVENTORY_ITEM_ID
1870: AND OL.OPEN_FLAG = 'N'
1871: AND OL.CANCELLED_FLAG = 'N'
1872: AND OL.LINE_CATEGORY_CODE = 'RETURN'