5582: WHERE NOT EXISTS ( SELECT 'Y'
5583: FROM
5584: AP_SUPPLIER_CONTACTS PVC ,
5585: AP_SUPPLIER_SITES_ALL PVS ,
5586: HZ_PARTIES HP ,
5587: HZ_RELATIONSHIPS HPR ,
5588: HZ_PARTY_SITES HPS ,
5589: HZ_ORG_CONTACTS HOC ,
5590: HZ_PARTIES HP2 ,
5586: HZ_PARTIES HP ,
5587: HZ_RELATIONSHIPS HPR ,
5588: HZ_PARTY_SITES HPS ,
5589: HZ_ORG_CONTACTS HOC ,
5590: HZ_PARTIES HP2 ,
5591: AP_SUPPLIERS APS,
5592: PO_HEADERS_ALL POH
5593: WHERE PVC.PER_PARTY_ID = HP.PARTY_ID
5594: AND PVC.REL_PARTY_ID = HP2.PARTY_ID
7875: WHERE NOT EXISTS ( SELECT 'Y'
7876: FROM
7877: AP_SUPPLIER_CONTACTS PVC ,
7878: AP_SUPPLIER_SITES_ALL PVS ,
7879: HZ_PARTIES HP ,
7880: HZ_RELATIONSHIPS HPR ,
7881: HZ_PARTY_SITES HPS ,
7882: HZ_ORG_CONTACTS HOC ,
7883: HZ_PARTIES HP2 ,
7879: HZ_PARTIES HP ,
7880: HZ_RELATIONSHIPS HPR ,
7881: HZ_PARTY_SITES HPS ,
7882: HZ_ORG_CONTACTS HOC ,
7883: HZ_PARTIES HP2 ,
7884: AP_SUPPLIERS APS,
7885: po_headers_gt POH
7886: WHERE PVC.PER_PARTY_ID = HP.PARTY_ID
7887: AND PVC.REL_PARTY_ID = HP2.PARTY_ID