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_ALL

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 168: SELECT line_id FROM oe_order_lines_all

164: l_max_ship_number number ;
165: l_chk_ship_number NUMBER ;
166: i NUMBER;
167: CURSOR Models(p_line_set_id NUMBER) IS
168: SELECT line_id FROM oe_order_lines_all
169: WHERE line_set_id= p_line_set_id;
170: --9534576
171: BEGIN
172: IF l_debug_level > 0 THEN

Line 274: FROM OE_ORDER_LINES_ALL

270: CURSOR OPTIONTBL IS
271: SELECT ORDERED_QUANTITY
272: , HEADER_ID
273: , LINE_ID
274: FROM OE_ORDER_LINES_ALL
275: WHERE TOP_MODEL_LINE_ID = l_line_id
276: AND LINE_ID <> l_line_id
277: AND NVL(SHIPPABLE_FLAG,'N')='Y';
278: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

Line 330: FROM OE_ORDER_LINES_ALL

326: CURSOR Sertbl IS
327: SELECT ORDERED_QUANTITY
328: , HEADER_ID
329: , LINE_ID
330: FROM OE_ORDER_LINES_ALL
331: WHERE SERVICE_REFERENCE_LINE_ID = l_line_id
332: AND ITEM_TYPE_CODE = 'SERVICE'
333: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'
334: AND OPEN_FLAG <> 'N' -- Bug 6710212

Line 449: FROM OE_ORDER_LINES_ALL

445: CURSOR OPTIONTBL IS
446: SELECT ORDERED_QUANTITY,
447: HEADER_ID,
448: LINE_ID
449: FROM OE_ORDER_LINES_ALL
450: WHERE TOP_MODEL_LINE_ID = l_line_id
451: AND LINE_ID <> l_line_id
452: AND NVL(CANCELLED_FLAG,'N')<> 'Y'
453: ORDER BY LINE_ID;

Line 463: FROM OE_ORDER_LINES_ALL

459: CURSOR CONFIGTBL IS
460: SELECT ORDERED_QUANTITY,
461: HEADER_ID,
462: LINE_ID
463: FROM OE_ORDER_LINES_ALL
464: WHERE ATO_LINE_ID = l_config_ato_line_id
465: AND ITEM_TYPE_CODE <> 'CONFIG'
466: AND NVL(CANCELLED_FLAG,'N')<> 'Y'
467: ORDER BY LINE_ID;

Line 1021: FROM OE_ORDER_LINES_ALL

1017: CURSOR Optiontbl IS
1018: SELECT ORDERED_QUANTITY,
1019: HEADER_ID,
1020: LINE_ID
1021: FROM OE_ORDER_LINES_ALL
1022: WHERE TOP_MODEL_LINE_ID = l_line_id
1023: AND LINE_ID <> l_line_id
1024: AND NVL(CANCELLED_FLAG,'N') <> 'Y'
1025: ORDER BY LINE_ID;

Line 1433: FROM OE_ORDER_LINES_ALL

1429: OPEN optrec FOR
1430: SELECT ORDERED_QUANTITY,
1431: HEADER_ID,
1432: LINE_ID
1433: FROM OE_ORDER_LINES_ALL
1434: WHERE ATO_LINE_ID = l_line_id
1435: AND LINE_ID <> l_line_id
1436: AND NVL(CANCELLED_FLAG,'N')<>'Y'
1437: ORDER BY LINE_ID;

Line 1443: FROM OE_ORDER_LINES_ALL

1439: OPEN Optrec FOR
1440: SELECT ORDERED_QUANTITY,
1441: HEADER_ID,
1442: LINE_ID
1443: FROM OE_ORDER_LINES_ALL
1444: WHERE TOP_MODEL_LINE_ID = l_line_id
1445: AND LINE_ID <> l_line_id
1446: AND NVL(CANCELLED_FLAG,'N') <> 'Y'
1447: ORDER BY LINE_ID;

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

1720: l_shipment_number := get_shipment_number(l_line_rec);
1721: 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;
1722: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' AND
1723: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1724: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1725:
1726: --Changed for bug 4302022
1727: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1728: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

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

1726: --Changed for bug 4302022
1727: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1728: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1729:
1730: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1731: ELSE
1732: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1733: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1734: END IF;

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

1735:
1736: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
1737: g_multiple_shipments = 'NO' AND
1738: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1739: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1740: --Changed for bug 4302022
1741: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1742: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1743:

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

1740: --Changed for bug 4302022
1741: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1742: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1743:
1744: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1745: ELSE
1746: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1747: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1748: END IF;

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

1867: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1868: 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;
1869: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' AND
1870: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1871: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1872: --Changed for bug 4302022
1873: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1874: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1875:

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

1872: --Changed for bug 4302022
1873: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1874: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1875:
1876: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1877: ELSE
1878: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1879: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1880: END IF;

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

1880: END IF;
1881: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
1882: g_multiple_shipments = 'NO' AND
1883: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1884: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1885: --Changed for bug 4302022
1886: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1887: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1888:

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

1885: --Changed for bug 4302022
1886: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1887: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1888:
1889: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1890: ELSE
1891: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);
1892: l_line_rec.orig_sys_line_ref := p_x_line_rec.orig_sys_line_ref;
1893: END IF;

Line 2680: from oe_order_lines_all

2676: l_init_line_id :=to_number(p_line_id);
2677:
2678: select org_id
2679: into l_org_id
2680: from oe_order_lines_all
2681: where line_id=l_init_line_id;
2682:
2683: MO_GLOBAL.set_policy_context('S',l_org_id);
2684: OE_GLOBALS.Set_Context();

Line 2728: FROM oe_order_lines_all

2724: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2725:
2726: SELECT ordered_quantity, ordered_quantity2
2727: INTO l_orig_ord_qty, l_orig_ord_qty2
2728: FROM oe_order_lines_all
2729: WHERE open_flag = 'Y'
2730: AND line_id = l_init_line_id;
2731:
2732: IF l_orig_ord_qty > 0 AND l_ord_qty_sum <> l_orig_ord_qty THEN