DBA Data[Home] [Help]

APPS.JTF_TTY_NA_TERRGP dependencies on HZ_LOCATIONS

Line 2835: HZ_LOCATIONS H1,

2831: INTO p_business_name,
2832: p_trade_name,
2833: p_postal_code
2834: FROM HZ_PARTIES H3,
2835: HZ_LOCATIONS H1,
2836: HZ_PARTY_SITES H2
2837: WHERE h3.party_id = h2.party_id
2838: AND h2.location_id = h1.location_id
2839: AND h3.party_id = p_party_id