DBA Data[Home] [Help]

APPS.OZF_REFRESH_SALES_PVT dependencies on OE_ORDER_LINES_ALL

Line 333: oe_order_lines_all ln

329: 'RETURN', 'OUT')
330: , get_party_id(ln.sold_to_org_id) party_id
331: , get_party_site_id(ln.invoice_to_org_id) SOLD_TO_PARTY_SITE_ID
332: FROM oe_order_headers_all hdr,
333: oe_order_lines_all ln
334: WHERE ln.open_flag = 'N'
335: AND ln.cancelled_flag = 'N'
336: AND ln.header_id = hdr.header_id
337: AND NVL(ln.actual_shipment_date,ln.request_date) > l_global_start_date ;