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

Line 82: FROM OE_ORDER_LINES_ALL

78: Cursor Sertbl IS
79: SELECT ORDERED_QUANTITY
80: , HEADER_ID
81: , LINE_ID
82: FROM OE_ORDER_LINES_ALL
83: WHERE SERVICE_REFERENCE_LINE_ID = l_line_id
84: AND ITEM_TYPE_CODE = 'SERVICE'
85: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'
86: AND OPEN_FLAG <> 'N' -- Bug 7555831 and 7555832

Line 169: FROM OE_ORDER_LINES

165: IF p_line_rec.top_model_line_id IS NULL
166: OR p_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN
167: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
168: INTO l_ship_number
169: FROM OE_ORDER_LINES
170: WHERE HEADER_ID = p_line_rec.header_id
171: AND LINE_NUMBER = p_line_rec.line_number;
172: RETURN l_ship_number;
173: ELSE

Line 177: FROM oe_order_lines

173: ELSE
174: -- 2605065: We will not use Cache info. Select direct from table.
175: SELECT shipment_number
176: INTO l_ship_number
177: FROM oe_order_lines
178: WHERE line_id = p_line_rec.top_model_line_id;
179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'SHIPMENT_NUMBER '||l_ship_number,1 ) ;
181: END IF;

Line 203: FROM OE_ORDER_LINES_ALL

199: CURSOR OPTIONTBL IS
200: SELECT ORDERED_QUANTITY
201: , HEADER_ID
202: , LINE_ID
203: FROM OE_ORDER_LINES_ALL
204: WHERE TOP_MODEL_LINE_ID = l_line_id
205: AND LINE_ID <> l_line_id
206: AND NVL(SHIPPABLE_FLAG,'N')='Y';
207: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

Line 259: FROM OE_ORDER_LINES_ALL

255: CURSOR Sertbl IS
256: SELECT ORDERED_QUANTITY
257: , HEADER_ID
258: , LINE_ID
259: FROM OE_ORDER_LINES_ALL
260: WHERE SERVICE_REFERENCE_LINE_ID = l_line_id
261: AND ITEM_TYPE_CODE = 'SERVICE'
262: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'
263: AND OPEN_FLAG <> 'N' -- Bug 6710212

Line 377: FROM OE_ORDER_LINES_ALL

373: CURSOR OPTIONTBL IS
374: SELECT ORDERED_QUANTITY,
375: HEADER_ID,
376: LINE_ID
377: FROM OE_ORDER_LINES_ALL
378: WHERE TOP_MODEL_LINE_ID = l_line_id
379: AND LINE_ID <> l_line_id
380: AND NVL(CANCELLED_FLAG,'N')<> 'Y'
381: ORDER BY LINE_ID;

Line 799: FROM OE_ORDER_LINES_ALL

795: CURSOR Optiontbl IS
796: SELECT ORDERED_QUANTITY,
797: HEADER_ID,
798: LINE_ID
799: FROM OE_ORDER_LINES_ALL
800: WHERE TOP_MODEL_LINE_ID = l_line_id
801: AND LINE_ID <> l_line_id
802: AND NVL(CANCELLED_FLAG,'N') <> 'Y'
803: ORDER BY LINE_ID;

Line 1209: FROM OE_ORDER_LINES_ALL

1205: OPEN optrec FOR
1206: SELECT ORDERED_QUANTITY,
1207: HEADER_ID,
1208: LINE_ID
1209: FROM OE_ORDER_LINES_ALL
1210: WHERE ATO_LINE_ID = l_line_id
1211: AND LINE_ID <> l_line_id
1212: AND NVL(CANCELLED_FLAG,'N')<>'Y'
1213: ORDER BY LINE_ID;

Line 1219: FROM OE_ORDER_LINES_ALL

1215: OPEN Optrec FOR
1216: SELECT ORDERED_QUANTITY,
1217: HEADER_ID,
1218: LINE_ID
1219: FROM OE_ORDER_LINES_ALL
1220: WHERE TOP_MODEL_LINE_ID = l_line_id
1221: AND LINE_ID <> l_line_id
1222: AND NVL(CANCELLED_FLAG,'N') <> 'Y'
1223: ORDER BY LINE_ID;

Line 1427: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1423: l_shipment_number := get_shipment_number(l_line_rec);
1424: l_line_rec.orig_sys_shipment_ref := substr(l_line_rec.orig_sys_shipment_ref,0,instr(l_line_rec.orig_sys_shipment_ref,'.'))||l_shipment_number;
1425: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' AND
1426: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1427: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1428:
1429: --Changed for bug 4302022
1430: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1431: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

Line 1433: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1429: --Changed for bug 4302022
1430: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1431: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1432:
1433: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1434: ELSE
1435: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1436: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1437: END IF;

Line 1442: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1438:
1439: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
1440: g_multiple_shipments = 'NO' AND
1441: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1442: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1443: --Changed for bug 4302022
1444: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1445: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1446:

Line 1447: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1443: --Changed for bug 4302022
1444: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1445: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1446:
1447: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1448: ELSE
1449: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1450: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1451: END IF;

Line 1538: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1534: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1535: l_line_rec.orig_sys_shipment_ref := substr(p_x_line_rec.orig_sys_shipment_ref,0,instr(p_x_line_rec.orig_sys_shipment_ref,'.'))||l_line_rec.shipment_number;
1536: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' AND
1537: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1538: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1539: --Changed for bug 4302022
1540: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1541: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1542:

Line 1543: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1539: --Changed for bug 4302022
1540: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1541: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1542:
1543: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1544: ELSE
1545: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1546: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1547: END IF;

Line 1551: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1547: END IF;
1548: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
1549: g_multiple_shipments = 'NO' AND
1550: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1551: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1552: --Changed for bug 4302022
1553: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1554: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1555:

Line 1556: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;

1552: --Changed for bug 4302022
1553: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1554: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1555:
1556: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1557: ELSE
1558: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1559: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1560: END IF;

Line 2293: from oe_order_lines_all

2289: l_init_line_id :=to_number(p_line_id);
2290:
2291: select org_id
2292: into l_org_id
2293: from oe_order_lines_all
2294: where line_id=l_init_line_id;
2295:
2296: MO_GLOBAL.set_policy_context('S',l_org_id);
2297: OE_GLOBALS.Set_Context();

Line 2341: FROM oe_order_lines_all

2337: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2338:
2339: SELECT ordered_quantity, ordered_quantity2
2340: INTO l_orig_ord_qty, l_orig_ord_qty2
2341: FROM oe_order_lines_all
2342: WHERE open_flag = 'Y'
2343: AND line_id = l_init_line_id;
2344:
2345: IF l_orig_ord_qty > 0 AND l_ord_qty_sum <> l_orig_ord_qty THEN