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.WSH_LOCATIONS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 555: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_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,

Line 590: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id

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:

Line 663: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id

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,

Line 698: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_id

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,

Line 735: hr_all_organization_units ou,mtl_parameters mp WHERE ou.organization_id = mp.organization_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: