[Home] [Help]
129:
130: CURSOR children is
131: SELECT line_id, inventory_item_id, ordered_quantity, item_type_code,
132: shipped_quantity
133: FROM oe_order_lines
134: WHERE header_id = l_header_id
135: AND open_flag = 'Y'
136: AND ((top_model_line_id = p_parent_line_id
137: and line_id <> p_parent_line_id)
512: END IF;
513: END IF;
514: -- Instance Unlocking
515:
516: UPDATE oe_order_lines
517: SET config_header_id = null,
518: config_rev_nbr = null,
519: configuration_id = null,
520: lock_control = lock_control + 1
634: p_ato_line_id IN NUMBER,
635: p_line_id IN NUMBER)
636: IS
637: SELECT line_id
638: FROM oe_order_lines
639: WHERE((top_model_line_id = p_top_model_line_id
640: and line_id <> p_line_id)
641: OR (ato_line_id = p_ato_line_id and
642: line_id <> p_line_id ))
1078:
1079: CURSOR models is
1080: SELECT line_id,config_header_id,config_rev_nbr,
1081: configuration_id,booked_flag
1082: FROM oe_order_lines
1083: WHERE item_type_code = OE_GLOBALS.G_ITEM_MODEL
1084: AND header_id = p_header_id
1085: AND open_flag = 'Y';
1086:
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);
1224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1225:
1226: CURSOR order_lines is
1227: SELECT line_id
1228: FROM oe_order_lines
1229: WHERE item_type_code in (OE_GLOBALS.G_ITEM_MODEL,
1230: OE_GLOBALS.G_ITEM_CLASS,
1231: OE_GLOBALS.G_ITEM_KIT)
1232: AND open_flag = 'Y'
1358: returns success/error as status. It calls
1359: send_input_xml : to send the configuration coptions to SPC
1360: parse_output_xml : parse output of SPC to see if
1361: configuration is valid/complete
1362: process_config : to save options in oe_order_lines
1363:
1364: now that we have decided that we will treat invalid
1365: configuration in the same way as incomplete configuration,
1366: the arguments p_validate_flag and p_complete_flag do not
1365: configuration in the same way as incomplete configuration,
1366: the arguments p_validate_flag and p_complete_flag do not
1367: have a lot of meaning. We might remove them for the procedure.
1368: We will save invali as well as incomplete configurations
1369: in oe_order_lines before booking.
1370: After booking we will put model on hold if configuraion
1371: becomes invalid/incomplete.
1372: -----------------------------------------------------------------------*/
1373: PROCEDURE Configurator_Validation
1435: source_document_type_id,order_source_id
1436: INTO l_header_id, l_model_qty, l_booked_flag,
1437: l_upgraded_flag ,l_config_header_id, l_config_rev_nbr,
1438: l_source_document_type_id, l_order_source_id
1439: FROM OE_ORDER_LINES
1440: WHERE line_id = p_model_line_id;
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1496: IF l_booked_flag = 'N' THEN
1497:
1498: SELECT count (*)
1499: INTO l_any_insert
1500: FROM OE_ORDER_LINES
1501: WHERE top_model_line_id = p_model_line_id
1502: AND line_id <> p_model_line_id
1503: AND config_header_id IS NULL
1504: AND config_rev_nbr IS NULL;
1512:
1513: BEGIN
1514: SELECT 1
1515: INTO l_any_insert
1516: FROM cz_config_details_v cz, oe_order_lines oe
1517: WHERE oe.line_id = p_model_line_id
1518: AND oe.ordered_quantity <> cz.quantity
1519: AND oe.config_header_id = cz.config_hdr_id
1520: AND oe.config_rev_nbr = cz.config_rev_nbr
1868: l_msg_data = 'Y' THEN
1869:
1870: SELECT component_code
1871: INTO l_model_component
1872: FROM oe_order_lines
1873: WHERE line_id = p_model_line_id;
1874:
1875: l_updated_options_tbl := p_updated_options_tbl;
1876: l_deleted_options_tbl := p_deleted_options_tbl;
1994:
1995: IF p_updated_options_tbl.COUNT > 0 THEN
1996: SELECT ordered_quantity
1997: INTO l_qty
1998: FROM oe_order_lines
1999: WHERE line_id = p_model_line_id;
2000: END IF;
2001:
2002: I :=p_updated_options_tbl.FIRST;
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 =
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:
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;
2915:
2916: BEGIN
2917: SELECT ol.component_code, ol.configuration_id
2918: INTO l_component_code, l_configuration_id
2919: FROM oe_order_lines ol, cz_config_details_v cz
2920: WHERE ol.line_id = p_model_line_id
2921: AND cz.component_code = ol.component_code
2922: AND cz.config_hdr_id = ol.config_header_id
2923: AND cz.config_rev_nbr = ol.config_rev_nbr
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:
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;
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);
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;
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
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;
4226: AND be.DISABLE_DATE > p_std_comp_freeze_date
4227: AND be.COMPONENT_ITEM_ID <> be.TOP_ITEM_ID
4228: AND NOT EXISTS
4229: ( SELECT 'X'
4230: FROM oe_order_lines l
4231: WHERE l.top_model_line_id = p_top_model_line_id
4232: AND l.link_to_line_id = l_parent_line_rec.line_id
4233: AND l.component_code = be.component_code
4234: AND l.open_flag = 'Y')
4242: p_std_comp_freeze_date IN DATE)
4243: IS
4244: SELECT
4245: oel.line_id, be.extended_quantity * p_top_model_quantity
4246: FROM oe_order_lines oel, bom_explosions be
4247: WHERE oel.top_model_line_id = p_top_model_line_id
4248: AND oel.link_to_line_id = l_parent_line_rec.line_id
4249: AND oel.item_type_code = 'INCLUDED'
4250: AND be.explosion_type = 'INCLUDED'
4263: p_std_comp_freeze_date IN DATE)
4264: IS
4265: SELECT
4266: l.line_id
4267: FROM oe_order_lines l
4268: WHERE l.link_to_line_id = l_parent_line_rec.line_id
4269: AND l.top_model_line_id = p_top_model_line_id
4270: AND l.item_type_code = 'INCLUDED'
4271: AND l.open_flag = 'Y'
4449:
4450: BEGIN
4451: SELECT max(component_number)
4452: INTO l_component_number
4453: FROM oe_order_lines
4454: WHERE link_to_line_id = p_line_id
4455: AND top_model_line_id = l_parent_line_rec.top_model_line_id;
4456: EXCEPTION
4457: WHEN OTHERS THEN
4540: END IF;
4541:
4542: -- Adding this flag for fulfillment purpose.
4543:
4544: SELECT OE_ORDER_LINES_S.NEXTVAL
4545: INTO l_line_rec.line_id
4546: FROM dual;
4547:
4548: l_component_number := l_component_number + 1;
4600:
4601: -- open cursors only if some records exist to upd/del
4602: SELECT count(*)
4603: INTO l_top_model_quantity
4604: FROM oe_order_lines
4605: WHERE item_type_code = 'INCLUDED'
4606: AND top_model_line_id = l_parent_line_rec.top_model_line_id
4607: AND link_to_line_id = l_parent_line_rec.line_id;
4608:
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
4807: IS
4808:
4809: CURSOR comp_number IS
4810: SELECT line_id
4811: FROM oe_order_lines
4812: WHERE link_to_line_id = p_line_id
4813: AND top_model_line_id = p_top_model_line_id;
4814:
4815: l_component_number NUMBER := 0;
4828: EXIT WHEN comp_number%NOTFOUND;
4829:
4830: l_component_number := l_component_number + 1;
4831:
4832: UPDATE oe_order_lines
4833: SET component_number = l_component_number,
4834: lock_control = lock_control + 1
4835: WHERE line_id = l_line_id;
4836:
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
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
5784: l_error_code NUMBER;
5785:
5786: CURSOR comp_code_upd IS
5787: SELECT line_id, inventory_item_id, ordered_item, component_code
5788: FROM oe_order_lines
5789: WHERE top_model_line_id = p_top_model_line_id
5790: AND item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
5791: AND open_flag = 'Y'
5792: AND (component_code is null OR
5809: SELECT creation_date, component_code, component_sequence_id,
5810: inventory_item_id, ordered_quantity, ordered_item
5811: INTO l_rev_date, l_component_code, l_model_seq_id,
5812: l_top_item_id, l_exp_quantity, l_model_ordered_item
5813: FROM oe_order_lines
5814: WHERE line_id = p_top_model_line_id;
5815:
5816: EXCEPTION
5817: WHEN OTHERS THEN
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END;
5967:
5968: -- now update the oe table
5969: UPDATE oe_order_lines
5970: SET component_code = l_component_code,
5971: component_sequence_id = l_component_seq_id,
5972: sort_order = l_sort_order,
5973: order_quantity_uom = l_uom_code,
6037: END IF;
6038: BEGIN
6039: SELECT top_model_line_id, ordered_quantity, order_quantity_uom
6040: INTO l_top_model_line_id, l_ordered_quantity, l_order_quantity_uom
6041: FROM oe_order_lines
6042: WHERE line_id = p_line_id;
6043: EXCEPTION
6044: WHEN OTHERS THEN
6045: IF l_debug_level > 0 THEN
6157:
6158: BEGIN
6159: SELECT item_type_code, ato_line_id, ordered_item,inventory_item_id
6160: INTO l_item_type_code, l_ato_line_id, l_ordered_item,l_inv_item_id
6161: FROM oe_order_lines
6162: WHERE line_id = p_line_id;
6163: EXCEPTION
6164: WHEN OTHERS THEN
6165: IF l_debug_level > 0 THEN
6177: option_number||'.'||component_number||'.'||
6178: service_number,'.'),source_type_code
6179: INTO l_config_id,l_config_line_id,l_config_header_id,
6180: l_line_num,l_source_type
6181: FROM oe_order_lines
6182: -- Bug#5026787: Start:- ato_line_id should be used instead of top_model_line_id.
6183: -- WHERE top_model_line_id = p_line_id
6184: WHERE ato_line_id = p_line_id
6185: -- Bug#5026787: End
6340: END IF;
6341:
6342: SELECT item_type_code,header_id, top_model_line_id, line_id
6343: INTO l_item_type_code,l_header_id, l_top_model_line_id, l_line_id
6344: FROM oe_order_lines
6345: WHERE line_id = oe_line_security.g_record.line_id;
6346:
6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6369: l_top_model_line_id = l_line_id)
6370: THEN
6371: SELECT count(*)
6372: INTO l_count
6373: FROM OE_ORDER_LINES
6374: WHERE top_model_line_id = oe_line_security.g_record.line_id
6375: AND line_id <> oe_line_security.g_record.line_id
6376: AND header_id = l_header_id;
6377:
6424:
6425: BEGIN
6426: SELECT item_type_code, ato_line_id, ordered_item
6427: INTO l_item_type_code, l_ato_line_id, l_ordered_item
6428: FROM oe_order_lines
6429: WHERE line_id = p_line_id;
6430: EXCEPTION
6431: WHEN OTHERS THEN
6432: IF l_debug_level > 0 THEN
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;
6493:
6494: /*----------------------------------------------------------------------
6495: Procedure Name : Update_Comp_Seq_Id
6496: Description : API for CTO to do a direct update on
6497: oe_order_lines w/o calling process_order.
6498: -----------------------------------------------------------------------*/
6499:
6500: PROCEDURE Update_Comp_Seq_Id
6501: ( p_line_id IN NUMBER
6509: IF l_debug_level > 0 THEN
6510: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_COMP_SEQ_ID' , 1);
6511: END IF;
6512:
6513: UPDATE oe_order_lines
6514: SET component_sequence_id = p_comp_seq_id
6515: ,last_update_date = sysdate
6516: ,last_updated_by = FND_Global.User_Id
6517: ,last_update_login = FND_Global.Login_Id
6541:
6542: /*----------------------------------------------------------------------
6543: Procedure Name : Update_Visible_Demand_Flag
6544: Description : API for CTO to do a direct update on
6545: oe_order_lines w/o calling process_order.
6546: -----------------------------------------------------------------------*/
6547:
6548: PROCEDURE Update_Visible_Demand_Flag
6549: ( p_ato_line_id IN NUMBER
6557: IF l_debug_level > 0 THEN
6558: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_VISIBLE_DEMAND_FLAG' , 1);
6559: END IF;
6560:
6561: UPDATE oe_order_lines
6562: SET visible_demand_flag = p_visible_demand_flag
6563: ,last_update_date = sysdate
6564: ,last_updated_by = FND_Global.User_Id
6565: ,last_update_login = FND_Global.Login_Id
6589:
6590: /*----------------------------------------------------------------------
6591: Procedure Name : Update_Mfg_Comp_Seq_Id
6592: Description : API for CTO to do a direct update on
6593: oe_order_lines w/o calling process_order.
6594: -----------------------------------------------------------------------*/
6595:
6596: PROCEDURE Update_Mfg_Comp_Seq_Id
6597: ( p_ato_line_id IN NUMBER
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
6637:
6638: /*----------------------------------------------------------------------
6639: Procedure Name : Update_Model_Group_Number
6640: Description : API for CTO to do a direct update on
6641: oe_order_lines w/o calling process_order.
6642: -----------------------------------------------------------------------*/
6643:
6644: PROCEDURE Update_Model_Group_Number
6645: ( p_ato_line_id IN NUMBER
6653: IF l_debug_level > 0 THEN
6654: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_MODEL_GROUP_NUMBER' , 1);
6655: END IF;
6656:
6657: UPDATE oe_order_lines
6658: SET model_group_number = p_model_group_number
6659: ,last_update_date = sysdate
6660: ,last_updated_by = FND_Global.User_Id
6661: ,last_update_login = FND_Global.Login_Id
6685:
6686: /*----------------------------------------------------------------------
6687: Procedure Name : Update_Cto_Columns
6688: Description : API for CTO to do a direct update on
6689: oe_order_lines w/o calling process_order.
6690: -----------------------------------------------------------------------*/
6691:
6692: PROCEDURE Update_Cto_Columns
6693: ( p_ato_line_id IN NUMBER
6704: IF l_debug_level > 0 THEN
6705: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.UPDATE_CTO_COLUMNS' , 1);
6706: END IF;
6707:
6708: UPDATE oe_order_lines
6709: SET request_id = p_request_id
6710: ,program_id = p_program_id
6711: ,program_update_date = p_prog_update_date
6712: ,program_application_id = p_prog_appl_id
6851: END IF;
6852:
6853: SELECT ato_line_id
6854: INTO l_ato_line_id
6855: FROM oe_order_lines
6856: WHERE line_id = p_request_tbl(I).param1;
6857:
6858: IF l_ato_line_id = p_request_tbl(I).param2 THEN
6859:
6975: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
6976:
6977: SELECT ordered_item, item_type_code,inventory_item_id
6978: INTO l_ordered_item, l_item_type_code,l_inv_item_id
6979: FROM oe_order_lines
6980: WHERE top_model_line_id = p_top_model_line_id
6981: AND component_code = p_component_code
6982: AND rownum = 1;
6983:
6986: FND_MESSAGE.Set_TOKEN('VALUE',to_char(p_ratio));
6987:
6988: SELECT ordered_item, item_type_code,inventory_item_id
6989: INTO l_ordered_item, l_item_type_code,l_inv_item_id
6990: FROM oe_order_lines
6991: WHERE line_id = p_top_model_line_id;
6992:
6993: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
6994: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
7707: END IF;
7708:
7709: SELECT user_item_description
7710: INTO p_x_child_line_rec.user_item_description
7711: FROM oe_order_lines
7712: WHERE line_id = p_x_child_line_rec.ato_line_id;
7713:
7714: --no need to handle exception here as exception is handled outside
7715:
7754: p_x_child_line_rec.firm_demand_flag,
7755: p_x_child_line_rec.override_atp_date_code,
7756: p_x_child_line_rec.ship_to_contact_id, --bug7041018,7175458
7757: p_x_child_line_rec.intermed_ship_to_org_id --bug 7041018,7175458
7758: FROM oe_order_lines
7759: WHERE line_id = p_x_child_line_rec.ato_line_id;
7760:
7761: IF l_debug_level > 0 THEN
7762: oe_debug_pub.add('2 **SOURCE TYPE ATO '
7835: END IF;
7836:
7837: SELECT item_type_code, model_remnant_flag
7838: INTO l_item_type_code, l_model_remnant_flag
7839: FROM oe_order_lines
7840: WHERE line_id = oe_line_security.g_record.line_id;
7841:
7842: IF nvl(l_item_type_code, 'A') <> 'INCLUDED' THEN
7843: x_result := 0;
8057:
8058: BEGIN
8059: select 'Y'
8060: into l_serviced_model
8061: from oe_order_lines
8062: where item_type_code = 'SERVICE'
8063: and service_reference_line_id = p_line_tbl(I).top_model_line_id
8064: and service_reference_type_code = 'ORDER'
8065: and rownum = 1;
8215: x_wb_item_type := null;
8216:
8217: SELECT count(*)
8218: INTO l_count
8219: FROM oe_order_lines
8220: WHERE line_category_code <> 'RETURN'
8221: -- the condition below is commented for bug 3441504
8222: -- AND booked_flag = 'Y'
8223: AND (header_id = p_header_id OR
8365: BEGIN
8366:
8367: SELECT nvl(ordered_item,inventory_item_id )
8368: INTO l_message_text
8369: FROM oe_order_lines
8370: WHERE line_id = p_line_id;
8371:
8372: EXCEPTION
8373: WHEN OTHERS THEN
8436: IF p_model_line_rec.split_from_line_id is NOT NULL THEN
8437:
8438: SELECT creation_date
8439: INTO l_creation_date
8440: FROM oe_order_lines
8441: WHERE header_id = l_header_id
8442: AND line_set_id = p_model_line_rec.line_set_id
8443: AND split_from_line_id is NULL;
8444:
8471: SELECT header_id, creation_date,
8472: line_set_id, split_from_line_id
8473: INTO l_header_id, l_creation_date,
8474: l_line_set_id, l_split_from_line_id
8475: FROM oe_order_lines
8476: WHERE line_id = p_model_line_id;
8477:
8478: IF l_split_from_line_id is NOT NULL THEN
8479:
8478: IF l_split_from_line_id is NOT NULL THEN
8479:
8480: SELECT creation_date
8481: INTO l_creation_date
8482: FROM oe_order_lines
8483: WHERE header_id = l_header_id
8484: AND line_set_id = l_line_set_id
8485: AND split_from_line_id is NULL;
8486: