eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TRN_VALIDATION_PKG dependencies on HZ_PARTY_SITES

Line 176: hz_party_sites hzps

172: FROM zx_registrations
173: WHERE party_tax_profile_id = (SELECT s.party_tax_profile_id
174: FROM zx_party_tax_profile s,
175: zx_party_tax_profile ptp,
176: hz_party_sites hzps
177: where ptp.party_tax_profile_id = c_ptp_id
178: and ptp.party_id = hzps.party_site_id
179: and hzps.party_id = s.party_id
180: and s.party_type_code = 'THIRD_PARTY')

Line 304: hz_party_sites ps

300:
301: SELECT distinct p.party_name, nvl(ps.party_site_name, p.address1||' '||p.address2||' '||p.address3||' '||p.address4||' '||p.city||' '||p.state) party_site_name
302: INTO l_party_name, l_party_site_name
303: FROM hz_parties p,
304: hz_party_sites ps
305: WHERE p.party_id = ps.party_id
306: AND ps.party_site_id = l_party_id;
307:
308: if x_party_name_token is null then

Line 408: HZ_PARTY_SITES HZS,

404: HZP.CITY||' '||
405: HZP.STATE) PARTY_SITE_NAME
406: INTO l_party_name, l_party_site_name
407: FROM ZX_REGISTRATIONS REG,
408: HZ_PARTY_SITES HZS,
409: HZ_PARTIES HZP,
410: ZX_PARTY_TAX_PROFILE ZXP
411: WHERE HZP.PARTY_ID = HZS.PARTY_ID
412: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID

Line 418: HZ_PARTY_SITES HZPS

414: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
415: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
416: FROM ZX_PARTY_TAX_PROFILE S,
417: ZX_PARTY_TAX_PROFILE PTP,
418: HZ_PARTY_SITES HZPS
419: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
420: AND PTP.PARTY_ID = HZPS.PARTY_ID
421: AND HZPS.PARTY_SITE_ID = S.PARTY_ID
422: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE')

Line 463: HZ_PARTY_SITES HZPS

459: AND REG.PARTY_TAX_PROFILE_ID NOT IN
460: (SELECT S.PARTY_TAX_PROFILE_ID
461: FROM ZX_PARTY_TAX_PROFILE S,
462: ZX_PARTY_TAX_PROFILE PTP,
463: HZ_PARTY_SITES HZPS
464: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
465: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
466: AND HZPS.PARTY_ID = S.PARTY_ID
467: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY')

Line 695: hz_party_sites hzs,

691: and ptp.party_type_code = p_party_type_code
692: and ptp.party_tax_profile_id <> p_ptp_id
693: and not exists (SELECT 1
694: FROM zx_party_tax_profile reg,
695: hz_party_sites hzs,
696: hz_party_sites hzr
697: where reg.party_tax_profile_id = p_ptp_id
698: and ptp.party_id = hzs.party_site_id
699: and reg.party_id = hzr.party_site_id

Line 696: hz_party_sites hzr

692: and ptp.party_tax_profile_id <> p_ptp_id
693: and not exists (SELECT 1
694: FROM zx_party_tax_profile reg,
695: hz_party_sites hzs,
696: hz_party_sites hzr
697: where reg.party_tax_profile_id = p_ptp_id
698: and ptp.party_id = hzs.party_site_id
699: and reg.party_id = hzr.party_site_id
700: and hzs.party_id = hzr.party_id);

Line 725: hz_party_sites ps

721: nvl(ps.party_site_name, p.address1||' '||p.address2||' '||
722: p.address3||' '||p.address4||' '||p.city||' '||p.state) party_site_name
723: INTO l_party_name, l_party_site_name
724: FROM hz_parties p,
725: hz_party_sites ps
726: WHERE p.party_id = ps.party_id
727: AND ps.party_site_id = l_party_id;
728:
729: if x_party_name_token is null then

Line 815: HZ_PARTY_SITES HZPS

811: SELECT count(S.PARTY_TAX_PROFILE_ID)
812: INTO l_specific_count
813: FROM ZX_PARTY_TAX_PROFILE S,
814: ZX_PARTY_TAX_PROFILE PTP,
815: HZ_PARTY_SITES HZPS
816: WHERE PTP.PARTY_TAX_PROFILE_ID = P_PTP_ID
817: AND PTP.PARTY_ID = HZPS.PARTY_ID
818: AND HZPS.PARTY_SITE_ID = S.PARTY_ID
819: AND S.REP_REGISTRATION_NUMBER = P_TAX_REG_NUM

Line 843: FROM HZ_PARTY_SITES HZS,

839: HZP.ADDRESS4||' '||
840: HZP.CITY||' '||
841: HZP.STATE) PARTY_SITE_NAME
842: INTO l_ptp_id,l_party_name, l_party_site_name
843: FROM HZ_PARTY_SITES HZS,
844: HZ_PARTIES HZP,
845: ZX_PARTY_TAX_PROFILE ZXP
846: WHERE HZP.PARTY_ID = HZS.PARTY_ID
847: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID

Line 851: HZ_PARTY_SITES HZPS

847: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
848: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
849: AND NOT EXISTS (SELECT PTP.PARTY_TAX_PROFILE_ID
850: FROM ZX_PARTY_TAX_PROFILE PTP,
851: HZ_PARTY_SITES HZPS
852: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
853: AND PTP.PARTY_ID = HZPS.PARTY_ID(+)
854: AND (HZPS.PARTY_SITE_ID IS NULL
855: OR HZPS.PARTY_SITE_ID = ZXP.PARTY_ID))

Line 894: hz_party_sites hzps

890: SELECT count(s.party_tax_profile_id)
891: into l_specific_count
892: FROM zx_party_tax_profile s,
893: zx_party_tax_profile ptp,
894: hz_party_sites hzps
895: where ptp.party_tax_profile_id = p_ptp_id
896: and ptp.party_id = hzps.party_site_id
897: and hzps.party_id = s.party_id
898: and ptp.rep_registration_number = p_tax_reg_num

Line 923: HZ_PARTY_SITES HZPS

919: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
920: AND NOT EXISTS (SELECT S.PARTY_TAX_PROFILE_ID
921: FROM ZX_PARTY_TAX_PROFILE S,
922: ZX_PARTY_TAX_PROFILE PTP,
923: HZ_PARTY_SITES HZPS
924: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
925: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
926: AND HZPS.PARTY_ID = S.PARTY_ID
927: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY'

Line 1259: HZ_PARTY_SITES HZPS

1255: WHERE REG.PARTY_TAX_PROFILE_ID IN
1256: (SELECT S.PARTY_TAX_PROFILE_ID
1257: FROM ZX_PARTY_TAX_PROFILE S,
1258: ZX_PARTY_TAX_PROFILE PTP,
1259: HZ_PARTY_SITES HZPS
1260: WHERE PTP.PARTY_TAX_PROFILE_ID = G_PTP_ID
1261: AND PTP.PARTY_ID = HZPS.PARTY_ID
1262: AND HZPS.PARTY_SITE_ID = S.PARTY_ID
1263: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE')