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 1674: FROM OE_ORDER_LINES_ALL OEOPT

1670:
1671: IF l_ato_config_item_id is NOT NULL THEN
1672: SELECT line_id
1673: INTO l_ato_line_id
1674: FROM OE_ORDER_LINES_ALL OEOPT
1675: WHERE line_id =
1676: (SELECT line_id
1677: FROM oe_order_lines OEATO
1678: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id

Line 1677: FROM oe_order_lines OEATO

1673: INTO l_ato_line_id
1674: FROM OE_ORDER_LINES_ALL OEOPT
1675: WHERE line_id =
1676: (SELECT line_id
1677: FROM oe_order_lines OEATO
1678: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id
1679: AND OEATO.configuration_id = l_ato_config_item_id
1680: AND OEATO.open_flag = 'Y')
1681: AND top_model_line_id = g_line_rec.top_model_line_id;

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

1702:
1703: ELSE
1704:
1705: IF l_debug_level > 0 THEN
1706: oe_debug_pub.add( 'USE OE_ORDER_LINES' , 3 ) ;
1707: END IF;
1708:
1709: SELECT line_id
1710: INTO l_ato_line_id

Line 1711: FROM OE_ORDER_LINES_ALL

1707: END IF;
1708:
1709: SELECT line_id
1710: INTO l_ato_line_id
1711: FROM OE_ORDER_LINES_ALL
1712: WHERE top_model_line_id = g_line_rec.top_model_line_id
1713: AND item_type_code = 'CLASS'
1714: AND component_code =
1715: SUBSTR( g_line_rec.component_code, 1,

Line 1721: FROM OE_ORDER_LINES_ALL OEMIN

1717: AND ato_line_id is not null
1718: AND open_flag = 'Y'
1719: AND component_code =
1720: ( SELECT MIN(OEMIN.component_code)
1721: FROM OE_ORDER_LINES_ALL OEMIN
1722: WHERE OEMIN.top_model_line_id
1723: = g_line_rec.top_model_line_id
1724: AND OEMIN.component_code =
1725: SUBSTR( g_line_rec.component_code, 1,

Line 2127: SELECT OE_ORDER_LINES_S.NEXTVAL

2123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2124: --
2125: BEGIN
2126:
2127: SELECT OE_ORDER_LINES_S.NEXTVAL
2128: INTO l_line_id
2129: FROM DUAL;
2130:
2131: RETURN l_line_id;

Line 2342: FROM OE_ORDER_LINES_ALL

2338: THEN
2339:
2340: SELECT NVL(MAX(LINE_NUMBER)+1,1)
2341: INTO l_line_number
2342: FROM OE_ORDER_LINES_ALL
2343: WHERE HEADER_ID = g_line_rec.header_id;
2344:
2345: RETURN (l_line_number);
2346:

Line 2469: FROM OE_ORDER_LINES

2465: ELSE
2466:
2467: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
2468: INTO l_ship_number
2469: FROM OE_ORDER_LINES
2470: WHERE HEADER_ID = g_line_rec.header_id
2471: AND LINE_NUMBER = g_line_rec.line_number;
2472:
2473: END IF;

Line 2710: FROM oe_order_lines l,

2706: BEGIN
2707:
2708: SELECT l.line_id
2709: INTO l_order_line_id
2710: FROM oe_order_lines l,
2711: mtl_unit_transactions_all_v u,
2712: mtl_material_transactions m
2713: WHERE l.Inventory_item_id = to_number(p_return_attribute1)
2714: AND m.transaction_source_type_id=2

Line 2801: FROM oe_order_lines_all l,

2797: l_inventory_item_id NUMBER := TO_NUMBER(p_return_attribute1);
2798:
2799: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2800: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2801: FROM oe_order_lines_all l,
2802: mtl_unit_transactions_all_v u,
2803: mtl_material_transactions m,
2804: oe_order_headers h
2805: WHERE l.Inventory_item_id = to_number(attr1)

Line 2825: oe_order_lines_all l,

2821: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2822: FROM mtl_material_transactions m,
2823: mtl_transaction_lot_val_v t,
2824: mtl_unit_transactions_all_v u,
2825: oe_order_lines_all l,
2826: oe_order_headers h
2827: WHERE u.Inventory_item_id = to_number(attr1)
2828: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2829: AND u.serial_number = attr2

Line 2852: FROM oe_lot_serial_numbers ls, oe_order_lines ol

2848: -- and removed it from query when cursor is opened.
2849:
2850: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2851: SELECT ls.line_id,ls.line_set_id,ls.from_serial_number,ls.to_serial_number
2852: FROM oe_lot_serial_numbers ls, oe_order_lines ol
2853: WHERE ls.line_id = ol.line_id
2854: AND nvl(ol.cancelled_flag,'N') <> 'Y'
2855: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2856: /*

Line 2867: FROM oe_order_lines_all ool,

2863: -- bug#5452691
2864:
2865: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2866: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2867: FROM oe_order_lines_all ool,
2868: oe_order_headers ooh,
2869: oe_transaction_types_tl ott
2870: WHERE ool.line_id = ord_line_id
2871: AND ooh.header_id = ool.header_id

Line 2916: oe_order_lines_all l,

2912: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
2913: INTO p_ref_line_id
2914: FROM ra_customer_trx_lines_all rctl,
2915: ra_customer_trx_all rct,
2916: oe_order_lines_all l,
2917: oe_order_headers h
2918: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
2919: and rctl.customer_trx_id = rct.customer_trx_id
2920: AND l.line_id = rctl.interface_line_attribute6

Line 2984: FROM OE_ORDER_LINES

2980: -- Check to see if any referenced return exists for the line.
2981: l_index1 := 0;
2982: SELECT count(*)
2983: INTO l_index1
2984: FROM OE_ORDER_LINES
2985: WHERE reference_line_id = C_LINE.line_id
2986: AND line_category_code = 'RETURN'
2987: AND cancelled_flag <> 'Y';
2988:

Line 3021: FROM OE_ORDER_LINES

3017: -- Check to see if any referenced return exists for the line.
3018: l_index1 := 0;
3019: SELECT count(*)
3020: INTO l_index1
3021: FROM OE_ORDER_LINES
3022: WHERE reference_line_id = C_LINE.line_id
3023: AND line_category_code = 'RETURN'
3024: AND cancelled_flag <> 'Y';
3025:

Line 3075: oe_order_lines b

3071: IF C2.line_set_id is not null THEN
3072: select distinct reference_line_id
3073: into l_ref_line_tbl(l_index2)
3074: from oe_line_sets a,
3075: oe_order_lines b
3076: where a.set_id = C2.line_set_id
3077: and a.line_id = b.line_id
3078: and b.cancelled_flag <> 'Y';
3079: ELSE

Line 3082: from oe_order_lines

3078: and b.cancelled_flag <> 'Y';
3079: ELSE
3080: select reference_line_id
3081: into l_ref_line_tbl(l_index2)
3082: from oe_order_lines
3083: where line_id = C2.line_id;
3084: -- bug#5452691
3085: -- and cancelled_flag <> 'Y';
3086: END IF;

Line 3317: FROM oe_order_lines l,

3313: BEGIN
3314:
3315: SELECT l.line_id
3316: INTO l_order_line_id
3317: FROM oe_order_lines l,
3318: mtl_unit_transactions_all_v u,
3319: mtl_material_transactions m
3320: WHERE L.Inventory_item_id = to_number(p_return_attribute1)
3321: AND m.transaction_id = u.transaction_id

Line 3409: oe_order_lines l

3405: l_tax_exempt_reason_code,
3406: l_tax_exempt_number,
3407: l_uom_code
3408: FROM ra_customer_trx_lines_all rctl,
3409: oe_order_lines l
3410: WHERE rctl.customer_trx_line_id = p_invoice_line_id
3411: AND to_number(rctl.interface_line_attribute6) = l.line_id;
3412: EXCEPTION
3413: WHEN NO_DATA_FOUND THEN

Line 3879: from oe_order_lines_all

3875: and transaction_type_id = 33
3876: and trx_source_line_id = p_x_line_rec.reference_line_id
3877: and inventory_item_id = p_x_line_rec.inventory_item_id
3878: and organization_id = (select ship_from_org_id
3879: from oe_order_lines_all
3880: where line_id = p_x_line_rec.reference_line_id);
3881: Exception
3882: When No_Data_Found Then
3883: Null;

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

4447: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4448: OR g_line_rec.orig_sys_line_ref IS NULL)
4449: AND
4450: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4451: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4452: END IF;
4453:
4454: --{ bug3664313 FP start: added NULL check
4455: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR

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

5047: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5048: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5049: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5050: (g_multiple_shipments = 'YES') THEN
5051: p_x_line_rec.orig_sys_shipment_ref := 'OE_ORDER_LINES_ALL'||p_x_line_rec.line_id||'.'||'1';
5052: IF l_debug_level > 0 THEN
5053: oe_debug_pub.add( 'SHIP SYS = '||P_X_LINE_REC.ORIG_SYS_SHIPMENT_REF ) ;
5054: END IF;
5055: ELSE