APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_ORDER_LINES

Line 3672: From Oe_Order_Lines

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

Line 3942: FROM oe_order_lines

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

Line 4016: FROM oe_order_lines

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

Line 4088: FROM oe_order_lines

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

Line 4143: FROM oe_order_lines

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

Line 4182: FROM oe_order_lines

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

Line 4961: FROM oe_order_lines ol

4957: oe_debug_pub.add( 'FOR SEMI DELAYED SERVICE GET THE LINE_ID' ) ;
4958: END IF;
4959: SELECT line_id
4960: INTO p_x_line_tbl(I).service_reference_line_id
4961: FROM oe_order_lines ol
4962: WHERE ol.header_id = l_header_id
4963: AND ol.orig_sys_line_ref =
4964: p_x_line_tbl(I).service_reference_line
4965: AND decode(l_customer_key_profile, 'Y',

Line 4993: FROM oe_order_lines ol

4989: oe_debug_pub.add( 'FOR DELAYED SERVICE GET THE LINE_ID' ) ;
4990: END IF;
4991: SELECT line_id
4992: INTO p_x_line_tbl(I).service_reference_line_id
4993: FROM oe_order_lines ol
4994: WHERE ol.order_source_id =
4995: p_x_header_rec.order_source_id
4996: AND ol.orig_sys_document_ref =
4997: p_x_line_tbl(I).service_reference_order

Line 6404: from oe_order_lines

6400: IF p_x_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
6401:
6402: begin
6403: select unit_selling_price into l_unit_selling_price
6404: from oe_order_lines
6405: where line_id = p_x_line_tbl(I).line_id;
6406:
6407: exception
6408: when others then