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 2550: FROM oe_order_headers

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

Line 2570: FROM oe_order_headers

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

Line 2613: FROM oe_order_headers

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