DBA Data[Home] [Help]

APPS.OE_EDI_PVT dependencies on OE_ORDER_HEADERS

Line 211: FROM oe_order_headers

207:
208: BEGIN
209: SELECT change_sequence, ship_to_org_id
210: INTO l_change_sequence, l_header_ship_to_org_id
211: FROM oe_order_headers
212: WHERE order_source_id = l_header_rec.order_source_id
213: AND orig_sys_document_ref = l_header_rec.orig_sys_document_ref
214: AND decode(l_customer_key_profile, 'Y',
215: nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)