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

Line 767: hz_parties CONTACT ,

763: SELECT 'Y'
764: FROM
765: pv_partner_profiles PROFILE,
766: hz_relationships HZPR_PART_CONT ,
767: hz_parties CONTACT ,
768: jtf_rs_resource_extns RES
769: WHERE
770: PROFILE.partner_id = cv_partner_id
771: AND PROFILE.partner_party_id = HZPR_PART_CONT.object_id

Line 773: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

769: WHERE
770: PROFILE.partner_id = cv_partner_id
771: AND PROFILE.partner_party_id = HZPR_PART_CONT.object_id
772: AND HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
773: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
774: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'
775: AND HZPR_PART_CONT.status = 'A'
776: AND HZPR_PART_CONT.start_date <= SYSDATE
777: AND NVL(HZPR_PART_CONT.end_date,SYSDATE) >= SYSDATE

Line 774: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'

770: PROFILE.partner_id = cv_partner_id
771: AND PROFILE.partner_party_id = HZPR_PART_CONT.object_id
772: AND HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
773: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
774: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'
775: AND HZPR_PART_CONT.status = 'A'
776: AND HZPR_PART_CONT.start_date <= SYSDATE
777: AND NVL(HZPR_PART_CONT.end_date,SYSDATE) >= SYSDATE
778: AND HZPR_PART_CONT.subject_id = CONTACT.PARTY_ID

Line 1834: HZ_PARTIES PARTY

1830: upper(PARTY.party_name) party_name,
1831: PARTY.category_code category_code,
1832: PARTY.curr_fy_potential_revenue annual_revenue
1833: FROM HZ_PARTY_SITES SITE,
1834: HZ_PARTIES PARTY
1835: WHERE SITE.status = 'A'
1836: AND SITE.identifying_address_flag = 'Y'
1837: AND PARTY.party_id = cv_party_id
1838: AND SITE.party_id = PARTY.party_id

Line 1859: HZ_PARTIES PARTY

1855: PARTY.curr_fy_potential_revenue annual_revenue
1856: FROM HZ_PARTY_SITES SITE,
1857: HZ_CONTACT_POINTS CNTPNT,
1858: HZ_LOCATIONS LOC,
1859: HZ_PARTIES PARTY
1860: WHERE SITE.status = 'A'
1861: AND SITE.identifying_address_flag = 'Y'
1862: AND PARTY.party_id = cv_party_id
1863: AND SITE.party_id = PARTY.party_id

Line 1887: HZ_PARTIES PARTY

1883: upper(PARTY.party_name) party_name,
1884: PARTY.category_code category_code,
1885: PARTY.curr_fy_potential_revenue annual_revenue
1886: FROM HZ_CONTACT_POINTS CP,
1887: HZ_PARTIES PARTY
1888: WHERE CP.owner_table_name(+) = 'HZ_PARTIES'
1889: AND CP.owner_table_id(+) = PARTY.party_id
1890: AND PARTY.party_id = cv_party_id
1891: AND PARTY.party_type = 'ORGANIZATION'

Line 1888: WHERE CP.owner_table_name(+) = 'HZ_PARTIES'

1884: PARTY.category_code category_code,
1885: PARTY.curr_fy_potential_revenue annual_revenue
1886: FROM HZ_CONTACT_POINTS CP,
1887: HZ_PARTIES PARTY
1888: WHERE CP.owner_table_name(+) = 'HZ_PARTIES'
1889: AND CP.owner_table_id(+) = PARTY.party_id
1890: AND PARTY.party_id = cv_party_id
1891: AND PARTY.party_type = 'ORGANIZATION'
1892: AND PARTY.status = 'A'

Line 4651: hz_parties CONTACT ,

4647: SELECT DISTINCT
4648: RES.resource_id
4649: FROM
4650: hz_relationships HZPR_PART_CONT ,
4651: hz_parties CONTACT ,
4652: jtf_rs_resource_extns RES ,
4653: jtf_rs_group_members GRPMEM,
4654: jtf_rs_group_usages GRPUSG,
4655: jtf_rs_role_relations ROLRELAT ,

Line 4658: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4654: jtf_rs_group_usages GRPUSG,
4655: jtf_rs_role_relations ROLRELAT ,
4656: jtf_rs_roles_vl ROLE
4657: WHERE HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
4658: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4659: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4660: AND HZPR_PART_CONT.status = 'A'
4661: AND HZPR_PART_CONT.start_date <= SYSDATE
4662: AND NVL(HZPR_PART_CONT.end_date,SYSDATE) >= SYSDATE

Line 4659: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4655: jtf_rs_role_relations ROLRELAT ,
4656: jtf_rs_roles_vl ROLE
4657: WHERE HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
4658: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4659: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4660: AND HZPR_PART_CONT.status = 'A'
4661: AND HZPR_PART_CONT.start_date <= SYSDATE
4662: AND NVL(HZPR_PART_CONT.end_date,SYSDATE) >= SYSDATE
4663: AND HZPR_PART_CONT.object_id = cv_vad_party_id

Line 5457: HZ_PARTIES hzp

5453: --New
5454: SELECT hzp.party_name partner_name,ptbcp.partner_id, ptbcp.vad_partner_id, ptbcp.object_version_number,ptbcp.created_by
5455: FROM PV_TAP_BATCH_CHG_PARTNERS ptbcp,
5456: PV_PARTNER_PROFILES ppp,
5457: HZ_PARTIES hzp
5458: WHERE ptbcp.PROCESSED_FLAG = 'P'
5459: -- AND ptbcp.PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id
5460: AND ptbcp.PARTNER_ID >= cv_first_partner_id AND ptbcp.PARTNER_ID <= cv_last_partner_id
5461: AND ptbcp.partner_id = ppp.partner_id

Line 5478: HZ_PARTIES hzp

5474: --New
5475: SELECT distinct hzp.party_name partner_name, partner_id,
5476: NULL "vad_partner_id", NULL "object_version_number" , ppp.created_by
5477: FROM PV_PARTNER_PROFILES ppp,
5478: HZ_PARTIES hzp
5479: WHERE ppp.partner_party_id = hzp.party_id
5480: -- AND ppp.PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5481: AND ppp.PARTNER_ID >= cv_first_partner_id AND ppp.PARTNER_ID <= cv_last_partner_id
5482: AND ppp.STATUS = 'A'

Line 6219: HZ_PARTIES hzp

6215: -- territories.
6216: CURSOR l_prof_partner_info_csr(cv_partner_id NUMBER) IS
6217: SELECT distinct hzp.party_name partner_name
6218: FROM PV_PARTNER_PROFILES ppp,
6219: HZ_PARTIES hzp
6220: WHERE ppp.partner_id = cv_partner_id
6221: AND ppp.partner_party_id = hzp.party_id
6222: AND ppp.STATUS = 'A';
6223: -- order by hzp.party_name;