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_WORKBENCH_UTIL_PK dependencies on OE_ORDER_LINES_ALL

Line 34: line_number oe_order_lines_all.line_number%type;

30: p_Component_Number IN NUMBER ,
31: p_Service_Number IN NUMBER
32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;

Line 35: shipment_number oe_order_lines_all.shipment_number%type;

31: p_Service_Number IN NUMBER
32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:

Line 36: option_number oe_order_lines_all.option_number%type;

32: ) Return varchar2 IS
33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN

Line 37: component_number oe_order_lines_all.component_number%type;

33: l_concat_value Varchar2(100);
34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN
41:

Line 38: service_number oe_order_lines_all.service_number%type;

34: line_number oe_order_lines_all.line_number%type;
35: shipment_number oe_order_lines_all.shipment_number%type;
36: option_number oe_order_lines_all.option_number%type;
37: component_number oe_order_lines_all.component_number%type;
38: service_number oe_order_lines_all.service_number%type;
39:
40: BEGIN
41:
42: If p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then

Line 55: from oe_order_lines_all

51: shipment_number,
52: option_number,
53: component_number,
54: service_number
55: from oe_order_lines_all
56: where ato_line_id = p_ato_line_id
57: and item_type_code = 'CONFIG';
58:
59: EXCEPTION --- fp-J: added EXCEPTION block

Line 96: l_line_id oe_order_lines_all.line_id%type;

92: p_Ato_Line_Id IN NUMBER,
93: p_Item_Type_code IN Varchar2,
94: p_flow_status IN Varchar2) Return Varchar2 is
95: l_flow_status Varchar2(100):=null;
96: l_line_id oe_order_lines_all.line_id%type;
97: l_flow_status_code oe_order_lines_all.flow_status_code%type;
98: Begin
99:
100: l_flow_status := p_flow_status;

Line 97: l_flow_status_code oe_order_lines_all.flow_status_code%type;

93: p_Item_Type_code IN Varchar2,
94: p_flow_status IN Varchar2) Return Varchar2 is
95: l_flow_status Varchar2(100):=null;
96: l_line_id oe_order_lines_all.line_id%type;
97: l_flow_status_code oe_order_lines_all.flow_status_code%type;
98: Begin
99:
100: l_flow_status := p_flow_status;
101: if (p_Line_id = p_ato_line_id and p_item_type_code in ('MODEL', 'CLASS')) then

Line 107: from oe_order_lines_all oel

103: select line_id,
104: flow_status_code
105: into l_line_id,
106: l_flow_status_code
107: from oe_order_lines_all oel
108: where oel.ato_line_id = p_ato_line_id
109: and oel.item_type_code = 'CONFIG';
110: else
111:

Line 155: from oe_order_lines_all

151: elsif (p_ato_line_id = p_line_id and p_item_type in ('MODEL', 'CLASS')) then
152:
153: select line_id
154: into l_demand_line_id
155: from oe_order_lines_all
156: where ato_line_id = p_ato_line_id
157: and item_type_code = 'CONFIG';
158:
159: else

Line 371: l_config_line_id oe_order_lines_all.line_id%type;

367: Function Get_config_line_id (P_ato_line_id IN Number,
368: p_line_id IN Number,
369: p_item_type IN Varchar2) return number as
370:
371: l_config_line_id oe_order_lines_all.line_id%type;
372:
373: Begin
374: l_config_line_id := p_line_id;
375:

Line 383: from oe_order_lines_all

379: l_config_line_id := config_line_id_tbl(p_ato_line_id);
380: else
381:
382: select line_id into l_config_line_id
383: from oe_order_lines_all
384: where ato_line_id = p_ato_line_id
385: and item_type_code = 'CONFIG';
386:
387: config_line_id_tbl(p_ato_line_id) := l_config_line_id;

Line 425: oe_order_lines_all oel

421:
422: select concatenated_segments
423: into l_item_name
424: from mtl_system_items_kfv mtl,
425: oe_order_lines_all oel
426: where oel.ato_line_id = p_ato_line_id
427: and oel.item_type_code = 'CONFIG'
428: and oel.inventory_item_id = mtl.inventory_item_id
429: and mtl.organization_id = p_ship_org_id;

Line 461: oe_order_lines_all oel

457:
458: select description
459: into l_item_desc
460: from mtl_system_items_kfv mtl,
461: oe_order_lines_all oel
462: where mtl.inventory_item_id = oel.inventory_item_id
463: and mtl.organization_id = p_ship_org_id
464: and oel.ato_line_id = p_ato_line_id
465: and oel.item_type_code = 'CONFIG';

Line 480: from oe_order_headers_all h, oe_order_lines_all l

476: BEGIN
477:
478: select h.source_document_type_id
479: into l_source_document_type_id
480: from oe_order_headers_all h, oe_order_lines_all l
481: where h.header_id = l.header_id
482: and l.line_id = pLineId
483: and rownum = 1;
484:

Line 620: from oe_order_lines_all

616: If p_ato_line_id is not null then
617: if p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then
618: select line_id
619: into l_line_id
620: from oe_order_lines_all
621: where ato_line_id = p_ato_line_id
622: and item_type_code = 'CONFIG';
623: End if;
624: end if;

Line 642: from oe_order_lines_all oel

638: oel.order_quantity_uom,
639: nvl(l_prim_rsv_qty,0),
640: oel.inventory_item_id)
641: into l_rsv_qty
642: from oe_order_lines_all oel
643: where oel.line_id = l_line_id;
644: else
645: l_rsv_qty := 0;
646: End if;

Line 801: from oe_order_lines_all

797: If p_ato_line_id is not null then
798: if p_ato_line_id = p_line_id and p_item_type_code in ('MODEL','CLASS') then
799: select line_id
800: into l_line_id
801: from oe_order_lines_all
802: where ato_line_id = p_ato_line_id
803: and item_type_code = 'CONFIG';
804: End if;
805: end if;

Line 823: from oe_order_lines_all oel

819: oel.order_quantity_uom,
820: nvl(l_prim_rsv_qty,0),
821: oel.inventory_item_id)
822: into l_rsv_qty
823: from oe_order_lines_all oel
824: where oel.line_id = l_line_id;
825: else
826: l_rsv_qty := 0;
827: End if;

Line 867: from oe_order_lines_all

863: if config_line_id_tbl.exists(p_ato_line_id) then
864: x_config_line_id := config_line_id_tbl(p_ato_line_id);
865: else
866: select line_id into x_config_line_id
867: from oe_order_lines_all
868: where ato_line_id = p_ato_line_id
869: and item_type_code = 'CONFIG';
870:
871: config_line_id_tbl(p_ato_line_id) := x_config_line_id;