APPS.FTE_MLS_UTIL dependencies on HZ_PARTIES

Line 1403: FROM hz_parties hz, wsh_carriers wc

1399: --{
1400: CURSOR get_carrier_name_cur(c_carrier_id NUMBER)
1401: IS
1402: SELECT hz.party_name name
1403: FROM hz_parties hz, wsh_carriers wc
1404: WHERE hz.party_id = wc.carrier_id
1405: AND wc.carrier_id = c_carrier_id;
1406: --}
1407: BEGIN

Line 1708: hz_parties party_rel

1704: hz_relationships rel,
1705: hz_party_sites hps,
1706: hz_org_contacts hoc,
1707: hz_contact_points hcp,
1708: hz_parties party_rel
1709: WHERE
1710: hps.party_id = rel.object_id and
1711: hps.party_site_id = hoc.party_site_id and
1712: hoc.party_relationship_id = rel.relationship_id and

Line 1715: hcp.owner_table_name = 'HZ_PARTIES' and

1711: hps.party_site_id = hoc.party_site_id and
1712: hoc.party_relationship_id = rel.relationship_id and
1713: party_rel.party_id = rel.subject_id and
1714: hcp.owner_table_id = rel.party_id and
1715: hcp.owner_table_name = 'HZ_PARTIES' and
1716: rel.party_id = c_contact_id;
1717:
1718: --{
1719: BEGIN

Line 1984: hz_parties hp

1980: fu.fax as fax,
1981: nvl(hp.party_name,fu.user_name) as name,
1982: hp.primary_phone_number as phone
1983: FROM fnd_user fu,
1984: hz_parties hp
1985: WHERE fu.person_party_id = hp.party_id(+)
1986: and fu.user_name = c_shipper_username;
1987:
1988: --{