APPS.HZ_PURGE_GEN dependencies on CSI_SYSTEMS_B

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

596:
597: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
598: )
599:
600: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
601: )
602:
603: or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID = temp.party_id
604: )

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

605:
606: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
607: )
608:
609: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
610: )
611:
612: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
613: )

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

608:
609: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
610: )
611:
612: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
613: )
614:
615: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
616: )

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

611:
612: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
613: )
614:
615: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
616: )
617:
618: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID = temp.party_id
619: )

Line 631: (select 'Y' from CSI_SYSTEMS_B

627: or exists (select 'Y' from HZ_PARTY_SITES
628: xx where xx.PARTY_ID = temp.party_id
629: and (nvl(STATUS, 'A') in ('A','I'))
630: and exists
631: (select 'Y' from CSI_SYSTEMS_B
632: yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
633: ));
634: else
635: delete from hz_purge_gt temp where

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

656:
657: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
658: )
659:
660: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
661: )
662:
663: or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID = temp.party_id
664: )

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

665:
666: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
667: )
668:
669: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
670: )
671:
672: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
673: )

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

668:
669: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID = temp.party_id
670: )
671:
672: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
673: )
674:
675: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
676: )

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

671:
672: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
673: )
674:
675: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID = temp.party_id
676: )
677:
678: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID = temp.party_id
679: )

Line 691: (select 'Y' from CSI_SYSTEMS_B

687: or exists (select 'Y' from HZ_PARTY_SITES
688: xx where xx.PARTY_ID = temp.party_id
689: and (nvl(STATUS, 'A') in ('A','I'))
690: and exists
691: (select 'Y' from CSI_SYSTEMS_B
692: yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
693: ));
694: end if;
695: