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

Line 581: hz_parties hp,

577: cursor lc_get_vendor_org(pc_partner_id NUMBER)
578: is
579: select hp.party_name
580: from hz_relationships porg,
581: hz_parties hp,
582: hz_organization_profiles hzop,
583: pv_partner_profiles pvpp
584: where porg.party_id = pc_partner_id
585: and porg.subject_table_name = 'HZ_PARTIES'

Line 585: and porg.subject_table_name = 'HZ_PARTIES'

581: hz_parties hp,
582: hz_organization_profiles hzop,
583: pv_partner_profiles pvpp
584: where porg.party_id = pc_partner_id
585: and porg.subject_table_name = 'HZ_PARTIES'
586: and porg.object_table_name = 'HZ_PARTIES'
587: and porg.relationship_code = 'PARTNER_OF'
588: and porg.relationship_type = 'PARTNER'
589: and porg.status = 'A'

Line 586: and porg.object_table_name = 'HZ_PARTIES'

582: hz_organization_profiles hzop,
583: pv_partner_profiles pvpp
584: where porg.party_id = pc_partner_id
585: and porg.subject_table_name = 'HZ_PARTIES'
586: and porg.object_table_name = 'HZ_PARTIES'
587: and porg.relationship_code = 'PARTNER_OF'
588: and porg.relationship_type = 'PARTNER'
589: and porg.status = 'A'
590: and PORG.start_date <= SYSDATE

Line 876: FROM as_leads_all ld, hz_parties pt

872:
873: CURSOR lc_opportunity (pc_lead_id number) is
874: SELECT ld.customer_id, ld.address_id
875: , pt.party_name, ld.currency_code
876: FROM as_leads_all ld, hz_parties pt
877: WHERE ld.customer_id = pt.party_id
878: AND ld.lead_id = pc_lead_id;
879:
880: CURSOR lc_get_opp_amt (pc_lead_id NUMBER) is

Line 1498: FROM hz_parties

1494:
1495: CURSOR get_customer_name(pc_party_id NUMBER)
1496: IS
1497: SELECT party_name
1498: FROM hz_parties
1499: WHERE party_id = pc_party_id;
1500:
1501: BEGIN
1502: -- Standard call to check for call compatibility.

Line 1735: FROM as_leads_all ld, hz_parties pt

1731:
1732: CURSOR lc_opportunity (pc_lead_id number) is
1733: SELECT ld.customer_id, ld.address_id, pt.party_name,
1734: nvl(ld.total_amount,0),ld.currency_code, ld.description
1735: FROM as_leads_all ld, hz_parties pt
1736: WHERE ld.customer_id = pt.party_id
1737: AND ld.lead_id = pc_lead_id;
1738:
1739: CURSOR lc_get_pt_emp_cat(pc_salesforce_id NUMBER) IS

Line 1747: FROM hz_parties VENDOR,

1743: AND js.resource_id = pc_salesforce_id;
1744:
1745: CURSOR lc_get_pt_ven_name(pc_party_id NUMBER) IS
1746: SELECT VENDOR.party_name
1747: FROM hz_parties VENDOR,
1748: hz_relationships PCONTACT,
1749: pv_partner_profiles PVPP
1750: WHERE PCONTACT.party_id = pc_party_id
1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'

Line 1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'

1747: FROM hz_parties VENDOR,
1748: hz_relationships PCONTACT,
1749: pv_partner_profiles PVPP
1750: WHERE PCONTACT.party_id = pc_party_id
1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
1752: AND PCONTACT.object_table_name = 'HZ_PARTIES'
1753: AND PCONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
1754: AND PCONTACT.directional_flag = 'F'
1755: AND PCONTACT.STATUS = 'A'

Line 1752: AND PCONTACT.object_table_name = 'HZ_PARTIES'

1748: hz_relationships PCONTACT,
1749: pv_partner_profiles PVPP
1750: WHERE PCONTACT.party_id = pc_party_id
1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
1752: AND PCONTACT.object_table_name = 'HZ_PARTIES'
1753: AND PCONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
1754: AND PCONTACT.directional_flag = 'F'
1755: AND PCONTACT.STATUS = 'A'
1756: AND PCONTACT.start_date <= SYSDATE

Line 1768: from hz_parties pt,

1764: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1765:
1766: cursor lc_get_pt_org_name(pc_item_type varchar2, pc_item_key varchar2) is
1767: select pt.party_name, pvas.partner_id
1768: from hz_parties pt,
1769: pv_partner_profiles pvpp,
1770: pv_lead_assignments pvas
1771: where pvas.wf_item_type = pc_item_type
1772: and pvas.wf_item_key = pc_item_key

Line 2566: hz_parties PARTNER,

2562:
2563: CURSOR lc_get_rel_type(pc_party_id number) is
2564: SELECT 'PARTNER_OF', PVPP.partner_id, PARTNER.party_name, peav.attr_value
2565: FROM
2566: hz_parties PARTNER,
2567: hz_relationships CONTACT,
2568: pv_partner_profiles PVPP,
2569: pv_enty_attr_values peav
2570: WHERE CONTACT.party_id = pc_party_id

Line 2571: AND CONTACT.subject_table_name = 'HZ_PARTIES'

2567: hz_relationships CONTACT,
2568: pv_partner_profiles PVPP,
2569: pv_enty_attr_values peav
2570: WHERE CONTACT.party_id = pc_party_id
2571: AND CONTACT.subject_table_name = 'HZ_PARTIES'
2572: AND CONTACT.object_table_name = 'HZ_PARTIES'
2573: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
2574: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
2575: AND CONTACT.directional_flag = 'F'

Line 2572: AND CONTACT.object_table_name = 'HZ_PARTIES'

2568: pv_partner_profiles PVPP,
2569: pv_enty_attr_values peav
2570: WHERE CONTACT.party_id = pc_party_id
2571: AND CONTACT.subject_table_name = 'HZ_PARTIES'
2572: AND CONTACT.object_table_name = 'HZ_PARTIES'
2573: AND CONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
2574: AND CONTACT.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
2575: AND CONTACT.directional_flag = 'F'
2576: AND CONTACT.STATUS = 'A'