APPS.OE_UPG_SO dependencies on SO_HEADERS_ALL

Line 2293: so_headers_all sha,

2289: nvl(sha.open_flag,'N') open_flag,
2290: decode(sha.s1,1,'Y','N') booked_flag,
2291: sha.s1_date
2292: from
2293: so_headers_all sha,
2294: so_header_attributes shattr
2295: where
2296: sha.upgrade_flag = 'N' and
2297: sha.header_id = shattr.header_id(+) and

Line 2788: Update SO_HEADERS_ALL

2784: g_log_rec.mtl_sales_order_id := g_mtl_sales_order_id;
2785:
2786: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;
2787:
2788: Update SO_HEADERS_ALL
2789: set upgrade_flag = 'Y'
2790: where header_id = G_HEADER_ID;
2791:
2792: G_ERROR_LOCATION := 10;

Line 3524: so_headers_all sha

3520: is
3521: select
3522: sha.header_id
3523: from
3524: so_headers_all sha
3525: where sha.upgrade_flag = 'N'
3526: order by sha.header_id;
3527:
3528: /*

Line 3576: so_headers_all sha

3572: v_total_headers,
3573: v_min_header,
3574: v_max_header
3575: from
3576: so_headers_all sha
3577: where sha.upgrade_flag = 'N';
3578: /*
3579: and ( (sha.order_category = 'RMA' and v_type = 'R') or
3580: (sha.order_category <> 'RMA' and v_type = 'O') );