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

Line 27: ,country HZ_LOCATIONS.COUNTRY%TYPE

23: ,date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE
24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE

Line 28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE

24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE

Line 29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE

25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE

Line 30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE

26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE

Line 31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE

27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE

Line 32: ,city HZ_LOCATIONS.CITY%TYPE

28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE

Line 33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE

29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE

Line 34: ,state HZ_LOCATIONS.STATE%TYPE

30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE
31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE

Line 35: ,province HZ_LOCATIONS.PROVINCE%TYPE

31: ,address4 HZ_LOCATIONS.ADDRESS4%TYPE
32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE

Line 36: ,county HZ_LOCATIONS.COUNTY%TYPE

32: ,city HZ_LOCATIONS.CITY%TYPE
33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE

Line 37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE

33: ,postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE
34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE

Line 38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE

34: ,state HZ_LOCATIONS.STATE%TYPE
35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE

Line 39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE

35: ,province HZ_LOCATIONS.PROVINCE%TYPE
36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE

Line 40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE

36: ,county HZ_LOCATIONS.COUNTY%TYPE
37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE

Line 41: ,street HZ_LOCATIONS.STREET%TYPE

37: ,po_box_number HZ_LOCATIONS.PO_BOX_NUMBER%TYPE
38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE

Line 42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE

38: ,house_number HZ_LOCATIONS.HOUSE_NUMBER%TYPE
39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE

Line 43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE

39: ,street_suffix HZ_LOCATIONS.STREET_SUFFIX%TYPE
40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE

Line 44: ,building HZ_LOCATIONS.BUILDING%TYPE

40: ,apartment_number HZ_LOCATIONS.APARTMENT_NUMBER%TYPE
41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE

Line 45: ,floor HZ_LOCATIONS.FLOOR%TYPE

41: ,street HZ_LOCATIONS.STREET%TYPE
42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE

Line 46: ,suite HZ_LOCATIONS.SUITE%TYPE

42: ,rural_route_number HZ_LOCATIONS.RURAL_ROUTE_NUMBER%TYPE
43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE

Line 47: ,room HZ_LOCATIONS.ROOM%TYPE

43: ,street_number HZ_LOCATIONS.STREET_NUMBER%TYPE
44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE

Line 48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE

44: ,building HZ_LOCATIONS.BUILDING%TYPE
45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE
52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);