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 818: hz_parties hp1,

814: FROM dual
815: WHERE p_customer_id IN (
816: select hca.cust_account_id
817: from hz_relationships hr,
818: hz_parties hp1,
819: hz_parties hp2,
820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id
822: and hr.object_id = hp2.party_id

Line 819: hz_parties hp2,

815: WHERE p_customer_id IN (
816: select hca.cust_account_id
817: from hz_relationships hr,
818: hz_parties hp1,
819: hz_parties hp2,
820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id
822: and hr.object_id = hp2.party_id
823: and subject_table_name = 'HZ_PARTIES'

Line 823: and subject_table_name = 'HZ_PARTIES'

819: hz_parties hp2,
820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id
822: and hr.object_id = hp2.party_id
823: and subject_table_name = 'HZ_PARTIES'
824: and object_table_name = 'HZ_PARTIES'
825: and hr.relationship_type IN ( 'EMPLOYMENT', 'CONTACT')
826: and hr.subject_id = p_person_party_id
827: and hca.party_id = hp2.party_id);

Line 824: and object_table_name = 'HZ_PARTIES'

820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id
822: and hr.object_id = hp2.party_id
823: and subject_table_name = 'HZ_PARTIES'
824: and object_table_name = 'HZ_PARTIES'
825: and hr.relationship_type IN ( 'EMPLOYMENT', 'CONTACT')
826: and hr.subject_id = p_person_party_id
827: and hca.party_id = hp2.party_id);
828:

Line 968: HZ_PARTIES PARTY,

964: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
965: substrb(PARTY.PERSON_LAST_NAME,1,50)
966: INTO l_contact_name
967: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
968: HZ_PARTIES PARTY,
969: HZ_RELATIONSHIPS REL
970: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
971: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
972: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 973: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

969: HZ_RELATIONSHIPS REL
970: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
971: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
972: AND REL.SUBJECT_ID = PARTY.PARTY_ID
973: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
974: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
975: AND DIRECTIONAL_FLAG = 'F';
976: --
977: END IF;

Line 974: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

970: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
971: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
972: AND REL.SUBJECT_ID = PARTY.PARTY_ID
973: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
974: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
975: AND DIRECTIONAL_FLAG = 'F';
976: --
977: END IF;
978:

Line 1020: HZ_PARTIES PARTY,

1016: SELECT LTRIM(substrb(PARTY.PERSON_FIRST_NAME,1,40) || ' ') ||
1017: substrb(PARTY.PERSON_LAST_NAME,1,50)
1018: INTO l_contact_name
1019: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1020: HZ_PARTIES PARTY,
1021: HZ_RELATIONSHIPS REL
1022: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1023: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1024: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 1025: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1021: HZ_RELATIONSHIPS REL
1022: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1023: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1024: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1025: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1026: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
1027: AND DIRECTIONAL_FLAG = 'F';
1028: END IF;
1029:

Line 1026: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

1022: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1023: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1024: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1025: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1026: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
1027: AND DIRECTIONAL_FLAG = 'F';
1028: END IF;
1029:
1030: RETURN l_contact_name;

Line 1082: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

1078: HZ_CONTACT_POINTS CONT_POINT
1079: WHERE
1080: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1081: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1082: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
1083: AND CONT_POINT.STATUS = 'A'
1084: AND INSTRB(NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) || 'ALL', p_phone_type) > 0
1085: AND CONT_POINT.PRIMARY_FLAG = p_primary_flag
1086: )

Line 1169: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

1165: HZ_CONTACT_POINTS CONT_POINT
1166: WHERE
1167: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1168: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1169: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
1170: AND CONT_POINT.STATUS = 'A'
1171: AND INSTRB(NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) || 'ALL', p_phone_type) > 0
1172: AND CONT_POINT.PRIMARY_FLAG = p_primary_flag
1173: )

Line 2083: l_customer_acct_name hz_parties.party_name%TYPE;

2079:
2080: l_customer_id NUMBER(15) := NULL;
2081: l_customer_acct_site_id NUMBER(15) := NULL;
2082: l_customer_acct_number NUMBER(15) := NULL;
2083: l_customer_acct_name hz_parties.party_name%TYPE;
2084:
2085:
2086: l_procedure_name VARCHAR2(30) := '.invoke_invoice_email_notwf';
2087: l_debug_info VARCHAR2(500);

Line 2133: from hz_parties hp,hz_cust_accounts hca

2129: and sites.site_use_id = aps.customer_site_use_id;
2130:
2131: select hp.party_name,hca.account_number
2132: into l_customer_acct_name,l_customer_acct_number
2133: from hz_parties hp,hz_cust_accounts hca
2134: where hp.party_id = hca.party_id
2135: and hca.cust_account_id = l_customer_id;
2136:
2137: IF (PG_DEBUG = 'Y') THEN

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

2246:
2247: CURSOR contact_cur(p_customer_id IN NUMBER ,
2248: p_customer_acct_site_id IN NUMBER ) IS
2249: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
2250: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
2252: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
2253: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
2254: and hrr.cust_account_role_id = hcar.cust_account_role_id

Line 2277: AND cont_point.owner_table_name = 'HZ_PARTIES'

2273: FROM hz_cust_account_roles acct_role,
2274: hz_contact_points cont_point
2275: WHERE acct_role.cust_account_role_id =l_contact_id
2276: AND acct_role.party_id = cont_point.owner_table_id
2277: AND cont_point.owner_table_name = 'HZ_PARTIES'
2278: AND cont_point.status = 'A'
2279: AND cont_point.email_Address is not null;
2280:
2281: contact_rec contact_cur%ROWTYPE;