APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OE_ORDER_LINES_ALL

Line 1469: oe_order_lines_all ol,

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

Line 1567: oe_order_lines_all ol,

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

Line 3565: FROM oe_order_lines_all a

3561: WHERE offer_id = p_offer_id;
3562:
3563: CURSOR c_order_line_detail1 IS
3564: SELECT a.*
3565: FROM oe_order_lines_all a
3566: WHERE TRUNC(NVL(a.actual_shipment_date,a.fulfillment_date))
3567: BETWEEN TRUNC(p_start_date) AND TRUNC(p_end_date)
3568: AND a.flow_status_code IN ('SHIPPED','CLOSED')
3569: AND a.cancelled_flag = 'N'

Line 3675: FROM oe_order_lines_all a

3671: a.line_id,
3672: a.invoice_to_org_id,
3673: a.ship_to_org_id,
3674: a.sold_to_org_id
3675: FROM oe_order_lines_all a
3676: WHERE (NVL(a.actual_shipment_date,a.fulfillment_date)) BETWEEN p_start_date AND p_end_date
3677: -- AND a.flow_status_code IN ('SHIPPED','CLOSED')
3678: AND a.booked_flag = 'Y'
3679: AND a.cancelled_flag = 'N'