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 1708: FROM oe_order_lines

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

Line 1766: FROM oe_order_lines

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

Line 1938: FROM oe_order_lines_all

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

Line 2847: From oe_order_lines_all

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

Line 2922: From oe_order_lines_all

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

Line 3167: From oe_order_lines_all

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

Line 3268: from cz_config_details_v cz, oe_order_lines_all oe

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

Line 3299: From oe_order_lines_all

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

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

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

Line 3375: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

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

Line 3409: FROM oe_order_lines_all oe_line

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

Line 3479: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

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