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

Line 47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE

43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE

Line 48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE

44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE

Line 49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE

45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE

Line 50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE

46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
54: ,p_customer_lattitude IN VARCHAR2

Line 51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE

47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
54: ,p_customer_lattitude IN VARCHAR2
55: ,p_customer_longitude IN VARCHAR2

Line 52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE

48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
54: ,p_customer_lattitude IN VARCHAR2
55: ,p_customer_longitude IN VARCHAR2
56: ,p_max_no_partners IN NUMBER

Line 53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE

49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
51: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
52: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
53: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
54: ,p_customer_lattitude IN VARCHAR2
55: ,p_customer_longitude IN VARCHAR2
56: ,p_max_no_partners IN NUMBER
57: ,p_distance IN NUMBER

Line 83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,

79: (
80: DISTANCE NUMBER,
81: PARTY_RELATION_ID NUMBER,
82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,

Line 84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,

80: DISTANCE NUMBER,
81: PARTY_RELATION_ID NUMBER,
82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

Line 85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,

81: PARTY_RELATION_ID NUMBER,
82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

Line 86: CITY HZ_LOCATIONS.CITY%TYPE,

82: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,

Line 87: STATE HZ_LOCATIONS.STATE%TYPE,

83: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,

Line 88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

84: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,

Line 89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

85: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
86: CITY HZ_LOCATIONS.CITY%TYPE,
87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,
93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,

Line 104: l_customer_geocode_object HZ_LOCATIONS.GEOMETRY%TYPE;

100: l_partner_tbl party_address_rec_tbl;
101: l_counter NUMBER :=0;
102: l_return_partner_tbl party_address_rec_tbl;
103: l_customer_rec party_address_rec_type;
104: l_customer_geocode_object HZ_LOCATIONS.GEOMETRY%TYPE;
105: l_query VARCHAR2(4000);
106: l_string VARCHAR2(4000);
107: l_skip_server VARCHAR2(4000);
108: x_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 111: cursor l_parties_cursor(l_geo HZ_LOCATIONS.GEOMETRY%TYPE

107: l_skip_server VARCHAR2(4000);
108: x_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
109:
110:
111: cursor l_parties_cursor(l_geo HZ_LOCATIONS.GEOMETRY%TYPE
112: ,l_dist_unit VARCHAR2
113: ,x_matched_id JTF_NUMBER_TABLE
114: ,p_distance NUMBER
115: ,p_customer_city VARCHAR2) is

Line 129: hz_locations hzl,

125: (SELECT column_value party_id FROM TABLE (CAST( x_matched_id AS JTF_NUMBER_TABLE)) ) p
126: ) tmp,
127: hz_parties org,
128: hz_party_sites hzs,
129: hz_locations hzl,
130: hz_contact_points cp,
131: pv_partner_profiles pvpp
132: where tmp.party_id = pvpp.partner_id
133: and org.party_id = pvpp.partner_party_id

Line 469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,

465: DISTANCE NUMBER,
466: --rownumber NUMBER,
467: PARTY_RELATION_ID NUMBER,
468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,

Line 470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,

466: --rownumber NUMBER,
467: PARTY_RELATION_ID NUMBER,
468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

Line 471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,

467: PARTY_RELATION_ID NUMBER,
468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

Line 472: CITY HZ_LOCATIONS.CITY%TYPE,

468: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
476: row_number NUMBER

Line 473: STATE HZ_LOCATIONS.STATE%TYPE,

469: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
476: row_number NUMBER
477: );

Line 474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

470: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
476: row_number NUMBER
477: );
478:

Line 475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

471: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
472: CITY HZ_LOCATIONS.CITY%TYPE,
473: STATE HZ_LOCATIONS.STATE%TYPE,
474: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
475: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
476: row_number NUMBER
477: );
478:
479:

Line 480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;

476: row_number NUMBER
477: );
478:
479:
480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;
481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;

Line 481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;

477: );
478:
479:
480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;
481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;

Line 482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;

478:
479:
480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;
481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;

Line 483: l_CITY HZ_LOCATIONS.CITY%TYPE;

479:
480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;
481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;
487:

Line 484: l_STATE HZ_LOCATIONS.STATE%TYPE;

480: l_ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE;
481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;
487:
488: l_partner_rec l_partner_rec_type;

Line 485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;

481: l_ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE;
482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;
487:
488: l_partner_rec l_partner_rec_type;
489: type cur_type IS REF CURSOR;

Line 486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;

482: l_ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE;
483: l_CITY HZ_LOCATIONS.CITY%TYPE;
484: l_STATE HZ_LOCATIONS.STATE%TYPE;
485: l_COUNTRY HZ_LOCATIONS.COUNTRY%TYPE;
486: l_POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE;
487:
488: l_partner_rec l_partner_rec_type;
489: type cur_type IS REF CURSOR;
490: l_parties_cursor cur_type;

Line 496: l_customer_geocode_object HZ_LOCATIONS.GEOMETRY%TYPE;

492: l_counter NUMBER :=0;
493: --l_return_partner_tbl party_address_rec_tbl;
494: l_return_final_partner_tbl party_address_rec_tbl;
495: l_customer_rec party_address_rec_type;
496: l_customer_geocode_object HZ_LOCATIONS.GEOMETRY%TYPE;
497: --l_partner_id_string VARCHAR2(2000):='';
498: l_query VARCHAR2(4000);
499: l_string VARCHAR2(4000);
500: l_max_no_partners NUMBER;

Line 506: from hz_locations hzl

502: l_partner_count NUMBER;
503:
504: CURSOR lc_geometry (pc_location_id number) IS
505: select hzl.geometry,hzl.address1,hzl.address2,hzl.address3,hzl.city,hzl.state,hzl.country,hzl.postal_code
506: from hz_locations hzl
507: where hzl.location_id =pc_location_id;
508:
509: l_count NUMBER;
510: l_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');

Line 717: ' hz_locations hzl, '||

713: ' hzl.postal_code, '||
714: ' rownum rn '||
715: ' from hz_parties org, ' ||
716: ' hz_party_sites hzs, ' ||
717: ' hz_locations hzl, '||
718: ' pv_partner_profiles pvpp, '||
719: ' (SELECT * ' ||
720: ' FROM (SELECT column_value party_id ' ||
721: ' FROM (SELECT column_value ' ||

Line 775: hz_locations hzl,

771: hzl.address2, hzl.address3, hzl.city, hzl.state, hzl.country,
772: hzl.postal_code, rownum rn
773: FROM hz_parties org,
774: hz_party_sites hzs,
775: hz_locations hzl,
776: pv_partner_profiles pvpp,
777: (SELECT *
778: FROM (SELECT column_value party_id
779: FROM (SELECT column_value