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

Line 198: FROM oe_order_lines

194: ELSE
195:
196: SELECT inventory_item_id
197: INTO l_inventory_item_id
198: FROM oe_order_lines
199: WHERE line_id = p_top_model_line_id;
200:
201: IF l_debug_level > 0 THEN
202: OE_DEBUG_PUB.Add('Get Parent Item Id for:'||p_inventory_item_id,3);

Line 278: FROM oe_order_lines

274: l_ato_line_id IS NULL THEN
275:
276: SELECT top_model_line_id,ato_line_id
277: INTO l_top_model_line_id,l_ato_line_id
278: FROM oe_order_lines
279: WHERE line_id = p_line_id;
280:
281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Top Model Line id:'||l_top_model_line_id,3);

Line 293: FROM mtl_system_items mtl_msi, oe_order_lines oe_l

289: l_ato_line_id IS NULL THEN
290:
291: SELECT mtl_msi.config_model_type
292: INTO l_config_model_type
293: FROM mtl_system_items mtl_msi, oe_order_lines oe_l
294: WHERE oe_l.line_id = l_top_model_line_id
295: AND oe_l.inventory_item_id = mtl_msi.inventory_item_id
296: AND mtl_msi.organization_id = OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID',p_org_id); --Bug 5524710
297:

Line 781: pass p_line_rec if the line is yet not saved in oe_order_lines.

777: p_top_model_line_id
778: p_line_id
779: p_line_rec
780:
781: pass p_line_rec if the line is yet not saved in oe_order_lines.
782:
783: if you pass p_line_id or p_top_model_line_id, api assumes
784: that the lines are saved in oe_order_lines.
785:

Line 784: that the lines are saved in oe_order_lines.

780:
781: pass p_line_rec if the line is yet not saved in oe_order_lines.
782:
783: if you pass p_line_id or p_top_model_line_id, api assumes
784: that the lines are saved in oe_order_lines.
785:
786: 3) if p_check_ibreconfig is passed, pass p_line_rec as well.
787:
788:

Line 836: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

832: END IF;
833:
834: SELECT cz_hdr.baseline_rev_nbr
835: INTO l_baseline_rev_nbr
836: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
837: cz_config_items czi
838: WHERE oe_line.top_model_line_id = p_top_model_line_id
839: AND czi.config_hdr_id = oe_line.config_header_id
840: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 856: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

852:
853: BEGIN
854: SELECT czi.config_delta
855: INTO l_baseline_rev_nbr
856: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
857: cz_config_items czi
858: WHERE oe_line.top_model_line_id = p_top_model_line_id
859: AND czi.config_hdr_id = oe_line.config_header_id
860: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 894: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

890: END IF;
891:
892: SELECT cz_hdr.baseline_rev_nbr
893: INTO l_baseline_rev_nbr
894: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
895: cz_config_items czi
896: WHERE oe_line.line_id = p_line_id
897: AND czi.config_hdr_id = oe_line.config_header_id
898: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 909: FROM oe_order_lines oe_line,

905:
906: BEGIN
907: SELECT czi.config_delta
908: INTO l_baseline_rev_nbr
909: FROM oe_order_lines oe_line,
910: cz_config_items czi
911: WHERE oe_line.line_id = p_line_id
912: AND czi.config_hdr_id = oe_line.config_header_id
913: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 1076: FROM oe_order_lines oe_ol

1072: SELECT oe_ol.line_id
1073: ,oe_ol.config_header_id
1074: ,oe_ol.config_rev_nbr
1075: ,oe_ol.configuration_id
1076: FROM oe_order_lines oe_ol
1077: ,cz_config_details_v cz_det
1078: WHERE oe_ol.top_model_line_id = p_top_model_line_id
1079: AND cz_det.config_delta = 0
1080: AND cz_det.config_hdr_id = oe_ol.config_header_id

Line 1129: FROM oe_order_lines oe_oel, mtl_system_items mtl_msi

1125: x_msg_count := 1;
1126:
1127: SELECT description
1128: INTO l_description
1129: FROM oe_order_lines oe_oel, mtl_system_items mtl_msi
1130: WHERE oe_oel.line_id = p_line_id
1131: AND oe_oel.inventory_item_id = mtl_msi.inventory_item_id
1132: AND oe_oel.org_id = mtl_msi.organization_id;
1133:

Line 1193: FROM oe_order_lines oe_l

1189: ,header_id
1190: INTO l_top_config_header_id
1191: ,l_top_config_rev_nbr
1192: ,l_header_id
1193: FROM oe_order_lines oe_l
1194: WHERE oe_l.line_id = p_top_model_line_id;
1195:
1196: IF l_debug_level > 0 THEN
1197: OE_DEBUG_PUB.Add('Unchanged Lines Count:'||l_cursor_count,3);

Line 1304: FROM oe_order_lines

1300: CURSOR C_TOP_MODELS IS
1301: SELECT line_id
1302: ,ato_line_id
1303: ,top_model_line_id
1304: FROM oe_order_lines
1305: WHERE header_id = p_header_id
1306: AND top_model_line_id IS NOT NULL
1307: AND line_id = top_model_line_id;
1308:

Line 1490: FROM oe_order_lines

1486: IF p_top_model_line_id IS NOT NULL THEN
1487: BEGIN
1488: SELECT 'A'
1489: INTO l_config_mode
1490: FROM oe_order_lines
1491: WHERE line_id = p_top_model_line_id
1492: AND config_header_id IS NOT NULL;
1493: EXCEPTION
1494: WHEN NO_DATA_FOUND THEN

Line 1521: FROM oe_order_lines

1517: ,inventory_item_id
1518: INTO l_config_creation_date
1519: ,l_header_id
1520: ,l_model_inv_item_id
1521: FROM oe_order_lines
1522: WHERE line_id = p_top_model_line_id;
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: oe_debug_pub.add('Other exception in select from oe-order_lines',3);

Line 1525: oe_debug_pub.add('Other exception in select from oe-order_lines',3);

1521: FROM oe_order_lines
1522: WHERE line_id = p_top_model_line_id;
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: oe_debug_pub.add('Other exception in select from oe-order_lines',3);
1526: END;
1527:
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add('RMV: After select from order_lines...',3);

Line 1709: FROM oe_order_lines

1705: END IF;
1706:
1707: SELECT line_id
1708: INTO l_line_tbl(I).line_id
1709: FROM oe_order_lines
1710: WHERE header_id = l_line_tbl(I).header_id
1711: AND config_header_id = l_line_tbl(I).config_header_id
1712: AND config_rev_nbr = l_line_tbl(I).config_rev_nbr;
1713:

Line 1767: FROM oe_order_lines

1763: ,inventory_item_id
1764: INTO l_config_header_id
1765: ,l_config_rev_nbr
1766: ,l_inventory_item_id
1767: FROM oe_order_lines
1768: WHERE line_id = p_top_model_line_id;
1769:
1770: EXCEPTION
1771: WHEN OTHERS THEN

Line 1939: FROM oe_order_lines_all

1935: l_instance_tbl csi_datastructures_pub.instance_cz_tbl;
1936:
1937: CURSOR Models is
1938: SELECT line_id
1939: FROM oe_order_lines_all
1940: WHERE header_id = p_x_header_id
1941: AND open_flag = 'Y'
1942: AND top_model_line_id = line_id
1943: AND ATO_LINE_ID IS NULL;

Line 2848: From oe_order_lines_all

2844: Begin
2845:
2846: Select config_header_id, config_rev_nbr
2847: Into l_top_config_header_id, l_top_config_rev_nbr
2848: From oe_order_lines_all
2849: Where line_id = l_top_model_line_id;
2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN

Line 2923: From oe_order_lines_all

2919: Begin
2920:
2921: Select config_header_id, config_rev_nbr, configuration_id
2922: Into l_config_header_id, l_config_rev_nbr, l_config_item_id
2923: From oe_order_lines_all
2924: Where line_id = l_line_tbl(M).line_id;
2925:
2926: L_line_tbl(M).config_header_id := l_config_header_id;
2927: L_line_tbl(M).config_rev_nbr := l_config_rev_nbr;

Line 3168: From oe_order_lines_all

3164: Begin
3165:
3166: Select config_header_id, config_rev_nbr
3167: Into l_top_config_header_id, l_top_config_rev_nbr
3168: From oe_order_lines_all
3169: Where line_id = l_top_model_line_id;
3170:
3171: Exception
3172: When OTHERS THEN

Line 3269: from cz_config_details_v cz, oe_order_lines_all oe

3265: /*
3266: Select cz.config_hdr_id, cz.config_rev_nbr, substr(cz.component_code, 1,instr(cz.component_code,'-')-1),
3267: oe.top_model_line_id
3268: Into l_config_hdr_id, l_config_rev_nbr, L_item_id,x_top_model_line_id
3269: from cz_config_details_v cz, oe_order_lines_all oe
3270: where cz.instance_hdr_id = p_config_instance_hdr_id
3271: and oe.config_header_id = cz.config_hdr_id
3272: and oe.config_rev_nbr = cz.config_rev_nbr
3273: and oe.top_model_line_id = oe.line_id

Line 3300: From oe_order_lines_all

3296: Begin
3297:
3298: Select top_model_line_id
3299: Into x_top_model_line_id
3300: From oe_order_lines_all
3301: Where header_id = p_header_id
3302: -- And config_header_id = l_config_hdr_id
3303: -- And config_rev_nbr = l_config_rev_nbr
3304: AND open_flag = 'Y'

Line 3311: oe_debug_pub.add('In when Others of oe_order_lines query',2);

3307: AND rownum = 1;
3308:
3309: Exception
3310: WHEN OTHERS THEN
3311: oe_debug_pub.add('In when Others of oe_order_lines query',2);
3312: Null;
3313: --RETURN;
3314: End;
3315: END IF;

Line 3376: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

3372: Begin
3373:
3374: SELECT cz_hdr.baseline_rev_nbr
3375: INTO l_baseline_rev_nbr
3376: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3377: cz_config_details_v czv
3378: WHERE oe_line.top_model_line_id = p_top_model_line_id
3379: AND oe_line.configuration_id = P_instance_item_id
3380: AND czv.config_hdr_id = oe_line.config_header_id

Line 3410: FROM oe_order_lines_all oe_line

3406: BEGIN
3407:
3408: SELECT configuration_id, component_code
3409: INTO x_config_item_id, x_component_code
3410: FROM oe_order_lines_all oe_line
3411: WHERE oe_line.top_model_line_id = p_top_model_line_id
3412: AND oe_line.configuration_id = p_instance_item_id
3413: AND rownum = 1;
3414:

Line 3480: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

3476:
3477: Begin
3478: SELECT cz_hdr.baseline_rev_nbr
3479: INTO l_baseline_rev_nbr
3480: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3481: cz_config_details_v czv
3482: WHERE oe_line.line_id = p_line_id
3483: AND czv.config_hdr_id = oe_line.config_header_id
3484: AND czv.config_rev_nbr = oe_line.config_rev_nbr