eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_LINE dependencies on OE_ORDER_LINES

Line 863: FROM OE_ORDER_LINES

859: FND_MESSAGE.Set_Name ('ONT','ONT_SMC_PICK_RELEASED');
860: BEGIN
861: SELECT ORDERED_ITEM,inventory_item_id
862: INTO l_model_name,l_model_item_id
863: FROM OE_ORDER_LINES
864: WHERE line_id = p_line_rec.top_model_line_id;
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: l_model_name := null;

Line 1083: FROM oe_order_lines

1079: END IF;
1080:
1081: SELECT ordered_item, item_type_code,inventory_item_id,ordered_quantity
1082: INTO l_ordered_item, l_item_type_code,l_inv_item_id,l_ordered_quantity
1083: FROM oe_order_lines
1084: WHERE line_id = p_line_rec.top_model_line_id;
1085:
1086: IF MOD(p_line_rec.ordered_quantity,l_ordered_quantity) <> 0 THEN
1087:

Line 1949: FROM oe_order_lines

1945: ELSE
1946:
1947: SELECT inventory_item_id
1948: INTO l_ref_inventory_item_id
1949: FROM oe_order_lines
1950: WHERE line_id = p_reference_line_id;
1951:
1952: IF (l_ref_inventory_item_id = p_inventory_item_id) THEN
1953: RETURN TRUE;

Line 2021: FROM oe_order_lines

2017: INTO l_ref_fulfilled_quantity
2018: , l_ref_shippable_flag
2019: , l_ref_inv_iface_status
2020: , l_ref_shipped_quantity
2021: FROM oe_order_lines
2022: WHERE line_id = p_reference_line_id;
2023:
2024: IF (l_ref_shippable_flag = 'N' AND l_ref_inv_iface_status = 'NOT_ELIGIBLE') THEN
2025: RETURN TRUE;

Line 2132: FROM oe_order_lines

2128: end if;
2129:
2130: SELECT tax_code
2131: INTO l_tax_code
2132: FROM oe_order_lines
2133: WHERE line_id = p_reference_line_id
2134: and line_category_code = 'ORDER';
2135:
2136: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN

Line 2200: FROM oe_order_lines

2196: INTO l_booked_flag,
2197: l_uom_code,
2198: l_source_document_type_id,
2199: l_subscription_enable_flag -- sol_ord_er #16014165
2200: FROM oe_order_lines
2201: WHERE line_id = p_reference_line_id
2202: and line_category_code = 'ORDER';
2203: -- sol_ord_er #16014165
2204: /* Subscription Service Line cannot be returned */

Line 2346: FROM oe_order_lines

2342: END IF;
2343:
2344: SELECT NVL(SUM(ordered_quantity),0)
2345: INTO l_ord_qty
2346: FROM oe_order_lines
2347: WHERE line_category_code= 'RETURN'
2348: and reference_line_id = p_line_id;
2349:
2350: IF l_debug_level > 0 THEN

Line 2962: FROM OE_ORDER_LINES_ALL

2958: Select arrival_set_id,
2959: ship_set_id
2960: Into l_arrival_set_id,
2961: l_ship_set_id
2962: FROM OE_ORDER_LINES_ALL
2963: Where line_id = p_line_rec.top_model_line_id;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN

Line 3738: FROM oe_order_lines

3734: THEN
3735:
3736: SELECT item_type_code, ato_line_id
3737: INTO x_item_type_code, x_ato_line_id
3738: FROM oe_order_lines
3739: WHERE line_id = p_line_rec.reference_line_id;
3740:
3741: x_line_id := p_line_rec.reference_line_id;
3742: END IF;

Line 3885: FROM oe_order_lines_all ool, mtl_material_transactions mmt

3881: CURSOR c_transaction_quantity IS
3882: SELECT ABS(mmt.transaction_quantity) transaction_quantity,
3883: mmt.transaction_uom,
3884: mmt.revision
3885: FROM oe_order_lines_all ool, mtl_material_transactions mmt
3886: WHERE ool.line_id = p_line_rec.reference_line_id
3887: AND mmt.transaction_source_type_id = 2
3888: AND mmt.transaction_type_id = 33
3889: AND mmt.trx_source_line_id = ool.line_id

Line 4110: FROM MTL_SYSTEM_ITEMS I,OE_ORDER_LINES L

4106: IF P_LINE_REC.service_reference_type_code = 'ORDER' AND P_LINE_REC.service_reference_line_id IS NOT NULL AND P_LINE_REC.service_reference_line_id <> FND_API.G_MISS_NUM THEN
4107:
4108: SELECT I.SERVICEABLE_PRODUCT_FLAG,L.flow_status_code INTO
4109: l_serviceable_product_flag,l_flow_status_code
4110: FROM MTL_SYSTEM_ITEMS I,OE_ORDER_LINES L
4111: WHERE I.INVENTORY_ITEM_ID = L.inventory_item_id
4112: AND I.ORGANIZATION_ID = g_master_org_id
4113: AND L.LINE_ID = P_LINE_REC.service_reference_line_id;
4114:

Line 4560: from oe_order_lines

4556: BEGIN
4557:
4558: select sum(ordered_quantity)
4559: into l_quantity_entered
4560: from oe_order_lines
4561: where reference_line_id = p_line_rec.reference_line_id
4562: and line_category_code = 'RETURN'
4563: and item_revision = p_line_rec.item_revision
4564: and sold_to_org_id = p_line_rec.sold_to_org_id

Line 4823: FROM oe_order_lines L

4819:
4820: BEGIN
4821: SELECT 'N'
4822: INTO l_valid_line_number
4823: FROM oe_order_lines L
4824: WHERE L.line_number = p_line_rec.line_number
4825: AND L.header_id = p_line_rec.header_id
4826: AND L.line_id <> p_line_rec.line_id
4827: AND ( L.item_type_code = 'STANDARD'

Line 4895: UPDATE OE_ORDER_LINES_ALL

4891: IF l_debug_level > 0 THEN
4892: oe_debug_pub.add('ROLLBACK THE CHANGES ' ,2);
4893: END IF;
4894:
4895: UPDATE OE_ORDER_LINES_ALL
4896: SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
4897: SCHEDULE_ARRIVAL_DATE = p_old_line_rec.schedule_arrival_date,
4898: SHIP_FROM_ORG_ID = p_old_line_rec.ship_from_org_id
4899: WHERE top_model_line_id = p_line_rec.top_model_line_id;

Line 6786: FROM oe_order_lines

6782: -- this is a decrement and not a cancellation.
6783:
6784: SELECT count(*)
6785: INTO l_option_count
6786: FROM oe_order_lines
6787: WHERE top_model_line_id = p_line_rec.line_id
6788: AND line_id <> p_line_rec.line_id;
6789:
6790: IF l_option_count > 0 THEN