APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_ORDER_LINES

Line 3669: From Oe_Order_Lines

3665:
3666: Begin
3667: Select ordered_quantity
3668: Into l_existing_qty
3669: From Oe_Order_Lines
3670: Where orig_sys_document_ref = p_x_line_tbl(I).orig_sys_document_ref
3671: And order_source_id = p_x_line_tbl(I).order_source_id
3672: And orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref
3673: And orig_sys_shipment_ref = p_x_line_tbl(I).orig_sys_shipment_ref

Line 3939: FROM oe_order_lines

3935: IF l_debug_level > 0 THEN
3936: oe_debug_pub.add( 'NEW LINE FOR THE EXISITNG HEARDER_ID:' || TO_CHAR ( P_X_HEADER_REC.HEADER_ID ) ) ;
3937: END IF;
3938: SELECT 1 into l_count
3939: FROM oe_order_lines
3940: WHERE header_id = l_header_id
3941: AND orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref
3942: AND orig_sys_shipment_ref = p_x_line_tbl(I).orig_sys_shipment_ref
3943: AND decode(l_customer_key_profile, 'Y',

Line 4013: FROM oe_order_lines

4009: IF l_debug_level > 0 THEN
4010: oe_debug_pub.add( 'NEW LINE FOR THE EXISITNG HEARDER_ID:' || TO_CHAR ( P_X_HEADER_REC.HEADER_ID ) ) ;
4011: END IF;
4012: SELECT 1 into l_count
4013: FROM oe_order_lines
4014: WHERE header_id = l_header_id
4015: AND orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref
4016: AND decode(l_customer_key_profile, 'Y',
4017: nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

Line 4085: FROM oe_order_lines

4081: IF l_debug_level > 0 THEN
4082: oe_debug_pub.add( 'NEW LINE FOR THE EXISITNG HEARDER_ID:' || TO_CHAR ( P_X_HEADER_REC.HEADER_ID ) ) ;
4083: END IF;
4084: SELECT 1 into l_count
4085: FROM oe_order_lines
4086: WHERE header_id = l_header_id
4087: AND orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref;
4088:
4089: -- aksingh(10/11/2000) this is in process of being coded upto here

Line 4140: FROM oe_order_lines

4136: SELECT line_id, line_number, shipment_number,
4137: option_number, change_sequence, unit_selling_price
4138: INTO l_line_id, l_line_number, l_shipment_number,
4139: l_option_number, l_c_change_sequence, l_cho_unit_selling_price
4140: FROM oe_order_lines
4141: WHERE header_id = l_header_id
4142: AND orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref
4143: AND orig_sys_shipment_ref = p_x_line_tbl(I).orig_sys_shipment_ref
4144: AND (sold_to_org_id is NULL OR

Line 4179: FROM oe_order_lines

4175: SELECT line_id, line_number, shipment_number,
4176: option_number, change_sequence, unit_selling_price
4177: INTO l_line_id, l_line_number, l_shipment_number,
4178: l_option_number, l_c_change_sequence, l_cho_unit_selling_price
4179: FROM oe_order_lines
4180: WHERE header_id = l_header_id
4181: AND orig_sys_line_ref = p_x_line_tbl(I).orig_sys_line_ref;
4182:
4183: p_x_line_tbl(I).header_id := l_header_id;

Line 4894: FROM oe_order_lines ol

4890: oe_debug_pub.add( 'FOR SEMI DELAYED SERVICE GET THE LINE_ID' ) ;
4891: END IF;
4892: SELECT line_id
4893: INTO p_x_line_tbl(I).service_reference_line_id
4894: FROM oe_order_lines ol
4895: WHERE ol.header_id = l_header_id
4896: AND ol.orig_sys_line_ref =
4897: p_x_line_tbl(I).service_reference_line
4898: AND decode(l_customer_key_profile, 'Y',

Line 4926: FROM oe_order_lines ol

4922: oe_debug_pub.add( 'FOR DELAYED SERVICE GET THE LINE_ID' ) ;
4923: END IF;
4924: SELECT line_id
4925: INTO p_x_line_tbl(I).service_reference_line_id
4926: FROM oe_order_lines ol
4927: WHERE ol.order_source_id =
4928: p_x_header_rec.order_source_id
4929: AND ol.orig_sys_document_ref =
4930: p_x_line_tbl(I).service_reference_order

Line 6337: from oe_order_lines

6333: IF p_x_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
6334:
6335: begin
6336: select unit_selling_price into l_unit_selling_price
6337: from oe_order_lines
6338: where line_id = p_x_line_tbl(I).line_id;
6339:
6340: exception
6341: when others then