DBA Data[Home] [Help]

APPS.OE_CONFIG_TSO_PVT dependencies on OE_ORDER_LINES_ALL

Line 1938: FROM oe_order_lines_all

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

Line 2847: From oe_order_lines_all

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

Line 2922: From oe_order_lines_all

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

Line 3167: From oe_order_lines_all

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

Line 3268: from cz_config_details_v cz, oe_order_lines_all oe

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

Line 3299: From oe_order_lines_all

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

Line 3409: FROM oe_order_lines_all oe_line

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