APPS.HZ_PURGE_GEN dependencies on CSI_SYSTEMS_B

Line 759: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id

755:
756: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
757: )
758:
759: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
760: )
761:
762: or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID = temp.party_id
763: )

Line 768: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id

764:
765: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
766: )
767:
768: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
769: )
770:
771: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
772: )

Line 771: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id

767:
768: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
769: )
770:
771: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
772: )
773:
774: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
775: )

Line 774: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id

770:
771: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
772: )
773:
774: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
775: )
776:
777: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID = temp.party_id
778: )

Line 790: (select 'Y' from CSI_SYSTEMS_B

786: or exists (select 'Y' from HZ_PARTY_SITES
787: xx where xx.PARTY_ID = temp.party_id
788: and (nvl(STATUS, 'A') in ('A','I'))
789: and exists
790: (select 'Y' from CSI_SYSTEMS_B
791: yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
792: ));
793: else
794: delete from hz_purge_gt temp where

Line 819: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id

815:
816: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
817: )
818:
819: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
820: )
821:
822: or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID = temp.party_id
823: )

Line 828: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id

824:
825: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
826: )
827:
828: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
829: )
830:
831: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
832: )

Line 831: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id

827:
828: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
829: )
830:
831: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
832: )
833:
834: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
835: )

Line 834: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id

830:
831: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
832: )
833:
834: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
835: )
836:
837: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID = temp.party_id
838: )

Line 850: (select 'Y' from CSI_SYSTEMS_B

846: or exists (select 'Y' from HZ_PARTY_SITES
847: xx where xx.PARTY_ID = temp.party_id
848: and (nvl(STATUS, 'A') in ('A','I'))
849: and exists
850: (select 'Y' from CSI_SYSTEMS_B
851: yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
852: ));
853: end if;
854: