APPS.OE_CONFIG_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1152: From oe_order_lines_all

1148: -- re-fetch the value to pass it to lock api.
1149: BEGIN
1150: Select config_rev_nbr
1151: Into l_config_rev_nbr
1152: From oe_order_lines_all
1153: Where line_id = l_line_id;
1154: END;
1155:
1156: l_order_number := OE_SCHEDULE_UTIL.Get_Order_Number(p_header_id);

Line 2593: FROM oe_order_lines_all

2589: l_count := 0;
2590:
2591: SELECT /* MOAC_SQL_CHANGE */ count(*)
2592: INTO l_count
2593: FROM oe_order_lines_all
2594: WHERE top_model_line_id = p_top_model_line_id
2595: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2596: AND open_flag = 'Y'
2597: AND link_to_line_id =

Line 2599: FROM oe_order_lines_all

2595: AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
2596: AND open_flag = 'Y'
2597: AND link_to_line_id =
2598: (SELECT line_id
2599: FROM oe_order_lines_all
2600: WHERE top_model_line_id = p_top_model_line_id
2601: AND component_code = l_parent
2602: AND open_flag = 'Y' );
2603:

Line 2691: FROM OE_ORDER_LINES_ALL

2687: INTO l_header_id, l_config_hdr_id, l_config_rev_nbr, l_model_qty,
2688: l_configuration_id, l_order_source_id, l_orig_sys_document_ref,
2689: l_orig_sys_line_ref, l_orig_sys_shipment_ref, l_change_sequence,
2690: l_source_document_type_id, l_source_document_id, l_source_document_line_id
2691: FROM OE_ORDER_LINES_ALL
2692: WHERE line_id = p_model_line_id;
2693: EXCEPTION
2694: WHEN OTHERS THEN
2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3785: FROM OE_ORDER_LINES_ALL

3781: /* adding component number in this cursor to fix bug 2733667 */
3782:
3783: CURSOR c1 IS
3784: SELECT line_id
3785: FROM OE_ORDER_LINES_ALL
3786: WHERE HEADER_ID = l_header_id AND
3787: TOP_MODEL_LINE_ID = p_top_model_line_id
3788: ORDER BY line_number,shipment_number,nvl(option_number,-1),nvl(component_number,-1);
3789:

Line 3803: FROM oe_order_lines_all

3799:
3800: BEGIN
3801: SELECT header_id
3802: INTO l_header_id
3803: FROM oe_order_lines_all
3804: WHERE line_id = p_top_model_line_id;
3805: EXCEPTION
3806: WHEN NO_DATA_FOUND THEN
3807: l_header_id := 0;

Line 3855: FROM OE_ORDER_LINES_ALL

3851:
3852:
3853: CURSOR c1 IS
3854: SELECT line_id
3855: FROM OE_ORDER_LINES_ALL
3856: WHERE HEADER_ID = l_header_id AND
3857: TOP_MODEL_LINE_ID = l_top_model_line_id AND
3858: ATO_LINE_ID = p_ato_line_id
3859: ORDER BY line_number,shipment_number,nvl(option_number,-1);

Line 3873: FROM oe_order_lines_all

3869:
3870: BEGIN
3871: SELECT top_model_line_id ,header_id
3872: INTO l_top_model_line_id,l_header_id
3873: FROM oe_order_lines_all
3874: WHERE line_id = p_ato_line_id;
3875: EXCEPTION
3876: WHEN NO_DATA_FOUND THEN
3877: l_top_model_line_id := 0;

Line 4033: FROM OE_ORDER_LINES_ALL

4029:
4030:
4031: CURSOR c1 IS
4032: SELECT line_id
4033: FROM OE_ORDER_LINES_ALL
4034: WHERE HEADER_ID = l_header_id AND
4035: TOP_MODEL_LINE_ID = l_top_model_line_id AND
4036: LINK_TO_LINE_ID = p_line_id AND
4037: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED

Line 4055: FROM oe_order_lines_all

4051:
4052: BEGIN
4053: SELECT top_model_line_id ,header_id
4054: INTO l_top_model_line_id,l_header_id
4055: FROM oe_order_lines_all
4056: WHERE line_id = p_line_id;
4057: EXCEPTION
4058: WHEN NO_DATA_FOUND THEN
4059: l_top_model_line_id := 0;

Line 4758: UPDATE OE_ORDER_LINES_ALL

4754: IF nvl(p_freeze, FALSE) = TRUE OR
4755: l_freeze_macd_kit THEN
4756: -- Update the explosion date on the model line.
4757: BEGIN
4758: UPDATE OE_ORDER_LINES_ALL
4759: set explosion_date = l_explosion_date,
4760: lock_control = lock_control + 1
4761: WHERE line_id = l_parent_line_rec.line_id;
4762: EXCEPTION

Line 5622: FROM OE_ORDER_LINES_ALL

5618: l_header_id NUMBER := 0;
5619:
5620: CURSOR l_line_csr(l_top_model_line_id NUMBER) IS
5621: SELECT line_id
5622: FROM OE_ORDER_LINES_ALL
5623: WHERE HEADER_ID = l_header_id
5624: AND (TOP_MODEL_LINE_ID = l_top_model_line_id OR
5625: ( LINK_TO_LINE_ID = p_link_to_line_id AND
5626: ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_INCLUDED AND

Line 5658: FROM oe_order_lines_all

5654: END IF;
5655:
5656: SELECT header_id
5657: INTO l_header_id
5658: FROM oe_order_lines_all
5659: WHERE line_id=ll_line_id;
5660:
5661: EXCEPTION
5662: WHEN OTHERS THEN

Line 6447: FROM oe_order_lines_all oel,

6443: l_valid := 0;
6444:
6445: SELECT distinct 1
6446: INTO l_valid
6447: FROM oe_order_lines_all oel,
6448: mtl_system_items msi
6449: WHERE oel.line_id = p_line_id
6450: AND oel.inventory_item_id = msi.base_item_id
6451: AND msi.inventory_item_id = p_config_item_id;

Line 6609: UPDATE oe_order_lines_all

6605: IF l_debug_level > 0 THEN
6606: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_MFG_COMP_SEQ_ID' , 1);
6607: END IF;
6608:
6609: UPDATE oe_order_lines_all
6610: SET mfg_component_sequence_id = p_mfg_comp_seq_id
6611: ,last_update_date = sysdate
6612: ,last_updated_by = FND_Global.User_Id
6613: ,last_update_login = FND_Global.Login_Id