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.JTF_TTY_MAINTAIN_NA_PVT dependencies on HZ_PARTIES

Line 107: FROM hz_parties hzp

103:
104: --Cursor to validate party based on party number : Single Row
105: CURSOR c_validate_party(l_party_number VARCHAR2, l_party_site_id NUMBER) IS
106: SELECT hzp.party_id
107: FROM hz_parties hzp
108: , hz_party_sites hzps
109: WHERE hzp.party_number = l_party_number
110: AND hzp.party_id = hzps.party_id
111: and hzps.party_site_id = l_party_site_id

Line 375: WHERE hzr.subject_table_name = 'HZ_PARTIES'

371: BEGIN
372: SELECT 'Y' INTO l_chk_done FROM DUAL
373: WHERE EXISTS (SELECT 'Y'
374: FROM hz_relationships hzr
375: WHERE hzr.subject_table_name = 'HZ_PARTIES'
376: AND hzr.object_table_name = 'HZ_PARTIES'
377: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
378: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'
379: AND hzr.status = 'A'

Line 376: AND hzr.object_table_name = 'HZ_PARTIES'

372: SELECT 'Y' INTO l_chk_done FROM DUAL
373: WHERE EXISTS (SELECT 'Y'
374: FROM hz_relationships hzr
375: WHERE hzr.subject_table_name = 'HZ_PARTIES'
376: AND hzr.object_table_name = 'HZ_PARTIES'
377: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
378: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'
379: AND hzr.status = 'A'
380: AND sysdate between hzr.start_date and nvl(hzr.end_date, sysdate)

Line 397: WHERE hzr.subject_table_name = 'HZ_PARTIES'

393: BEGIN
394: SELECT 'Y' INTO l_chk_done FROM DUAL
395: WHERE EXISTS (SELECT 'Y'
396: FROM hz_relationships hzr
397: WHERE hzr.subject_table_name = 'HZ_PARTIES'
398: AND hzr.object_table_name = 'HZ_PARTIES'
399: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
400: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'
401: AND hzr.status = 'A'

Line 398: AND hzr.object_table_name = 'HZ_PARTIES'

394: SELECT 'Y' INTO l_chk_done FROM DUAL
395: WHERE EXISTS (SELECT 'Y'
396: FROM hz_relationships hzr
397: WHERE hzr.subject_table_name = 'HZ_PARTIES'
398: AND hzr.object_table_name = 'HZ_PARTIES'
399: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
400: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'
401: AND hzr.status = 'A'
402: AND sysdate between hzr.start_date and nvl(hzr.end_date, sysdate)

Line 416: FROM fnd_lookups lkp, hz_parties hzp

412: END IF;
413:
414: BEGIN
415: SELECT lkp.lookup_code INTO l_site_type_code
416: FROM fnd_lookups lkp, hz_parties hzp
417: WHERE lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
418: AND hzp.hq_branch_ind = lkp.lookup_code
419: AND hzp.party_id = p_party_id;
420:

Line 461: FROM HZ_PARTIES H3,

457: H1.postal_code
458: INTO l_business_name,
459: l_trade_name,
460: l_postal_code
461: FROM HZ_PARTIES H3,
462: HZ_LOCATIONS H1,
463: HZ_PARTY_SITES H2
464: WHERE h3.party_id = h2.party_id
465: AND h2.location_id = h1.location_id

Line 617: FROM hz_parties hzp

613: --Cursor to validate party based on party number : Single Row
614: CURSOR c_validate_party(l_party_number VARCHAR2, l_party_site_id NUMBER) IS
615:
616: SELECT hzp.party_id, hzp.duns_number_c
617: FROM hz_parties hzp
618: , hz_party_sites hzps
619: WHERE hzp.party_number = l_party_number
620: AND hzp.party_id = hzps.party_id
621: and hzps.party_site_id = l_party_site_id

Line 1744: and hzr.subject_table_name = 'HZ_PARTIES'

1740: jtf_tty_named_accts nao,
1741: jtf_tty_terr_grp_accts gao
1742: where gao.named_account_id = nao.named_account_id
1743: and nao.party_id = hzr.object_id -- these are the subsidiary parties
1744: and hzr.subject_table_name = 'HZ_PARTIES'
1745: and hzr.object_table_name = 'HZ_PARTIES'
1746: and hzr.relationship_code IN ( 'GLOBAL_ULTIMATE_OF', 'HEADQUARTERS_OF', 'DOMESTIC_ULTIMATE_OF', 'PARENT_OF' )
1747: and hzr.status = 'A'
1748: and sysdate between hzr.start_date and nvl( hzr.end_date, sysdate)

Line 1745: and hzr.object_table_name = 'HZ_PARTIES'

1741: jtf_tty_terr_grp_accts gao
1742: where gao.named_account_id = nao.named_account_id
1743: and nao.party_id = hzr.object_id -- these are the subsidiary parties
1744: and hzr.subject_table_name = 'HZ_PARTIES'
1745: and hzr.object_table_name = 'HZ_PARTIES'
1746: and hzr.relationship_code IN ( 'GLOBAL_ULTIMATE_OF', 'HEADQUARTERS_OF', 'DOMESTIC_ULTIMATE_OF', 'PARENT_OF' )
1747: and hzr.status = 'A'
1748: and sysdate between hzr.start_date and nvl( hzr.end_date, sysdate)
1749: and hzr.subject_id = nai.party_id -- this is the parent party

Line 3362: from hz_party_sites party_site, hz_parties party

3358: elsif ((p_party_site_id is null or trim(p_party_site_id) is null ) and (trim(l_matching_rule_code) <> '1' or trim(l_matching_rule_code) <> '2' or trim(l_matching_rule_code) <> '5'))
3359: then
3360:
3361: select party_site_id into l_party_site_id
3362: from hz_party_sites party_site, hz_parties party
3363: where party.party_number = p_party_number
3364: and party.party_id = party_site.party_id
3365: and party_site.status = 'A'
3366: and party_site.identifying_address_flag = 'Y';