APPS.OE_UPG_SO_NEW dependencies on SO_HEADERS_ALL

Line 2930: so_headers_all sha,

2926: sha.s1_date,
2927: sha.shipping_instructions,
2928: sha.packing_instructions
2929: from
2930: so_headers_all sha,
2931: so_header_attributes shattr
2932: where
2933: sha.upgrade_flag = 'N' and
2934: sha.header_id = shattr.header_id(+) and

Line 3585: Update SO_HEADERS_ALL

3581: g_log_rec.mtl_sales_order_id := g_mtl_sales_order_id;
3582:
3583: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;
3584:
3585: Update SO_HEADERS_ALL
3586: set upgrade_flag = 'Y'
3587: where header_id = G_HEADER_ID;
3588:
3589: G_ERROR_LOCATION := 10;

Line 4394: so_headers_all sha

4390: is
4391: select
4392: sha.header_id
4393: from
4394: so_headers_all sha
4395: where
4396: ( sha.upgrade_flag = 'N' and (sha.order_category = 'RMA' and v_type = 'R') ) or
4397: ( sha.upgrade_flag = 'N' and (sha.order_category <> 'RMA' and v_type = 'O' ) ) or
4398: ( nvl(sha.upgrade_flag,'N') in ('N','X') and v_type = 'M') or

Line 4435: so_headers_all sha

4431: v_total_headers,
4432: v_min_header,
4433: v_max_header
4434: from
4435: so_headers_all sha
4436: where
4437: ( sha.upgrade_flag = 'N' and (sha.order_category = 'RMA' and v_type = 'R') ) or
4438: ( sha.upgrade_flag = 'N' and (sha.order_category <> 'RMA' and v_type = 'O') ) or
4439: ( nvl(sha.upgrade_flag,'N') in ('N','X') and v_type = 'M') or

Line 8585: Update so_headers_all

8581: --
8582: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8583: --
8584: BEGIN
8585: Update so_headers_all
8586: set upgrade_flag = 'X'
8587: where header_id = p_header_id;
8588:
8589: -- Check to see if any referenced Returns Should also be marked