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

Line 776: hz_parties hp1,

772: FROM dual
773: WHERE p_customer_id IN (
774: select hca.cust_account_id
775: from hz_relationships hr,
776: hz_parties hp1,
777: hz_parties hp2,
778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id
780: and hr.object_id = hp2.party_id

Line 777: hz_parties hp2,

773: WHERE p_customer_id IN (
774: select hca.cust_account_id
775: from hz_relationships hr,
776: hz_parties hp1,
777: hz_parties hp2,
778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id
780: and hr.object_id = hp2.party_id
781: and subject_table_name = 'HZ_PARTIES'

Line 781: and subject_table_name = 'HZ_PARTIES'

777: hz_parties hp2,
778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id
780: and hr.object_id = hp2.party_id
781: and subject_table_name = 'HZ_PARTIES'
782: and object_table_name = 'HZ_PARTIES'
783: and hr.relationship_type IN ( 'EMPLOYMENT', 'CONTACT')
784: and hr.subject_id = p_person_party_id
785: and hca.party_id = hp2.party_id);

Line 782: and object_table_name = 'HZ_PARTIES'

778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id
780: and hr.object_id = hp2.party_id
781: and subject_table_name = 'HZ_PARTIES'
782: and object_table_name = 'HZ_PARTIES'
783: and hr.relationship_type IN ( 'EMPLOYMENT', 'CONTACT')
784: and hr.subject_id = p_person_party_id
785: and hca.party_id = hp2.party_id);
786:

Line 926: HZ_PARTIES PARTY,

922: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
923: substrb(PARTY.PERSON_LAST_NAME,1,50)
924: INTO l_contact_name
925: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
926: HZ_PARTIES PARTY,
927: HZ_RELATIONSHIPS REL
928: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
929: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
930: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 931: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

927: HZ_RELATIONSHIPS REL
928: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
929: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
930: AND REL.SUBJECT_ID = PARTY.PARTY_ID
931: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
932: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
933: AND DIRECTIONAL_FLAG = 'F';
934: --
935: END IF;

Line 932: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

928: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
929: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
930: AND REL.SUBJECT_ID = PARTY.PARTY_ID
931: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
932: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
933: AND DIRECTIONAL_FLAG = 'F';
934: --
935: END IF;
936:

Line 978: HZ_PARTIES PARTY,

974: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
975: substrb(PARTY.PERSON_LAST_NAME,1,50)
976: INTO l_contact_name
977: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
978: HZ_PARTIES PARTY,
979: HZ_RELATIONSHIPS REL
980: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
981: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
982: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 983: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

979: HZ_RELATIONSHIPS REL
980: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
981: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
982: AND REL.SUBJECT_ID = PARTY.PARTY_ID
983: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
984: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
985: AND DIRECTIONAL_FLAG = 'F';
986: END IF;
987:

Line 984: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

980: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
981: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
982: AND REL.SUBJECT_ID = PARTY.PARTY_ID
983: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
984: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
985: AND DIRECTIONAL_FLAG = 'F';
986: END IF;
987:
988: RETURN l_contact_name;

Line 1039: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

1035: HZ_CONTACT_POINTS CONT_POINT
1036: WHERE
1037: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1038: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1039: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
1040: AND CONT_POINT.STATUS = 'A'
1041: AND INSTRB(NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) || 'ALL', p_phone_type) > 0
1042: AND CONT_POINT.PRIMARY_FLAG = p_primary_flag
1043: )

Line 1126: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

1122: HZ_CONTACT_POINTS CONT_POINT
1123: WHERE
1124: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1125: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1126: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
1127: AND CONT_POINT.STATUS = 'A'
1128: AND INSTRB(NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) || 'ALL', p_phone_type) > 0
1129: AND CONT_POINT.PRIMARY_FLAG = p_primary_flag
1130: )

Line 1813: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,

1809:
1810: CURSOR contact_cur(p_customer_id IN NUMBER DEFAULT NULL,
1811: p_customer_acct_site_id IN NUMBER DEFAULT NULL ) IS
1812: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
1813: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
1814: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
1815: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
1816: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
1817: and hrr.cust_account_role_id = hcar.cust_account_role_id

Line 1840: AND cont_point.owner_table_name = 'HZ_PARTIES'

1836: FROM hz_cust_account_roles acct_role,
1837: hz_contact_points cont_point
1838: WHERE acct_role.cust_account_role_id =l_contact_id
1839: AND acct_role.party_id = cont_point.owner_table_id
1840: AND cont_point.owner_table_name = 'HZ_PARTIES'
1841: AND cont_point.status = 'A'
1842: AND cont_point.email_Address is not null;
1843:
1844: contact_rec contact_cur%ROWTYPE;