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.CSP_PARTS_ORDER dependencies on OE_ORDER_LINES_ALL

Line 662: FROM oe_order_lines_all

658: FOR I in 1..l_line_tbl.count LOOP
659: BEGIN
660: SELECT org_id
661: INTO l_source_operating_unit
662: FROM oe_order_lines_all
663: WHERE line_id = l_line_tbl(i).order_line_id;
664: EXCEPTION
665: WHEN NO_DATA_FOUND THEN
666: RAISE NO_DATA_FOUND;

Line 4935: select org_id into l_org_id from oe_order_lines_all where line_id = p_oe_line_id;

4931: 'p_oe_line_id = ' || p_oe_line_id
4932: || ', p_ship_method = ' || p_ship_method);
4933: end if;
4934:
4935: select org_id into l_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4936: l_org_org_id := mo_global.get_current_org_id;
4937:
4938: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4971: select ship_from_org_id into l_ship_from_org_id from oe_order_lines_all where line_id = p_oe_line_id;

4967: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4968: l_line_tbl(1).shipping_method_code := p_ship_method;
4969:
4970: -- bug # 12664116
4971: select ship_from_org_id into l_ship_from_org_id from oe_order_lines_all where line_id = p_oe_line_id;
4972:
4973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4975: 'l_ship_from_org_id = ' || l_ship_from_org_id);

Line 5106: oe_order_lines_all oel

5102: cursor check_io_status is
5103: SELECT count(1)
5104: FROM csp_requirement_lines cl,
5105: csp_req_line_details cld,
5106: oe_order_lines_all oel
5107: WHERE cl.requirement_header_id = p_req_header_id
5108: AND cl.requirement_line_id = cld.requirement_line_id
5109: AND cld.source_type = 'IO'
5110: AND cld.source_id = oel.line_id

Line 5117: oe_order_lines_all oel,

5113: cursor get_booked_order_num is
5114: SELECT oeh.order_number
5115: FROM csp_requirement_lines cl,
5116: csp_req_line_details cld,
5117: oe_order_lines_all oel,
5118: oe_order_headers_all oeh
5119: WHERE cl.requirement_header_id = p_req_header_id
5120: AND cl.requirement_line_id = cld.requirement_line_id
5121: AND cld.source_type = 'IO'

Line 5131: oe_order_lines_all oel

5127: cursor get_order_header_ids is
5128: SELECT distinct oel.header_id
5129: FROM csp_requirement_lines cl,
5130: csp_req_line_details cld,
5131: oe_order_lines_all oel
5132: WHERE cl.requirement_header_id = p_req_header_id
5133: AND cl.requirement_line_id = cld.requirement_line_id
5134: AND cld.source_type = 'IO'
5135: AND cld.source_id = oel.line_id