DBA Data[Home] [Help]

APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on HZ_PARTY_SITE_USES

Line 2312: hz_party_site_uses hpsu

2308: AND csi.owner_party_source_table = 'HZ_PARTIES'
2309: AND hl.location_id = csi.install_location_id
2310: AND NOT EXISTS (SELECT 1
2311: FROM hz_party_sites hps,
2312: hz_party_site_uses hpsu
2313: WHERE hps.location_id = hl.location_id
2314: AND hps.party_id = csi.owner_party_id
2315: AND hpsu.party_site_id = hps.party_site_id
2316: AND hpsu.site_use_type = 'INSTALL_AT'

Line 2330: FROM hz_party_site_uses hpsu

2326: AND csi.owner_party_source_table = 'HZ_PARTIES'
2327: AND csi.install_location_id = hps.party_site_id
2328: AND csi.owner_party_id = hps.party_id
2329: AND NOT EXISTS (SELECT 1
2330: FROM hz_party_site_uses hpsu
2331: WHERE hpsu.party_site_id = hps.party_site_id
2332: AND hpsu.site_use_type = 'INSTALL_AT'
2333: AND NVL(hpsu.status, 'X') = 'A'
2334: )