DBA Data[Home] [Help]

APPS.JTF_TERR_NA_MERGE_PUB dependencies on HZ_LOCATIONS

Line 73: HZ_LOCATIONS H1,

69: INTO p_business_name,
70: p_trade_name,
71: p_postal_code
72: FROM HZ_PARTIES H3,
73: HZ_LOCATIONS H1,
74: HZ_PARTY_SITES H2
75: WHERE h3.party_id = h2.party_id
76: AND h2.location_id = h1.location_id
77: AND h3.party_id = p_party_id