APPS.PV_PARTNER_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 252: hz_party_sites hs,

248: , null
249: from (
250: SELECT distinct 4 attribute_id, hl.country attr_text, pvpp.partner_id partner_id
251: FROM hz_locations hl,
252: hz_party_sites hs,
253: pv_partner_profiles pvpp
254: WHERE hl.location_id = hs.location_id
255: AND hs.party_id = pvpp.partner_party_id
256: AND pvpp.partner_id = :1

Line 625: hz_party_sites hs,

621: , null
622: from (
623: SELECT distinct 4 attribute_id, hl.country attr_text, pvpp.partner_id partner_id
624: FROM hz_locations hl,
625: hz_party_sites hs,
626: pv_partner_profiles pvpp
627: WHERE hl.location_id = hs.location_id
628: AND hs.party_id = pvpp.partner_party_id
629: AND pvpp.partner_id = :1

Line 795: hz_party_sites hps

791:
792: CURSOR get_site_use_type(cv_party_id NUMBER) IS
793: SELECT distinct site_use_type
794: FROM hz_party_site_uses hpsu,
795: hz_party_sites hps
796: WHERE hpsu.party_site_id = hps.party_site_id
797: AND site_use_type in ('SHIP_TO','BILL_TO')
798: AND hps.party_id = cv_party_id ;
799:

Line 801: SELECT party_site_id FROM HZ_PARTY_SITES WHERE PARTY_ID = CV_PARTY_ID AND IDENTIFYING_ADDRESS_FLAG = 'Y';

797: AND site_use_type in ('SHIP_TO','BILL_TO')
798: AND hps.party_id = cv_party_id ;
799:
800: CURSOR get_ident_party_site_dtls(cv_party_id NUMBER) is
801: SELECT party_site_id FROM HZ_PARTY_SITES WHERE PARTY_ID = CV_PARTY_ID AND IDENTIFYING_ADDRESS_FLAG = 'Y';
802:
803:
804: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
805: l_vendor_org_id number;

Line 1032: FROM hz_party_sites

1028: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type := p_partner_qualifiers_tbl;
1029: -- Cursor l_org_details_csr to get partner party details
1030: CURSOR l_org_details_csr (cv_party_id NUMBER) IS
1031: SELECT party_site_id
1032: FROM hz_party_sites
1033: WHERE party_id = cv_party_id
1034: AND identifying_address_flag = 'Y'
1035: AND status = 'A';
1036:

Line 1962: -- * Partner Party Site record in HZ_PARTY_SITES table

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
1965: -- o Get the default vendor org id, for the supplied Responsibility id
1966: -- o Create Partner Relationship record in HZ_RELATIONSHIPS table