[Home] [Help]
507: WSH.LATITUDE,
508: WSH.LONGITUDE,
509: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
510: SYSDATE
511: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
512: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
513: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
514: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
515: AND hr.location_id = wsh.source_location_id
551: AND HRTL.LANGUAGE = USERENV('LANG')
552: AND LOCATION_SOURCE_CODE = 'HR'
553: AND hr.location_id = pla.location_id
554: AND hr.location_id not in (select ou.location_id from
555: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id
556: and ou.location_id = hr.location_id)
557: union
558: SELECT SOURCE_LOCATION_ID,
559: hr.ADDRESS_LINE_1,
586: AND HRTL.LANGUAGE = USERENV('LANG')
587: AND LOCATION_SOURCE_CODE = 'HR'
588: AND p_caller IN ('PO','HR')
589: AND hr.location_id not in (select ou.location_id from
590: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id
591: and ou.location_id = hr.location_id)
592: ORDER BY SOURCE_LOCATION_ID;
593:
594:
614: OU.NAME,
615: NULL,
616: NULL,
617: HR.TIMEZONE_CODE
618: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
619: WHERE HR.LOCATION_ID between p_from_location and p_to_location
620: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
621: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
622: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl
659: AND HRTL.LOCATION_ID = HR.LOCATION_ID
660: AND HRTL.LANGUAGE = USERENV('LANG')
661: AND hr.location_id = pla.location_id
662: AND hr.location_id not in (select ou.location_id from
663: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id
664: and ou.location_id = hr.location_id)
665: union
666: SELECT HR.LOCATION_ID internal_location_id,
667: hr.ADDRESS_LINE_1,
694: AND HRTL.LOCATION_ID = HR.LOCATION_ID
695: AND HRTL.LANGUAGE = USERENV('LANG')
696: AND p_caller = 'PO'
697: AND hr.location_id not in (select ou.location_id from
698: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id
699: and ou.location_id = hr.location_id)
700: -- Added following UNION for bug 4337181 (FP of Bug 4255943)
701: union
702: SELECT HR.LOCATION_ID internal_location_id,
731: AND HRTL.LOCATION_ID = HR.LOCATION_ID
732: AND HRTL.LANGUAGE = USERENV('LANG')
733: AND nvl(p_caller, 'WSH') in ( 'WSH', 'HR' )
734: AND hr.location_id not in (select ou.location_id from
735: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id
736: and ou.location_id = hr.location_id)
737: ORDER BY internal_location_id
738: ;
739:
1967: -- TODO
1968: -- might not be tied to internal org
1969: CURSOR get_org_info(c_location_id IN NUMBER) IS
1970: SELECT ou.organization_id
1971: FROM hr_organization_units ou, mtl_parameters mp
1972: WHERE ou.organization_id = mp.organization_id
1973: AND ou.location_id = c_location_id;
1974:
1975: CURSOR check_party_carrier_supplier(l_party_id IN NUMBER) IS