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_SCH_INT_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 2433: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

2429: ,x_msg_count OUT NOCOPY NUMBER) IS
2430:
2431: cursor location_shipping_method_count(c_from_org_id number, c_to_location_id number) IS
2432: SELECT count(*)
2433: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
2434: where hao.organization_id = c_from_org_id
2435: and ism.from_location_id = hao.location_id
2436: and ism.to_location_id = c_to_location_id;
2437:

Line 2879: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

2875: CURSOR csp_ship_methodes(from_org varchar2,to_org varchar2) IS
2876: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0)
2877: ,CDT.FREIGHT_CODE,CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
2878: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
2879: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
2880: WHERE ISM.FROM_ORGANIZATION_ID = from_org
2881: AND ISM.TO_ORGANIZATION_ID = to_org
2882: AND CDT.ORGANIZATION_ID = from_org
2883: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 2901: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

2897:
2898: cursor csp_location_ship_methods(c_from_org_id number, c_to_location_id number) IS
2899: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
2900: ism.intransit_time,ism.from_location_id,ism.to_location_id,ism.destination_type
2901: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
2902: where hao.organization_id = c_from_org_id
2903: and ism.from_location_id = hao.location_id
2904: and ism.to_location_id = c_to_location_id
2905: and ism.destination_type ='L'

Line 2909: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

2905: and ism.destination_type ='L'
2906: UNION ALL
2907: /*SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
2908: ism.intransit_time,ism.from_location_id,ism.to_location_id,ism.destination_type
2909: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
2910: where hao.organization_id = c_from_org_id
2911: and ism.from_location_id = hao.location_id
2912: and ism.destination_type ='R'
2913: and ism.to_region_id IN(select wlr.REGION_ID

Line 2919: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

2915: where wlr.location_id = c_to_location_id
2916: and wzr.REGION_ID(+) = wlr.region_id)*/
2917: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
2918: ism.intransit_time,ism.from_location_id,ism.to_location_id,ism.destination_type
2919: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
2920: where hao.organization_id = c_from_org_id
2921: and ism.from_location_id = hao.location_id
2922: and ism.destination_type ='R'
2923: and ism.to_region_id IN (select wlr.region_id

Line 2930: MTL_INTERORG_SHIP_METHODS ISM1,HR_ALL_ORGANIZATION_UNITS hao,WSH_LOCATIONS_REGIONS_V wlr1

2926: and wzr.REGION_ID(+) = wlr.region_id
2927: and wlr.region_type = (select max(region_type)
2928: from WSH_REGION_LOCATIONS_VL wrl2
2929: where wrl2.region_id IN(SELECT ism1.to_region_id FROM
2930: MTL_INTERORG_SHIP_METHODS ISM1,HR_ALL_ORGANIZATION_UNITS hao,WSH_LOCATIONS_REGIONS_V wlr1
2931: where hao.organization_id = c_from_org_id
2932: and ism1.from_location_id = hao.location_id
2933: and ism1.destination_type ='R')))
2934: UNION ALL

Line 2937: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

2933: and ism1.destination_type ='R')))
2934: UNION ALL
2935: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
2936: ism.intransit_time,ism.from_location_id,ism.to_location_id,ism.destination_type
2937: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
2938: where hao.organization_id = c_from_org_id
2939: and ism.from_location_id = hao.location_id
2940: and ism.destination_type ='Z'
2941: and ism.to_region_id IN(select wzr.zone_id

Line 3606: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

3602: ,x_msg_count OUT NOCOPY NUMBER) IS
3603: CURSOR C3(from_org varchar2,to_org varchar2) IS
3604: SELECT NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
3605: CDT.RELATION_SHIP_ID,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,ISM.SHIP_METHOD
3606: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
3607: WHERE ISM.FROM_ORGANIZATION_ID = from_org
3608: AND ISM.TO_ORGANIZATION_ID = to_org
3609: AND CDT.ORGANIZATION_ID = from_org
3610: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;