1111: AND hz.party_id = cp_party_id;
1112:
1113: CURSOR c_customer_details(cp_party_id IN NUMBER) IS
1114: SELECT hz.party_name, hzl.country, hzl.state
1115: FROM hz_parties hz, hz_party_sites hzs , hz_locations hzl
1116: WHERE hz.party_id = cp_party_id
1117: AND hzs.party_id = hz.party_id
1118: AND hzs.identifying_address_flag = 'Y'
1119: AND hzl.location_id = hzs.location_id;
4568: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,
4569: LCN.ADDRESS4,LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,
4570: NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1
4571: ),1,80) DESCRIPTION, NULL INV_ORG_ID
4572: FROM HZ_PARTY_SITES PSE,HZ_LOCATIONS LCN
4573: WHERE LCN.LOCATION_ID = PSE.LOCATION_ID
4574: AND LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
4575: UNION ALL
4576: SELECT 'OKX_PARTY' TYPE, P.PARTY_ID ID1, '#' ID2, P.PARTY_NAME NAME,