APPS.CSP_SCH_INT_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

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 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 5039: from HR_ALL_ORGANIZATION_UNITS

5035: and lookup_code = l_item_type;
5036:
5037: CURSOR get_location_id(c_org_id NUMBER) IS
5038: select location_id
5039: from HR_ALL_ORGANIZATION_UNITS
5040: where organization_id = c_org_id;
5041:
5042: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
5043: select CONCATENATED_SEGMENTS