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_LINES_ALL

Line 1572: oe_order_lines_all ol,

1568: ol.shipping_quantity2, -- Catch Weight ER
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'

Line 1604: oe_order_lines_all ol,

1600: ol.shipping_quantity2, -- Catch Weight ER
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'

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 1800: -- oe_order_lines_all ol,

1796: -- ol.org_id,
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'

Line 1835: OE_ORDER_LINES_ALL OL,

1831: OL.FULFILLMENT_DATE CONV_DATE,
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'

Line 1867: OE_ORDER_LINES_ALL OL,

1863: OL.FULFILLMENT_DATE CONV_DATE,
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'

Line 1988: FROM oe_order_lines_all o

1984: o.shipping_quantity_uom, -- Catch Weight ER
1985: o.shipping_quantity2, -- Catch Weight ER
1986: o.shipping_quantity_uom2, -- Catch Weight ER
1987: o.fulfillment_base -- Catch Weight ER
1988: FROM oe_order_lines_all o
1989: WHERE o.line_id = p_order_line_id;
1990:
1991: CURSOR c_get_credit_memo_details(p_cust_trx_line_id NUMBER) IS
1992: SELECT inventory_item_id,

Line 4741: FROM oe_order_lines_all a

4737: WHERE offer_id = p_offer_id;
4738:
4739: CURSOR c_order_line_detail1 IS
4740: SELECT a.*
4741: FROM oe_order_lines_all a
4742: WHERE TRUNC(NVL(a.actual_shipment_date,a.fulfillment_date))
4743: BETWEEN TRUNC(p_start_date) AND TRUNC(p_end_date)
4744: AND a.flow_status_code IN ('SHIPPED','CLOSED')
4745: AND a.cancelled_flag = 'N'

Line 4851: FROM oe_order_lines_all a

4847: a.line_id,
4848: a.invoice_to_org_id,
4849: a.ship_to_org_id,
4850: a.sold_to_org_id
4851: FROM oe_order_lines_all a
4852: WHERE (NVL(a.actual_shipment_date,a.fulfillment_date)) BETWEEN p_start_date AND p_end_date
4853: -- AND a.flow_status_code IN ('SHIPPED','CLOSED')
4854: AND a.booked_flag = 'Y'
4855: AND a.cancelled_flag = 'N'