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_PARTNER_UTIL_PVT dependencies on HZ_PARTIES

Line 262: hz_parties PARTNER,

258: UNION all
259: SELECT 11 attribute_id, UPPER(PARTNER.party_name) attr_text ,PVPP.partner_id partner_id
260: FROM hz_organization_profiles HZOP_PRT,
261: pv_enty_attr_values PEAV,
262: hz_parties PARTNER,
263: hz_organization_profiles HZOP,
264: hz_parties INTERNAL,
265: hz_relationships HZR,
266: pv_partner_profiles PVPP

Line 264: hz_parties INTERNAL,

260: FROM hz_organization_profiles HZOP_PRT,
261: pv_enty_attr_values PEAV,
262: hz_parties PARTNER,
263: hz_organization_profiles HZOP,
264: hz_parties INTERNAL,
265: hz_relationships HZR,
266: pv_partner_profiles PVPP
267: WHERE HZR.party_id = PVPP.partner_id
268: AND HZR.object_id = INTERNAL.party_id

Line 271: AND HZR.subject_table_name = ''HZ_PARTIES''

267: WHERE HZR.party_id = PVPP.partner_id
268: AND HZR.object_id = INTERNAL.party_id
269: AND HZR.subject_id = PVPP.partner_party_id
270: AND HZR.subject_id = PARTNER.party_id
271: AND HZR.subject_table_name = ''HZ_PARTIES''
272: AND HZR.object_table_name = ''HZ_PARTIES''
273: AND HZR.subject_type = ''ORGANIZATION''
274: AND HZR.object_type = ''ORGANIZATION''
275: AND HZR.RELATIONSHIP_TYPE IN (''PARTNER'',''PARTNER_MANAGED_CUSTOMER'')

Line 272: AND HZR.object_table_name = ''HZ_PARTIES''

268: AND HZR.object_id = INTERNAL.party_id
269: AND HZR.subject_id = PVPP.partner_party_id
270: AND HZR.subject_id = PARTNER.party_id
271: AND HZR.subject_table_name = ''HZ_PARTIES''
272: AND HZR.object_table_name = ''HZ_PARTIES''
273: AND HZR.subject_type = ''ORGANIZATION''
274: AND HZR.object_type = ''ORGANIZATION''
275: AND HZR.RELATIONSHIP_TYPE IN (''PARTNER'',''PARTNER_MANAGED_CUSTOMER'')
276: AND INTERNAL.PARTY_TYPE=''ORGANIZATION''

Line 457: -- in HZ_PARTIES table for the supplied organization.

453: PVX_UTILITY_PVT.debug_message( 'Public API: Calling create Organization API');
454: END IF;
455:
456: -- Call HZ_PARTY_V2PUB.Create_Organization API, for creating a Party record
457: -- in HZ_PARTIES table for the supplied organization.
458:
459: HZ_PARTY_V2PUB.Create_organization (
460: p_init_msg_list => FND_API.G_FALSE,
461: p_organization_rec => p_organization_rec,

Line 635: hz_parties PARTNER,

631: UNION all
632: SELECT 11 attribute_id, UPPER(PARTNER.party_name) attr_text ,PVPP.partner_id partner_id
633: FROM hz_organization_profiles HZOP_PRT,
634: pv_enty_attr_values PEAV,
635: hz_parties PARTNER,
636: hz_organization_profiles HZOP,
637: hz_parties INTERNAL,
638: hz_relationships HZR,
639: pv_partner_profiles PVPP

Line 637: hz_parties INTERNAL,

633: FROM hz_organization_profiles HZOP_PRT,
634: pv_enty_attr_values PEAV,
635: hz_parties PARTNER,
636: hz_organization_profiles HZOP,
637: hz_parties INTERNAL,
638: hz_relationships HZR,
639: pv_partner_profiles PVPP
640: WHERE HZR.party_id = PVPP.partner_id
641: AND HZR.object_id = INTERNAL.party_id

Line 644: AND HZR.subject_table_name = ''HZ_PARTIES''

640: WHERE HZR.party_id = PVPP.partner_id
641: AND HZR.object_id = INTERNAL.party_id
642: AND HZR.subject_id = PVPP.partner_party_id
643: AND HZR.subject_id = PARTNER.party_id
644: AND HZR.subject_table_name = ''HZ_PARTIES''
645: AND HZR.object_table_name = ''HZ_PARTIES''
646: AND HZR.subject_type = ''ORGANIZATION''
647: AND HZR.object_type = ''ORGANIZATION''
648: AND HZR.RELATIONSHIP_TYPE IN (''PARTNER'',''PARTNER_MANAGED_CUSTOMER'')

Line 645: AND HZR.object_table_name = ''HZ_PARTIES''

641: AND HZR.object_id = INTERNAL.party_id
642: AND HZR.subject_id = PVPP.partner_party_id
643: AND HZR.subject_id = PARTNER.party_id
644: AND HZR.subject_table_name = ''HZ_PARTIES''
645: AND HZR.object_table_name = ''HZ_PARTIES''
646: AND HZR.subject_type = ''ORGANIZATION''
647: AND HZR.object_type = ''ORGANIZATION''
648: AND HZR.RELATIONSHIP_TYPE IN (''PARTNER'',''PARTNER_MANAGED_CUSTOMER'')
649: AND INTERNAL.PARTY_TYPE=''ORGANIZATION''

Line 1040: FROM hz_parties PARTY

1036:
1037: -- Cursor l_relationship_details_csr to get partner party details
1038: CURSOR l_relationship_details_csr (cv_partner_id NUMBER) IS
1039: SELECT party_name
1040: FROM hz_parties PARTY
1041: WHERE PARTY.party_id = cv_partner_id
1042: AND PARTY.status = 'A'
1043: AND PARTY.party_type = 'PARTY_RELATIONSHIP';
1044:

Line 1054: hz_parties hzp

1050: SELECT hzr.relationship_id relationship_id,
1051: hzp.party_id party_id,
1052: hzp.party_number party_number
1053: FROM hz_relationships hzr,
1054: hz_parties hzp
1055: WHERE hzr.subject_id = cv_partner_party_id
1056: AND hzr.object_id = cv_vendor_party_id
1057: AND hzr.status = 'A'
1058: AND hzr.end_date > sysdate

Line 1155: l_relactionship_rec.subject_table_name := 'HZ_PARTIES';

1151:
1152: -- Initilize the l_relationship_rec with required values.
1153: l_relactionship_rec.subject_id := l_party_id;
1154: l_relactionship_rec.subject_type := 'ORGANIZATION';
1155: l_relactionship_rec.subject_table_name := 'HZ_PARTIES';
1156:
1157: -- Get the Default responsibility for the supplied Organization Id.
1158: Pv_User_Resp_Pvt.get_default_org_resp(
1159: p_api_version_number => 1.0

Line 1206: l_relactionship_rec.object_table_name := 'HZ_PARTIES';

1202:
1203: -- Iniliatize the local variables required for Relationship creation.
1204: l_relactionship_rec.object_id := l_vendor_org_id ;
1205: l_relactionship_rec.object_type := 'ORGANIZATION';
1206: l_relactionship_rec.object_table_name := 'HZ_PARTIES';
1207: l_relactionship_rec.relationship_code := 'PARTNER_OF';
1208: l_relactionship_rec.relationship_type := 'PARTNER';
1209: l_relactionship_rec.start_date := SYSDATE;
1210: l_relactionship_rec.created_by_module:= 'PV';

Line 1960: -- * Partner Organization record in HZ_PARTIES table

1956: -- Local variable initialization
1957:
1958:
1959: -- Call the Create_Partner API to create the following -
1960: -- * Partner Organization record in HZ_PARTIES table
1961: -- * Partner Location record in HZ_LOCATIONS table
1962: -- * Partner Party Site record in HZ_PARTY_SITES table
1963: -- * Call the Create_Relationship API to create the followings -
1964: -- o Get the Default responsibility for the supplied Organization Id

Line 2051: -- in HZ_PARTIES table.

2047: map_person_rec( p_person_rec => p_person_rec,
2048: x_person_rec => l_person_rec);
2049:
2050: -- Call the Create_Person API to create the contact person as a Party record
2051: -- in HZ_PARTIES table.
2052: HZ_PARTY_V2PUB.create_person (
2053: p_init_msg_list => FND_API.G_FALSE,
2054: p_person_rec => l_person_rec,
2055: x_party_id => l_cnt_per_party_id,

Line 2080: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

2076: l_org_contact_rec.application_id := l_application_id;
2077: l_org_contact_rec.created_by_module:= l_appl_short_name;
2078: l_org_contact_rec.party_rel_rec.subject_id := l_cnt_per_party_id;
2079: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2080: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2081: l_org_contact_rec.party_rel_rec.object_id := l_party_id ;
2082: l_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';
2083: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2084: l_org_contact_rec.party_rel_rec.relationship_code := 'EMPLOYEE_OF';

Line 2083: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

2079: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2080: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2081: l_org_contact_rec.party_rel_rec.object_id := l_party_id ;
2082: l_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';
2083: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2084: l_org_contact_rec.party_rel_rec.relationship_code := 'EMPLOYEE_OF';
2085: l_org_contact_rec.party_rel_rec.relationship_type := 'EMPLOYMENT';
2086: l_org_contact_rec.party_rel_rec.start_date := SYSDATE;
2087: l_org_contact_rec.party_rel_rec.created_by_module:= l_appl_short_name;

Line 2119: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

2115:
2116: -- Call the create_phone_contact_point API to create a Phone type Contact Point record
2117: -- in HZ_CONTACT_POINTS table.
2118:
2119: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
2120: l_contact_point_rec.owner_table_id := l_contact_rel_party_id;
2121: l_contact_point_rec.status := 'A';
2122: l_contact_point_rec.primary_flag := 'Y';
2123: l_contact_point_rec.contact_point_type := 'PHONE';