APPS.OE_CONFIG_TSO_PVT dependencies on OE_ORDER_LINES_ALL

Line 1939: FROM oe_order_lines_all

1935: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
1936:
1937: CURSOR Models is
1938: SELECT line_id
1939: FROM oe_order_lines_all
1940: WHERE header_id = p_x_header_id
1941: AND open_flag = 'Y'
1942: AND top_model_line_id = line_id
1943: AND ATO_LINE_ID IS NULL;

Line 2848: From oe_order_lines_all

2844: Begin
2845:
2846: Select config_header_id, config_rev_nbr
2847: Into l_top_config_header_id, l_top_config_rev_nbr
2848: From oe_order_lines_all
2849: Where line_id = l_top_model_line_id;
2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN

Line 2923: From oe_order_lines_all

2919: Begin
2920:
2921: Select config_header_id, config_rev_nbr, configuration_id
2922: Into l_config_header_id, l_config_rev_nbr, l_config_item_id
2923: From oe_order_lines_all
2924: Where line_id = l_line_tbl(M).line_id;
2925:
2926: L_line_tbl(M).config_header_id := l_config_header_id;
2927: L_line_tbl(M).config_rev_nbr := l_config_rev_nbr;

Line 3168: From oe_order_lines_all

3164: Begin
3165:
3166: Select config_header_id, config_rev_nbr
3167: Into l_top_config_header_id, l_top_config_rev_nbr
3168: From oe_order_lines_all
3169: Where line_id = l_top_model_line_id;
3170:
3171: Exception
3172: When OTHERS THEN

Line 3269: from cz_config_details_v cz, oe_order_lines_all oe

3265: /*
3266: Select cz.config_hdr_id, cz.config_rev_nbr, substr(cz.component_code, 1,instr(cz.component_code,'-')-1),
3267: oe.top_model_line_id
3268: Into l_config_hdr_id, l_config_rev_nbr, L_item_id,x_top_model_line_id
3269: from cz_config_details_v cz, oe_order_lines_all oe
3270: where cz.instance_hdr_id = p_config_instance_hdr_id
3271: and oe.config_header_id = cz.config_hdr_id
3272: and oe.config_rev_nbr = cz.config_rev_nbr
3273: and oe.top_model_line_id = oe.line_id

Line 3300: From oe_order_lines_all

3296: Begin
3297:
3298: Select top_model_line_id
3299: Into x_top_model_line_id
3300: From oe_order_lines_all
3301: Where header_id = p_header_id
3302: -- And config_header_id = l_config_hdr_id
3303: -- And config_rev_nbr = l_config_rev_nbr
3304: AND open_flag = 'Y'

Line 3410: FROM oe_order_lines_all oe_line

3406: BEGIN
3407:
3408: SELECT configuration_id, component_code
3409: INTO x_config_item_id, x_component_code
3410: FROM oe_order_lines_all oe_line
3411: WHERE oe_line.top_model_line_id = p_top_model_line_id
3412: AND oe_line.configuration_id = p_instance_item_id
3413: AND rownum = 1;
3414: