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.ZX_TDS_PROCESS_CEC_PVT dependencies on HZ_LOCATIONS

Line 43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

39:
40: pr_site_use_rec pr_site_use_rec_type;
41:
42: TYPE pr_site_loc_rec_type is RECORD(
43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,

Line 44: STATE HZ_LOCATIONS.STATE%TYPE,

40: pr_site_use_rec pr_site_use_rec_type;
41:
42: TYPE pr_site_loc_rec_type is RECORD(
43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,
48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);

Line 45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,

41:
42: TYPE pr_site_loc_rec_type is RECORD(
43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,
48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
49:

Line 46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,

42: TYPE pr_site_loc_rec_type is RECORD(
43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,
48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
49:
50: pr_site_loc_rec pr_site_loc_rec_type;

Line 47: CITY HZ_LOCATIONS.CITY%TYPE,

43: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
44: STATE HZ_LOCATIONS.STATE%TYPE,
45: COUNTY HZ_LOCATIONS.COUNTY%TYPE,
46: PROVINCE HZ_LOCATIONS.PROVINCE%TYPE,
47: CITY HZ_LOCATIONS.CITY%TYPE,
48: CUST_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE);
49:
50: pr_site_loc_rec pr_site_loc_rec_type;
51:

Line 759: HZ_LOCATIONS LOC,

755: loc.CITY,
756: acct_site.CUST_ACCT_SITE_ID
757: from HZ_PARTY_SITES PARTY_SITE,
758: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
759: HZ_LOCATIONS LOC,
760: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
761: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND
762: LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND
763: -- LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND