APPS.IEX_TERR_PUB dependencies on HZ_PARTIES

Line 898: l_party_name hz_parties.party_name%type;

894: l_where varchar2(240);
895: Type refCur is Ref Cursor;
896: l_curs refCur;
897:
898: l_party_name hz_parties.party_name%type;
899: l_account_name hz_cust_accounts.account_name%type;
900: l_address1 varchar2(240);
901: l_city varchar2(240);
902: l_state varchar2(240);

Line 937: ' hz_parties party, ' ||

933: ' phone.phone_number phone_number, ' ||
934: ' phone.phone_extension phone_extension ' ||
935: ' FROM ' ||
936: ' hz_cust_accounts acc, ' ||
937: ' hz_parties party, ' ||
938: ' fnd_territories_tl fnd_terr, ' ||
939: ' hz_contact_points phone ' ||
940: ' WHERE ' ||
941: ' acc.party_id = party.party_id ' ||

Line 943: ' AND phone.owner_table_name(+) = ''HZ_PARTIES'' ' ||

939: ' hz_contact_points phone ' ||
940: ' WHERE ' ||
941: ' acc.party_id = party.party_id ' ||
942: ' AND phone.owner_table_id(+) = party.party_id ' ||
943: ' AND phone.owner_table_name(+) = ''HZ_PARTIES'' ' ||
944: ' AND phone.contact_point_type(+) = ''PHONE'' ' ||
945: ' AND phone.primary_by_purpose(+) = ''Y'' ' ||
946: ' AND phone.contact_point_purpose(+) = ''COLLECTIONS'' ' ||
947: ' AND phone.phone_line_type(+) NOT IN(''PAGER'', ''FAX'') ' ||