DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on OE_ORDER_HEADERS_ALL

Line 439: FROM oe_order_headers_all

435:
436: -- Get the customer_account_id
437: SELECT invoice_to_org_id, sold_to_org_id
438: INTO l_invoice_to_org_id, l_sold_to_org_id
439: FROM oe_order_headers_all
440: WHERE header_id = l_header_id;
441:
442: IF l_cust_type = 'CUSTOMER_ID' THEN
443: l_customer_id := l_sold_to_org_id;