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_DEFAULT_LINE dependencies on OE_ORDER_LINES

Line 1740: FROM OE_ORDER_LINES_ALL OEOPT

1736:
1737: IF l_ato_config_item_id is NOT NULL THEN
1738: SELECT line_id
1739: INTO l_ato_line_id
1740: FROM OE_ORDER_LINES_ALL OEOPT
1741: WHERE line_id =
1742: (SELECT line_id
1743: FROM oe_order_lines OEATO
1744: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id

Line 1743: FROM oe_order_lines OEATO

1739: INTO l_ato_line_id
1740: FROM OE_ORDER_LINES_ALL OEOPT
1741: WHERE line_id =
1742: (SELECT line_id
1743: FROM oe_order_lines OEATO
1744: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id
1745: AND OEATO.configuration_id = l_ato_config_item_id
1746: AND OEATO.open_flag = 'Y')
1747: AND top_model_line_id = g_line_rec.top_model_line_id;

Line 1772: oe_debug_pub.add( 'USE OE_ORDER_LINES' , 3 ) ;

1768:
1769: ELSE
1770:
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add( 'USE OE_ORDER_LINES' , 3 ) ;
1773: END IF;
1774:
1775: SELECT line_id
1776: INTO l_ato_line_id

Line 1777: FROM OE_ORDER_LINES_ALL

1773: END IF;
1774:
1775: SELECT line_id
1776: INTO l_ato_line_id
1777: FROM OE_ORDER_LINES_ALL
1778: WHERE top_model_line_id = g_line_rec.top_model_line_id
1779: AND item_type_code = 'CLASS'
1780: AND component_code =
1781: SUBSTR( g_line_rec.component_code, 1,

Line 1787: FROM OE_ORDER_LINES_ALL OEMIN

1783: AND ato_line_id is not null
1784: AND open_flag = 'Y'
1785: AND component_code =
1786: ( SELECT MIN(OEMIN.component_code)
1787: FROM OE_ORDER_LINES_ALL OEMIN
1788: WHERE OEMIN.top_model_line_id
1789: = g_line_rec.top_model_line_id
1790: AND OEMIN.component_code =
1791: SUBSTR( g_line_rec.component_code, 1,

Line 2244: SELECT OE_ORDER_LINES_S.NEXTVAL

2240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2241: --
2242: BEGIN
2243:
2244: SELECT OE_ORDER_LINES_S.NEXTVAL
2245: INTO l_line_id
2246: FROM DUAL;
2247:
2248: RETURN l_line_id;

Line 2459: FROM OE_ORDER_LINES_ALL

2455: THEN
2456:
2457: SELECT NVL(MAX(LINE_NUMBER)+1,1)
2458: INTO l_line_number
2459: FROM OE_ORDER_LINES_ALL
2460: WHERE HEADER_ID = g_line_rec.header_id;
2461:
2462: RETURN (l_line_number);
2463:

Line 2586: FROM OE_ORDER_LINES

2582: ELSE
2583:
2584: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
2585: INTO l_ship_number
2586: FROM OE_ORDER_LINES
2587: WHERE HEADER_ID = g_line_rec.header_id
2588: AND LINE_NUMBER = g_line_rec.line_number;
2589:
2590: END IF;

Line 2829: FROM oe_order_lines l,

2825: BEGIN
2826:
2827: SELECT l.line_id
2828: INTO l_order_line_id
2829: FROM oe_order_lines l,
2830: mtl_unit_transactions_all_v u,
2831: mtl_material_transactions m
2832: WHERE l.Inventory_item_id = to_number(p_return_attribute1)
2833: AND m.transaction_source_type_id=2

Line 2920: FROM oe_order_lines_all l,

2916: l_inventory_item_id NUMBER := TO_NUMBER(p_return_attribute1);
2917:
2918: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2919: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2920: FROM oe_order_lines_all l,
2921: mtl_unit_transactions_all_v u,
2922: mtl_material_transactions m,
2923: oe_order_headers h
2924: WHERE l.Inventory_item_id = to_number(attr1)

Line 2944: oe_order_lines_all l,

2940: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2941: FROM mtl_material_transactions m,
2942: mtl_transaction_lot_val_v t,
2943: mtl_unit_transactions_all_v u,
2944: oe_order_lines_all l,
2945: oe_order_headers h
2946: WHERE u.Inventory_item_id = to_number(attr1)
2947: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2948: AND u.serial_number = attr2

Line 2971: FROM oe_lot_serial_numbers ls, oe_order_lines ol

2967: -- and removed it from query when cursor is opened.
2968:
2969: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2970: SELECT ls.line_id,ls.line_set_id,ls.from_serial_number,ls.to_serial_number
2971: FROM oe_lot_serial_numbers ls, oe_order_lines ol
2972: WHERE ls.line_id = ol.line_id
2973: AND nvl(ol.cancelled_flag,'N') <> 'Y'
2974: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2975: /*

Line 2986: FROM oe_order_lines_all ool,

2982: -- bug#5452691
2983:
2984: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2985: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2986: FROM oe_order_lines_all ool,
2987: oe_order_headers ooh,
2988: oe_transaction_types_tl ott
2989: WHERE ool.line_id = ord_line_id
2990: AND ooh.header_id = ool.header_id

Line 3035: oe_order_lines_all l,

3031: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
3032: INTO p_ref_line_id
3033: FROM ra_customer_trx_lines_all rctl,
3034: ra_customer_trx_all rct,
3035: oe_order_lines_all l,
3036: oe_order_headers h
3037: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
3038: and rctl.customer_trx_id = rct.customer_trx_id
3039: AND l.line_id = rctl.interface_line_attribute6

Line 3103: FROM OE_ORDER_LINES

3099: -- Check to see if any referenced return exists for the line.
3100: l_index1 := 0;
3101: SELECT count(*)
3102: INTO l_index1
3103: FROM OE_ORDER_LINES
3104: WHERE reference_line_id = C_LINE.line_id
3105: AND line_category_code = 'RETURN'
3106: AND cancelled_flag <> 'Y';
3107:

Line 3140: FROM OE_ORDER_LINES

3136: -- Check to see if any referenced return exists for the line.
3137: l_index1 := 0;
3138: SELECT count(*)
3139: INTO l_index1
3140: FROM OE_ORDER_LINES
3141: WHERE reference_line_id = C_LINE.line_id
3142: AND line_category_code = 'RETURN'
3143: AND cancelled_flag <> 'Y';
3144:

Line 3194: oe_order_lines b

3190: IF C2.line_set_id is not null THEN
3191: select distinct reference_line_id
3192: into l_ref_line_tbl(l_index2)
3193: from oe_line_sets a,
3194: oe_order_lines b
3195: where a.set_id = C2.line_set_id
3196: and a.line_id = b.line_id
3197: and b.cancelled_flag <> 'Y';
3198: ELSE

Line 3201: from oe_order_lines

3197: and b.cancelled_flag <> 'Y';
3198: ELSE
3199: select reference_line_id
3200: into l_ref_line_tbl(l_index2)
3201: from oe_order_lines
3202: where line_id = C2.line_id;
3203: -- bug#5452691
3204: -- and cancelled_flag <> 'Y';
3205: END IF;

Line 3436: FROM oe_order_lines l,

3432: BEGIN
3433:
3434: SELECT l.line_id
3435: INTO l_order_line_id
3436: FROM oe_order_lines l,
3437: mtl_unit_transactions_all_v u,
3438: mtl_material_transactions m
3439: WHERE L.Inventory_item_id = to_number(p_return_attribute1)
3440: AND m.transaction_id = u.transaction_id

Line 3528: oe_order_lines l

3524: l_tax_exempt_reason_code,
3525: l_tax_exempt_number,
3526: l_uom_code
3527: FROM ra_customer_trx_lines_all rctl,
3528: oe_order_lines l
3529: WHERE rctl.customer_trx_line_id = p_invoice_line_id
3530: AND to_number(rctl.interface_line_attribute6) = l.line_id;
3531: EXCEPTION
3532: WHEN NO_DATA_FOUND THEN

Line 4006: from oe_order_lines_all

4002: and transaction_type_id = 33
4003: and trx_source_line_id = p_x_line_rec.reference_line_id
4004: and inventory_item_id = p_x_line_rec.inventory_item_id
4005: and organization_id = (select ship_from_org_id
4006: from oe_order_lines_all
4007: where line_id = p_x_line_rec.reference_line_id);
4008: Exception
4009: When No_Data_Found Then
4010: Null;

Line 4601: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;

4597: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4598: OR g_line_rec.orig_sys_line_ref IS NULL)
4599: AND
4600: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4601: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4602: END IF;
4603:
4604: --{ bug3664313 FP start: added NULL check
4605: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR

Line 5232: p_x_line_rec.orig_sys_shipment_ref := 'OE_ORDER_LINES_ALL'||p_x_line_rec.line_id||'.'||'1';

5228: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5229: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5230: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5231: (g_multiple_shipments = 'YES') THEN
5232: p_x_line_rec.orig_sys_shipment_ref := 'OE_ORDER_LINES_ALL'||p_x_line_rec.line_id||'.'||'1';
5233: IF l_debug_level > 0 THEN
5234: oe_debug_pub.add( 'SHIP SYS = '||P_X_LINE_REC.ORIG_SYS_SHIPMENT_REF ) ;
5235: END IF;
5236: ELSE