APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_ORDER_HEADERS

Line 2269: FROM oe_order_headers

2265:
2266:
2267: SELECT change_sequence
2268: INTO l_c_change_sequence
2269: FROM oe_order_headers
2270: WHERE order_source_id = p_x_header_rec.order_source_id
2271: AND orig_sys_document_ref = p_x_header_rec.orig_sys_document_ref
2272: AND decode(l_customer_key_profile, 'Y',
2273: nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

Line 2547: FROM oe_order_headers

2543: END IF;
2544:
2545:
2546: SELECT 1 into l_count
2547: FROM oe_order_headers
2548: WHERE order_source_id = p_x_header_rec.order_source_id
2549: AND orig_sys_document_ref = p_x_header_rec.orig_sys_document_ref
2550: AND decode(l_customer_key_profile, 'Y',
2551: nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

Line 2567: FROM oe_order_headers

2563: oe_debug_pub.add( 'BEFORE VALIDATING EXTERNAL ORDER FOR INSERT OPR' ) ;
2564: END IF;
2565:
2566: SELECT 1 into l_count
2567: FROM oe_order_headers
2568: WHERE order_source_id = p_x_header_rec.order_source_id
2569: AND orig_sys_document_ref = p_x_header_rec.orig_sys_document_ref
2570: AND decode(l_customer_key_profile, 'Y',
2571: nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

Line 2610: FROM oe_order_headers

2606: --to restrict new order to have the same change sequence as old order
2607:
2608: SELECT header_id, order_number, change_sequence
2609: INTO l_header_id, l_order_number, l_c_change_sequence
2610: FROM oe_order_headers
2611: WHERE order_source_id = p_x_header_rec.order_source_id
2612: AND orig_sys_document_ref = p_x_header_rec.orig_sys_document_ref
2613: AND (sold_to_org_id is NULL OR
2614: decode(l_customer_key_profile, 'Y',