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_PART_SEARCH_PVT dependencies on SDO_GEOM

Line 28: l_my_location sdo_geometry;

24: l_organization_id number;
25: l_subinventory_code varchar2(30);
26: l_enough number := -1;
27: l_open_or_closed varchar2(30) := 'OPEN';
28: l_my_location sdo_geometry;
29: l_distance_uom varchar2(30) := 'unit=km';
30: l_server_timezone_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
31: l_search_method varchar2(30):= nvl(p_search_params.search_method,
32: fnd_profile.value('CSP_PART_SEARCH_METHOD'));

Line 496: l_geometry mdsys.sdo_geometry;

492: where moq.organization_id = csi.organization_id
493: and moq.subinventory_code = csi.secondary_inventory_name
494: and moq.inventory_item_id = crpt.alternate_item_id);
495:
496: l_geometry mdsys.sdo_geometry;
497: l_point mdsys.sdo_point_type := mdsys.sdo_point_type(-9999,-9999,0);
498: l_test number := 0;
499: cursor c_compare(p_point mdsys.sdo_point_type) is
500: select 1 from dual

Line 514: l_geometry := MDSYS.SDO_GEOMETRY(2001,8307,cr.point,null,null);

510: fetch c_compare into l_test;
511: close c_compare;
512: log('technicians','l_test:'||l_test);
513: if l_test = 1 then
514: l_geometry := MDSYS.SDO_GEOMETRY(2001,8307,cr.point,null,null);
515: else
516: l_geometry := cr.geometry;
517: end if;
518: l_test := 0;

Line 557: round(sdo_geom.sdo_distance(l_my_location,l_geometry,

553: null shipping_date,
554: null shipping_method,
555: 0 shipping_cost,
556: sysdate arrival_date,
557: round(sdo_geom.sdo_distance(l_my_location,l_geometry,
558: 1000,l_distance_uom),1) distance,
559: l_geometry,
560: case nvl(csoc.object_type,'CLOSED')
561: when 'CLOSED' then 'CLOSED'

Line 574: round(sdo_geom.sdo_distance(

570: and csi.organization_id = cr.organization_id
571: and csi.secondary_inventory_name = cr.secondary_inventory
572: and cr.condition_type = 'G'
573: and decode(p_search_params.distance,null,-1,
574: round(sdo_geom.sdo_distance(
575: l_my_location,
576: l_geometry,
577: 1000,
578: l_distance_uom),1)) <= nvl(p_search_params.distance,-1)

Line 632: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,

628: null shipping_date,
629: null shipping_method,
630: 0 shipping_cost,
631: sysdate arrival_date,
632: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,
633: 1000,l_distance_uom),1) distance,
634: hl.geometry,
635: decode(sign(hz_timezone_pub.convert_datetime(
636: l_server_timezone_id,

Line 651: round(sdo_geom.sdo_distance(

647: hz_locations hl
648: where cpp.stocking_site_type = 'UNMANNED'
649: and nvl(cpp.stocking_site_excl,'N') = 'N'
650: and decode(p_search_params.distance,null,-1,
651: round(sdo_geom.sdo_distance(
652: l_my_location,
653: hl.geometry,
654: 1000,
655: l_distance_uom),1)) <= nvl(p_search_params.distance,-1)

Line 729: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,

725: null shipping_date,
726: null shipping_method,
727: null shipping_cost,
728: null arrival_date,
729: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,
730: 1000,l_distance_uom),1),
731: hl.geometry,
732: decode(sign(hz_timezone_pub.convert_datetime(
733: l_server_timezone_id,

Line 750: round(sdo_geom.sdo_distance(

746: and cpp.organization_id = cr.organization_id
747: and nvl(cpp.stocking_site_excl,'N') = 'N'
748: and hl.location_id (+) = cpp.hz_location_id
749: and decode(p_search_params.distance,null,-1,
750: round(sdo_geom.sdo_distance(
751: l_my_location,
752: hl.geometry,
753: 1000,
754: l_distance_uom),1)) <= nvl(p_search_params.distance,-1)

Line 824: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,

820: null shipping_date,
821: null shipping_method,
822: null shipping_cost,
823: null arrival_date,
824: round(sdo_geom.sdo_distance(l_my_location,hl.geometry,
825: 1000,l_distance_uom),1),
826: hl.geometry,
827: decode(sign(hz_timezone_pub.convert_datetime(
828: l_server_timezone_id,

Line 844: round(sdo_geom.sdo_distance(

840: where cpp.organization_id = p_search_params.source_organization_id
841: and nvl(cpp.stocking_site_excl,'N') = 'N'
842: and hl.location_id (+) = cpp.hz_location_id
843: and decode(p_search_params.distance,null,-1,
844: round(sdo_geom.sdo_distance(
845: l_my_location,
846: hl.geometry,
847: 1000,
848: l_distance_uom),1)) <= nvl(p_search_params.distance,-1)

Line 2091: l_src_geo sdo_geometry;

2087: p_src_org_id number,
2088: p_src_subinv varchar2
2089: )
2090: return varchar2 is
2091: l_src_geo sdo_geometry;
2092: l_dest_geo sdo_geometry;
2093: l_distance_uom_code varchar2(10);
2094: l_distance_uom varchar2(100);
2095: l_distance varchar2(100) := '-';

Line 2092: l_dest_geo sdo_geometry;

2088: p_src_subinv varchar2
2089: )
2090: return varchar2 is
2091: l_src_geo sdo_geometry;
2092: l_dest_geo sdo_geometry;
2093: l_distance_uom_code varchar2(10);
2094: l_distance_uom varchar2(100);
2095: l_distance varchar2(100) := '-';
2096: l_distance_uom_meaning varchar2(100);

Line 2143: SELECT ROUND(sdo_geom.sdo_distance(l_src_geo, l_dest_geo, 1000, l_distance_uom),1)

2139: l_distance_uom := 'unit=mile';
2140: end if;
2141: log('get_src_distance','l_distance_uom:'||l_distance_uom);
2142:
2143: SELECT ROUND(sdo_geom.sdo_distance(l_src_geo, l_dest_geo, 1000, l_distance_uom),1)
2144: INTO l_distance
2145: FROM dual;
2146: log('get_src_distance','l_distance:'||l_distance);
2147: