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.JL_JLCOARCR_XMLP_PKG dependencies on HR_LOCATIONS

Line 45: HR_LOCATIONS HR,

41: LE.ADDRESS_LINE_2,
42: LE.ADDRESS_LINE_3
43: INTO COMPANY_NAME,NIT_NUMBER,VADDRESS1,VADDRESS2,VADDRESS3
44: FROM
45: HR_LOCATIONS HR,
46: XLE_FIRSTPARTY_INFORMATION_V LE
47: WHERE HR.LOCATION_ID = LE.LOCATION_ID
48: AND LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
49: EXCEPTION

Line 63: HR_LOCATIONS HL,

59: GEO.GEOGRAPHY_NAME
60: INTO VTOWN_CITY
61: FROM
62: HZ_GEOGRAPHIES GEO,
63: HR_LOCATIONS HL,
64: XLE_FIRSTPARTY_INFORMATION_V LE
65: WHERE GEO.GEOGRAPHY_NAME = HL.TOWN_OR_CITY
66: AND GEO.GEOGRAPHY_TYPE = 'CITY'
67: AND GEO.COUNTRY_CODE = HL.COUNTRY

Line 81: HR_LOCATIONS HRL,

77: GEO.GEOGRAPHY_NAME
78: INTO VREGION
79: FROM
80: HZ_GEOGRAPHIES GEO,
81: HR_LOCATIONS HRL,
82: XLE_FIRSTPARTY_INFORMATION_V LE
83: WHERE LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
84: AND LE.LOCATION_ID = HRL.LOCATION_ID
85: AND GEO.GEOGRAPHY_CODE = HRL.REGION_2

Line 98: HR_LOCATIONS HL

94: FT.TERRITORY_SHORT_NAME
95: INTO VCOUNTRY
96: FROM
97: FND_TERRITORIES_VL FT,
98: HR_LOCATIONS HL
99: WHERE FT.TERRITORY_CODE = HL.COUNTRY
100: AND HL.LOCATION_ID = VLOCATION_ID;
101: EXCEPTION
102: WHEN OTHERS THEN