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

Line 212: from oe_order_lines_all oel,

208: begin
209:
210: select oeh.order_number
211: into l_order_number
212: from oe_order_lines_all oel,
213: oe_order_headers_all oeh
214: where oel.line_id = v_lines.ato_line_id
215: and oel.header_id = oeh.header_id;
216:

Line 304: from oe_order_lines_all oel,

300: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: WriteToLog('ERROR: Populate_src_orgs_upg returned with exp error',1);
302: select oeh.order_number
303: into l_order_number
304: from oe_order_lines_all oel,
305: oe_order_headers_all oeh
306: where oel.line_id = v_lines.ato_line_id
307: and oel.header_id = oeh.header_id;
308:

Line 535: from oe_order_lines_all oel,

531: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
532: WriteToLog('ERROR: Create_oss_sourcing_rules returned with exp error',1);
533: select oeh.order_number
534: into l_order_number
535: from oe_order_lines_all oel,
536: oe_order_headers_all oeh
537: where oel.line_id = v_lines.ato_line_id
538: and oel.header_id = oeh.header_id;
539:

Line 593: from oe_order_lines_all oel,

589: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
590: WriteToLog('ERROR: Create_sourcing_rules returned with exp error',1);
591: select oeh.order_number
592: into l_order_number
593: from oe_order_lines_all oel,
594: oe_order_headers_all oeh
595: where oel.line_id = v_lines.ato_line_id
596: and oel.header_id = oeh.header_id;
597:

Line 646: from oe_order_lines_all oel,

642: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
643: WriteToLog('ERROR: Create_type3_sourcing_rules returned with exp error',1);
644: select oeh.order_number
645: into l_order_number
646: from oe_order_lines_all oel,
647: oe_order_headers_all oeh
648: where oel.line_id = v_lines.ato_line_id
649: and oel.header_id = oeh.header_id;
650:

Line 2902: from oe_order_lines_all ol

2898: select nvl(costing_group_id,1)
2899: into l_cst_grp
2900: from pjm_project_parameters ppp
2901: where ppp.project_id = ( select project_id
2902: from oe_order_lines_all ol
2903: where ol.line_id = pLineId )
2904: and ppp.organization_id = pOrgId;
2905:
2906: if (l_cst_grp = 0) then