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_CONTACT_USER_BATCH_PUB dependencies on HZ_RELATIONSHIPS

Line 327: select hzrp.party_id from hz_org_contacts hzoc, hz_relationships hzrp

323: SELECT CUST_ACCOUNT_ROLE_ID from hz_cust_account_roles where party_id=l_party_id;
324:
325:
326: CURSOR CHECK_RELATIONSHIP_EXIST(p_person_party_id NUMBER, p_partner_party_id NUMBER) IS
327: select hzrp.party_id from hz_org_contacts hzoc, hz_relationships hzrp
328: where hzoc.party_relationship_id = hzrp.relationship_id and
329: hzrp.relationship_code='EMPLOYEE_OF' and
330: hzrp.subject_id=p_person_party_id and
331: hzrp.object_id=p_partner_party_id

Line 1435: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';

1431: AND EFFECTIVE_START_DATE < SYSDATE;
1432:
1433:
1434: CURSOR get_relationship_code(rel_party_id NUMBER) IS
1435: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';
1436:
1437:
1438: CURSOR get_status(rel_party_id NUMBER) IS
1439: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;

Line 1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,

1447:
1448: cursor get_contact_details(rel_party_id NUMBER) IS
1449: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
1450: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
1452: hz_parties REL_HZP
1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'

Line 1470: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp

1466: and hzr.object_id = org_hzp.party_id and
1467: rel_hzp.party_id=hzr.party_id;
1468:
1469: CURSOR CHECK_CONTACT(rel_party_id VARCHAR2) is
1470: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp
1471: where rel.party_id=rel_party_id and
1472: hzr.party_id=rel.party_id and
1473: hzr.relationship_code in ('EMPLOYEE_OF' ) and
1474: hzr.object_id=pvpp.partner_party_id;

Line 2041: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';

2037: AND EFFECTIVE_START_DATE < SYSDATE;
2038:
2039:
2040: CURSOR get_relationship_code(rel_party_id NUMBER) IS
2041: select relationship_code from hz_relationships hzr where hzr.party_id=rel_party_id and hzr.directional_flag='F';
2042:
2043:
2044: CURSOR get_status(rel_party_id NUMBER) IS
2045: select hzp.status from hz_parties hzp where hzp.party_id=rel_party_id ;

Line 2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,

2053:
2054: cursor get_contact_details(rel_party_id NUMBER) IS
2055: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
2056: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
2058: hz_parties REL_HZP
2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'

Line 2076: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp, fnd_user fu

2072: and hzr.object_id = org_hzp.party_id and
2073: rel_hzp.party_id=hzr.party_id;
2074:
2075: CURSOR CHECK_CONTACT(rel_party_id VARCHAR2,l_user_name VARCHAR2) is
2076: select hzr.subject_id from hz_parties rel,hz_relationships hzr ,pv_partner_profiles pvpp, fnd_user fu
2077: where rel.party_id=rel_party_id and
2078: hzr.party_id=rel.party_id and
2079: hzr.relationship_code in ('EMPLOYEE_OF') and
2080: fu.user_name=l_user_name and