DBA Data[Home] [Help]

APPS.OZF_REFRESH_SALES_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 332: FROM oe_order_headers_all hdr,

328: 'ORDER', 'IN',
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