eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN dependencies on HZ_PARTY_SITES

Line 76: or exists (select 'Y' from HZ_PARTY_SITES

72:
73: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
74: )
75:
76: or exists (select 'Y' from HZ_PARTY_SITES
77: xx where xx.PARTY_ID = temp.party_id
78: and (nvl(STATUS, 'A') in ('A','I'))
79: and exists
80: (select 'Y' from PV_REFERRALS_B

Line 84: or exists (select 'Y' from HZ_PARTY_SITES

80: (select 'Y' from PV_REFERRALS_B
81: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
82: ))
83:
84: or exists (select 'Y' from HZ_PARTY_SITES
85: xx where xx.PARTY_ID = temp.party_id
86: and (nvl(STATUS, 'A') in ('A','I'))
87: and exists
88: (select 'Y' from HZ_ORG_CONTACTS

Line 175: or exists (select 'Y' from HZ_PARTY_SITES

171:
172: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
173: )
174:
175: or exists (select 'Y' from HZ_PARTY_SITES
176: xx where xx.PARTY_ID = temp.party_id
177: and (nvl(STATUS, 'A') in ('A','I'))
178: and exists
179: (select 'Y' from PV_REFERRALS_B

Line 183: or exists (select 'Y' from HZ_PARTY_SITES

179: (select 'Y' from PV_REFERRALS_B
180: yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
181: ))
182:
183: or exists (select 'Y' from HZ_PARTY_SITES
184: xx where xx.PARTY_ID = temp.party_id
185: and (nvl(STATUS, 'A') in ('A','I'))
186: and exists
187: (select 'Y' from HZ_ORG_CONTACTS

Line 243: or exists (select 'Y' from HZ_PARTY_SITES

239:
240: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id
241: )
242:
243: or exists (select 'Y' from HZ_PARTY_SITES
244: xx where xx.PARTY_ID = temp.party_id
245: and (nvl(STATUS, 'A') in ('A','I'))
246: and exists
247: (select 'Y' from WSH_CARRIER_SITES

Line 257: or exists (select 'Y' from HZ_PARTY_SITES

253:
254: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id
255: )
256:
257: or exists (select 'Y' from HZ_PARTY_SITES
258: xx where xx.PARTY_ID = temp.party_id
259: and (nvl(STATUS, 'A') in ('A','I'))
260: and exists
261: (select 'Y' from WSH_CARRIER_SITES

Line 276: or exists (select 'Y' from HZ_PARTY_SITES

272:
273: exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
274: and (nvl(STATUS, 'A') in ('A','I')))
275:
276: or exists (select 'Y' from HZ_PARTY_SITES
277: xx where xx.PARTY_ID = temp.party_id
278: and (nvl(STATUS, 'A') in ('A','I'))
279: and exists
280: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 307: or exists (select 'Y' from HZ_PARTY_SITES

303:
304: exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
305: and (nvl(STATUS, 'A') in ('A','I')))
306:
307: or exists (select 'Y' from HZ_PARTY_SITES
308: xx where xx.PARTY_ID = temp.party_id
309: and (nvl(STATUS, 'A') in ('A','I'))
310: and exists
311: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 346: or exists (select 'Y' from HZ_PARTY_SITES

342:
343: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
344: )
345:
346: or exists (select 'Y' from HZ_PARTY_SITES
347: xx where xx.PARTY_ID = temp.party_id
348: and (nvl(STATUS, 'A') in ('A','I'))
349: and exists
350: (select 'Y' from IBE_ORD_ONECLICK_ALL

Line 354: or exists (select 'Y' from HZ_PARTY_SITES

350: (select 'Y' from IBE_ORD_ONECLICK_ALL
351: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
352: ))
353:
354: or exists (select 'Y' from HZ_PARTY_SITES
355: xx where xx.PARTY_ID = temp.party_id
356: and (nvl(STATUS, 'A') in ('A','I'))
357: and exists
358: (select 'Y' from IBE_ORD_ONECLICK_ALL

Line 374: or exists (select 'Y' from HZ_PARTY_SITES

370:
371: or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID = temp.party_id
372: )
373:
374: or exists (select 'Y' from HZ_PARTY_SITES
375: xx where xx.PARTY_ID = temp.party_id
376: and (nvl(STATUS, 'A') in ('A','I'))
377: and exists
378: (select 'Y' from IBE_ORD_ONECLICK_ALL

Line 382: or exists (select 'Y' from HZ_PARTY_SITES

378: (select 'Y' from IBE_ORD_ONECLICK_ALL
379: yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
380: ))
381:
382: or exists (select 'Y' from HZ_PARTY_SITES
383: xx where xx.PARTY_ID = temp.party_id
384: and (nvl(STATUS, 'A') in ('A','I'))
385: and exists
386: (select 'Y' from IBE_ORD_ONECLICK_ALL

Line 475: or exists (select 'Y' from HZ_PARTY_SITES

471:
472: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
473: )
474:
475: or exists (select 'Y' from HZ_PARTY_SITES
476: xx where xx.PARTY_ID = temp.party_id
477: and (nvl(STATUS, 'A') in ('A','I'))
478: and exists
479: (select 'Y' from IEX_CASE_CONTACTS

Line 489: or exists (select 'Y' from HZ_PARTY_SITES

485:
486: exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID = temp.party_id
487: )
488:
489: or exists (select 'Y' from HZ_PARTY_SITES
490: xx where xx.PARTY_ID = temp.party_id
491: and (nvl(STATUS, 'A') in ('A','I'))
492: and exists
493: (select 'Y' from IEX_CASE_CONTACTS

Line 508: or exists (select 'Y' from HZ_PARTY_SITES

504:
505: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
506: and ((qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16' OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3' OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
507:
508: or exists (select 'Y' from HZ_PARTY_SITES
509: xx where xx.PARTY_ID = temp.party_id
510: and (nvl(STATUS, 'A') in ('A','I'))
511: and exists
512: (select 'Y' from QP_QUALIFIERS

Line 522: or exists (select 'Y' from HZ_PARTY_SITES

518:
519: exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE = to_char(temp.party_id)
520: and ((qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16' OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3' OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
521:
522: or exists (select 'Y' from HZ_PARTY_SITES
523: xx where xx.PARTY_ID = temp.party_id
524: and (nvl(STATUS, 'A') in ('A','I'))
525: and exists
526: (select 'Y' from QP_QUALIFIERS

Line 581: or exists (select 'Y' from HZ_PARTY_SITES

577:
578: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id
579: )
580:
581: or exists (select 'Y' from HZ_PARTY_SITES
582: xx where xx.PARTY_ID = temp.party_id
583: and (nvl(STATUS, 'A') in ('A','I'))
584: and exists
585: (select 'Y' from CSI_T_TXN_LINE_DETAILS

Line 589: or exists (select 'Y' from HZ_PARTY_SITES

585: (select 'Y' from CSI_T_TXN_LINE_DETAILS
586: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
587: ))
588:
589: or exists (select 'Y' from HZ_PARTY_SITES
590: xx where xx.PARTY_ID = temp.party_id
591: and (nvl(STATUS, 'A') in ('A','I'))
592: and exists
593: (select 'Y' from CSI_T_TXN_LINE_DETAILS

Line 627: or exists (select 'Y' from HZ_PARTY_SITES

623:
624: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
625: )
626:
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

Line 641: or exists (select 'Y' from HZ_PARTY_SITES

637:
638: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id
639: )
640:
641: or exists (select 'Y' from HZ_PARTY_SITES
642: xx where xx.PARTY_ID = temp.party_id
643: and (nvl(STATUS, 'A') in ('A','I'))
644: and exists
645: (select 'Y' from CSI_T_TXN_LINE_DETAILS

Line 649: or exists (select 'Y' from HZ_PARTY_SITES

645: (select 'Y' from CSI_T_TXN_LINE_DETAILS
646: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
647: ))
648:
649: or exists (select 'Y' from HZ_PARTY_SITES
650: xx where xx.PARTY_ID = temp.party_id
651: and (nvl(STATUS, 'A') in ('A','I'))
652: and exists
653: (select 'Y' from CSI_T_TXN_LINE_DETAILS

Line 687: or exists (select 'Y' from HZ_PARTY_SITES

683:
684: or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.TECHNICAL_CONTACT_ID = temp.party_id
685: )
686:
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

Line 718: or exists (select 'Y' from HZ_PARTY_SITES

714:
715: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
716: and (jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))
717:
718: or exists (select 'Y' from HZ_PARTY_SITES
719: xx where xx.PARTY_ID = temp.party_id
720: and (nvl(STATUS, 'A') in ('A','I'))
721: and exists
722: (select 'Y' from OKC_RULES_B

Line 726: or exists (select 'Y' from HZ_PARTY_SITES

722: (select 'Y' from OKC_RULES_B
723: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
724: and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
725:
726: or exists (select 'Y' from HZ_PARTY_SITES
727: xx where xx.PARTY_ID = temp.party_id
728: and (nvl(STATUS, 'A') in ('A','I'))
729: and exists
730: (select 'Y' from OKC_RULES_B

Line 734: or exists (select 'Y' from HZ_PARTY_SITES

730: (select 'Y' from OKC_RULES_B
731: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
732: and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
733:
734: or exists (select 'Y' from HZ_PARTY_SITES
735: xx where xx.PARTY_ID = temp.party_id
736: and (nvl(STATUS, 'A') in ('A','I'))
737: and exists
738: (select 'Y' from OKC_RULES_B

Line 742: or exists (select 'Y' from HZ_PARTY_SITES

738: (select 'Y' from OKC_RULES_B
739: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
740: and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
741:
742: or exists (select 'Y' from HZ_PARTY_SITES
743: xx where xx.PARTY_ID = temp.party_id
744: and (nvl(STATUS, 'A') in ('A','I'))
745: and exists
746: (select 'Y' from HZ_PARTY_SITE_USES

Line 752: or exists (select 'Y' from HZ_PARTY_SITES

748: and nvl(STATUS, 'A') in ('A','I')
749: and exists
750: (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))
751:
752: or exists (select 'Y' from HZ_PARTY_SITES
753: xx where xx.PARTY_ID = temp.party_id
754: and (nvl(STATUS, 'A') in ('A','I'))
755: and exists
756: (select 'Y' from HZ_PARTY_SITE_USES

Line 762: or exists (select 'Y' from HZ_PARTY_SITES

758: and nvl(STATUS, 'A') in ('A','I')
759: and exists
760: (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))
761:
762: or exists (select 'Y' from HZ_PARTY_SITES
763: xx where xx.PARTY_ID = temp.party_id
764: and (nvl(STATUS, 'A') in ('A','I'))
765: and exists
766: (select 'Y' from HZ_PARTY_SITE_USES

Line 775: or exists (select 'Y' from HZ_PARTY_SITES

771:
772: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
773: and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))
774:
775: or exists (select 'Y' from HZ_PARTY_SITES
776: xx where xx.PARTY_ID = temp.party_id
777: and (nvl(STATUS, 'A') in ('A','I'))
778: and exists
779: (select 'Y' from OKC_K_ITEMS

Line 783: or exists (select 'Y' from HZ_PARTY_SITES

779: (select 'Y' from OKC_K_ITEMS
780: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
781: and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
782:
783: or exists (select 'Y' from HZ_PARTY_SITES
784: xx where xx.PARTY_ID = temp.party_id
785: and (nvl(STATUS, 'A') in ('A','I'))
786: and exists
787: (select 'Y' from HZ_PARTY_SITE_USES

Line 811: or exists (select 'Y' from HZ_PARTY_SITES

807:
808: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
809: and (jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))
810:
811: or exists (select 'Y' from HZ_PARTY_SITES
812: xx where xx.PARTY_ID = temp.party_id
813: and (nvl(STATUS, 'A') in ('A','I'))
814: and exists
815: (select 'Y' from OKC_RULES_B

Line 819: or exists (select 'Y' from HZ_PARTY_SITES

815: (select 'Y' from OKC_RULES_B
816: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
817: and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
818:
819: or exists (select 'Y' from HZ_PARTY_SITES
820: xx where xx.PARTY_ID = temp.party_id
821: and (nvl(STATUS, 'A') in ('A','I'))
822: and exists
823: (select 'Y' from OKC_RULES_B

Line 827: or exists (select 'Y' from HZ_PARTY_SITES

823: (select 'Y' from OKC_RULES_B
824: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
825: and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
826:
827: or exists (select 'Y' from HZ_PARTY_SITES
828: xx where xx.PARTY_ID = temp.party_id
829: and (nvl(STATUS, 'A') in ('A','I'))
830: and exists
831: (select 'Y' from OKC_RULES_B

Line 835: or exists (select 'Y' from HZ_PARTY_SITES

831: (select 'Y' from OKC_RULES_B
832: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
833: and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
834:
835: or exists (select 'Y' from HZ_PARTY_SITES
836: xx where xx.PARTY_ID = temp.party_id
837: and (nvl(STATUS, 'A') in ('A','I'))
838: and exists
839: (select 'Y' from HZ_PARTY_SITE_USES

Line 845: or exists (select 'Y' from HZ_PARTY_SITES

841: and nvl(STATUS, 'A') in ('A','I')
842: and exists
843: (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))
844:
845: or exists (select 'Y' from HZ_PARTY_SITES
846: xx where xx.PARTY_ID = temp.party_id
847: and (nvl(STATUS, 'A') in ('A','I'))
848: and exists
849: (select 'Y' from HZ_PARTY_SITE_USES

Line 855: or exists (select 'Y' from HZ_PARTY_SITES

851: and nvl(STATUS, 'A') in ('A','I')
852: and exists
853: (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))
854:
855: or exists (select 'Y' from HZ_PARTY_SITES
856: xx where xx.PARTY_ID = temp.party_id
857: and (nvl(STATUS, 'A') in ('A','I'))
858: and exists
859: (select 'Y' from HZ_PARTY_SITE_USES

Line 868: or exists (select 'Y' from HZ_PARTY_SITES

864:
865: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
866: and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))
867:
868: or exists (select 'Y' from HZ_PARTY_SITES
869: xx where xx.PARTY_ID = temp.party_id
870: and (nvl(STATUS, 'A') in ('A','I'))
871: and exists
872: (select 'Y' from OKC_K_ITEMS

Line 876: or exists (select 'Y' from HZ_PARTY_SITES

872: (select 'Y' from OKC_K_ITEMS
873: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
874: and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))
875:
876: or exists (select 'Y' from HZ_PARTY_SITES
877: xx where xx.PARTY_ID = temp.party_id
878: and (nvl(STATUS, 'A') in ('A','I'))
879: and exists
880: (select 'Y' from HZ_PARTY_SITE_USES

Line 897: or exists (select 'Y' from HZ_PARTY_SITES

893:
894: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
895: )
896:
897: or exists (select 'Y' from HZ_PARTY_SITES
898: xx where xx.PARTY_ID = temp.party_id
899: and (nvl(STATUS, 'A') in ('A','I'))
900: and exists
901: (select 'Y' from ASO_SHIPMENTS

Line 914: or exists (select 'Y' from HZ_PARTY_SITES

910:
911: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
912: )
913:
914: or exists (select 'Y' from HZ_PARTY_SITES
915: xx where xx.PARTY_ID = temp.party_id
916: and (nvl(STATUS, 'A') in ('A','I'))
917: and exists
918: (select 'Y' from ASO_QUOTE_HEADERS_ALL

Line 928: or exists (select 'Y' from HZ_PARTY_SITES

924:
925: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
926: )
927:
928: or exists (select 'Y' from HZ_PARTY_SITES
929: xx where xx.PARTY_ID = temp.party_id
930: and (nvl(STATUS, 'A') in ('A','I'))
931: and exists
932: (select 'Y' from ASO_QUOTE_LINES_ALL

Line 942: or exists (select 'Y' from HZ_PARTY_SITES

938:
939: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
940: )
941:
942: or exists (select 'Y' from HZ_PARTY_SITES
943: xx where xx.PARTY_ID = temp.party_id
944: and (nvl(STATUS, 'A') in ('A','I'))
945: and exists
946: (select 'Y' from ASO_SHIPMENTS

Line 959: or exists (select 'Y' from HZ_PARTY_SITES

955:
956: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
957: )
958:
959: or exists (select 'Y' from HZ_PARTY_SITES
960: xx where xx.PARTY_ID = temp.party_id
961: and (nvl(STATUS, 'A') in ('A','I'))
962: and exists
963: (select 'Y' from ASO_QUOTE_HEADERS_ALL

Line 973: or exists (select 'Y' from HZ_PARTY_SITES

969:
970: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
971: )
972:
973: or exists (select 'Y' from HZ_PARTY_SITES
974: xx where xx.PARTY_ID = temp.party_id
975: and (nvl(STATUS, 'A') in ('A','I'))
976: and exists
977: (select 'Y' from ASO_QUOTE_LINES_ALL

Line 1047: exists (select 'Y' from HZ_PARTY_SITES

1043: if(regid_proc = true) then
1044: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where
1045:
1046:
1047: exists (select 'Y' from HZ_PARTY_SITES
1048: xx where xx.PARTY_ID = temp.party_id
1049: and (nvl(STATUS, 'A') in ('A','I'))
1050: and exists
1051: (select 'Y' from AS_SALES_LEAD_CONTACTS

Line 1062: or exists (select 'Y' from HZ_PARTY_SITES

1058: and exists
1059: (select 'Y' from AS_SALES_LEAD_CONTACTS
1060: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1061: ))
1062: or exists (select 'Y' from HZ_PARTY_SITES
1063: xx where xx.PARTY_ID = temp.party_id
1064: and (nvl(STATUS, 'A') in ('A','I'))
1065: and exists
1066: (select 'Y' from HZ_CONTACT_POINTS

Line 1068: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1064: and (nvl(STATUS, 'A') in ('A','I'))
1065: and exists
1066: (select 'Y' from HZ_CONTACT_POINTS
1067: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1068: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1069: and exists
1070: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1071:
1072: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id

Line 1078: or exists (select 'Y' from HZ_PARTY_SITES

1074:
1075: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1076: )
1077:
1078: or exists (select 'Y' from HZ_PARTY_SITES
1079: xx where xx.PARTY_ID = temp.party_id
1080: and (nvl(STATUS, 'A') in ('A','I'))
1081: and exists
1082: (select 'Y' from AS_ACCESSES_ALL

Line 1095: or exists (select 'Y' from HZ_PARTY_SITES

1091:
1092: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1093: )
1094:
1095: or exists (select 'Y' from HZ_PARTY_SITES
1096: xx where xx.PARTY_ID = temp.party_id
1097: and (nvl(STATUS, 'A') in ('A','I'))
1098: and exists
1099: (select 'Y' from AS_INTERESTS_ALL

Line 1103: or exists (select 'Y' from HZ_PARTY_SITES

1099: (select 'Y' from AS_INTERESTS_ALL
1100: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1101: ))
1102:
1103: or exists (select 'Y' from HZ_PARTY_SITES
1104: xx where xx.PARTY_ID = temp.party_id
1105: and (nvl(STATUS, 'A') in ('A','I'))
1106: and exists
1107: (select 'Y' from HZ_ORG_CONTACTS

Line 1143: or exists (select 'Y' from HZ_PARTY_SITES

1139: and nvl(STATUS, 'A') in ('A','I')
1140: and exists
1141: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1142:
1143: or exists (select 'Y' from HZ_PARTY_SITES
1144: xx where xx.PARTY_ID = temp.party_id
1145: and (nvl(STATUS, 'A') in ('A','I'))
1146: and exists
1147: (select 'Y' from AS_ACCESSES_ALL

Line 1160: or exists (select 'Y' from HZ_PARTY_SITES

1156:
1157: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1158: )
1159:
1160: or exists (select 'Y' from HZ_PARTY_SITES
1161: xx where xx.PARTY_ID = temp.party_id
1162: and (nvl(STATUS, 'A') in ('A','I'))
1163: and exists
1164: (select 'Y' from AS_LEADS_ALL

Line 1177: or exists (select 'Y' from HZ_PARTY_SITES

1173:
1174: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1175: )
1176:
1177: or exists (select 'Y' from HZ_PARTY_SITES
1178: xx where xx.PARTY_ID = temp.party_id
1179: and (nvl(STATUS, 'A') in ('A','I'))
1180: and exists
1181: (select 'Y' from HZ_ORG_CONTACTS

Line 1223: or exists (select 'Y' from HZ_PARTY_SITES

1219:
1220: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1221: )
1222:
1223: or exists (select 'Y' from HZ_PARTY_SITES
1224: xx where xx.PARTY_ID = temp.party_id
1225: and (nvl(STATUS, 'A') in ('A','I'))
1226: and exists
1227: (select 'Y' from AS_LEAD_CONTACTS_ALL

Line 1234: or exists (select 'Y' from HZ_PARTY_SITES

1230:
1231: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1232: )
1233:
1234: or exists (select 'Y' from HZ_PARTY_SITES
1235: xx where xx.PARTY_ID = temp.party_id
1236: and (nvl(STATUS, 'A') in ('A','I'))
1237: and exists
1238: (select 'Y' from AS_SALES_CREDITS

Line 1245: or exists (select 'Y' from HZ_PARTY_SITES

1241:
1242: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1243: )
1244:
1245: or exists (select 'Y' from HZ_PARTY_SITES
1246: xx where xx.PARTY_ID = temp.party_id
1247: and (nvl(STATUS, 'A') in ('A','I'))
1248: and exists
1249: (select 'Y' from AS_SALES_CREDITS_DENORM

Line 1256: or exists (select 'Y' from HZ_PARTY_SITES

1252:
1253: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1254: )
1255:
1256: or exists (select 'Y' from HZ_PARTY_SITES
1257: xx where xx.PARTY_ID = temp.party_id
1258: and (nvl(STATUS, 'A') in ('A','I'))
1259: and exists
1260: (select 'Y' from AS_SALES_CREDITS_DENORM

Line 1271: or exists (select 'Y' from HZ_PARTY_SITES

1267: and exists
1268: (select 'Y' from AS_LEAD_CONTACTS_ALL
1269: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1270: ))
1271: or exists (select 'Y' from HZ_PARTY_SITES
1272: xx where xx.PARTY_ID = temp.party_id
1273: and (nvl(STATUS, 'A') in ('A','I'))
1274: and exists
1275: (select 'Y' from HZ_CONTACT_POINTS

Line 1277: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1273: and (nvl(STATUS, 'A') in ('A','I'))
1274: and exists
1275: (select 'Y' from HZ_CONTACT_POINTS
1276: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1277: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1278: and exists
1279: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1280:
1281: or exists (select 'Y' from HZ_PARTY_SITES

Line 1281: or exists (select 'Y' from HZ_PARTY_SITES

1277: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1278: and exists
1279: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1280:
1281: or exists (select 'Y' from HZ_PARTY_SITES
1282: xx where xx.PARTY_ID = temp.party_id
1283: and (nvl(STATUS, 'A') in ('A','I'))
1284: and exists
1285: (select 'Y' from AS_CURRENT_ENVIRONMENT

Line 1289: or exists (select 'Y' from HZ_PARTY_SITES

1285: (select 'Y' from AS_CURRENT_ENVIRONMENT
1286: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1287: ))
1288:
1289: or exists (select 'Y' from HZ_PARTY_SITES
1290: xx where xx.PARTY_ID = temp.party_id
1291: and (nvl(STATUS, 'A') in ('A','I'))
1292: and exists
1293: (select 'Y' from HZ_ORG_CONTACTS

Line 1329: or exists (select 'Y' from HZ_PARTY_SITES

1325: and nvl(STATUS, 'A') in ('A','I')
1326: and exists
1327: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1328:
1329: or exists (select 'Y' from HZ_PARTY_SITES
1330: xx where xx.PARTY_ID = temp.party_id
1331: and (nvl(STATUS, 'A') in ('A','I'))
1332: and exists
1333: (select 'Y' from AS_SALES_LEADS

Line 1350: or exists (select 'Y' from HZ_PARTY_SITES

1346: and exists
1347: (select 'Y' from AS_SALES_LEADS
1348: yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
1349: ))
1350: or exists (select 'Y' from HZ_PARTY_SITES
1351: xx where xx.PARTY_ID = temp.party_id
1352: and (nvl(STATUS, 'A') in ('A','I'))
1353: and exists
1354: (select 'Y' from HZ_CONTACT_POINTS

Line 1356: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1352: and (nvl(STATUS, 'A') in ('A','I'))
1353: and exists
1354: (select 'Y' from HZ_CONTACT_POINTS
1355: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1356: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1357: and exists
1358: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))
1359:
1360: or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID = temp.party_id

Line 1366: exists (select 'Y' from HZ_PARTY_SITES

1362: else
1363: delete from hz_purge_gt temp where
1364:
1365:
1366: exists (select 'Y' from HZ_PARTY_SITES
1367: xx where xx.PARTY_ID = temp.party_id
1368: and (nvl(STATUS, 'A') in ('A','I'))
1369: and exists
1370: (select 'Y' from AS_SALES_LEAD_CONTACTS

Line 1381: or exists (select 'Y' from HZ_PARTY_SITES

1377: and exists
1378: (select 'Y' from AS_SALES_LEAD_CONTACTS
1379: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1380: ))
1381: or exists (select 'Y' from HZ_PARTY_SITES
1382: xx where xx.PARTY_ID = temp.party_id
1383: and (nvl(STATUS, 'A') in ('A','I'))
1384: and exists
1385: (select 'Y' from HZ_CONTACT_POINTS

Line 1387: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1383: and (nvl(STATUS, 'A') in ('A','I'))
1384: and exists
1385: (select 'Y' from HZ_CONTACT_POINTS
1386: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1387: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1388: and exists
1389: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1390:
1391: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id

Line 1397: or exists (select 'Y' from HZ_PARTY_SITES

1393:
1394: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1395: )
1396:
1397: or exists (select 'Y' from HZ_PARTY_SITES
1398: xx where xx.PARTY_ID = temp.party_id
1399: and (nvl(STATUS, 'A') in ('A','I'))
1400: and exists
1401: (select 'Y' from AS_ACCESSES_ALL

Line 1414: or exists (select 'Y' from HZ_PARTY_SITES

1410:
1411: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1412: )
1413:
1414: or exists (select 'Y' from HZ_PARTY_SITES
1415: xx where xx.PARTY_ID = temp.party_id
1416: and (nvl(STATUS, 'A') in ('A','I'))
1417: and exists
1418: (select 'Y' from AS_INTERESTS_ALL

Line 1422: or exists (select 'Y' from HZ_PARTY_SITES

1418: (select 'Y' from AS_INTERESTS_ALL
1419: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1420: ))
1421:
1422: or exists (select 'Y' from HZ_PARTY_SITES
1423: xx where xx.PARTY_ID = temp.party_id
1424: and (nvl(STATUS, 'A') in ('A','I'))
1425: and exists
1426: (select 'Y' from HZ_ORG_CONTACTS

Line 1462: or exists (select 'Y' from HZ_PARTY_SITES

1458: and nvl(STATUS, 'A') in ('A','I')
1459: and exists
1460: (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1461:
1462: or exists (select 'Y' from HZ_PARTY_SITES
1463: xx where xx.PARTY_ID = temp.party_id
1464: and (nvl(STATUS, 'A') in ('A','I'))
1465: and exists
1466: (select 'Y' from AS_ACCESSES_ALL

Line 1479: or exists (select 'Y' from HZ_PARTY_SITES

1475:
1476: or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1477: )
1478:
1479: or exists (select 'Y' from HZ_PARTY_SITES
1480: xx where xx.PARTY_ID = temp.party_id
1481: and (nvl(STATUS, 'A') in ('A','I'))
1482: and exists
1483: (select 'Y' from AS_LEADS_ALL

Line 1496: or exists (select 'Y' from HZ_PARTY_SITES

1492:
1493: or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID = temp.party_id
1494: )
1495:
1496: or exists (select 'Y' from HZ_PARTY_SITES
1497: xx where xx.PARTY_ID = temp.party_id
1498: and (nvl(STATUS, 'A') in ('A','I'))
1499: and exists
1500: (select 'Y' from HZ_ORG_CONTACTS

Line 1542: or exists (select 'Y' from HZ_PARTY_SITES

1538:
1539: or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1540: )
1541:
1542: or exists (select 'Y' from HZ_PARTY_SITES
1543: xx where xx.PARTY_ID = temp.party_id
1544: and (nvl(STATUS, 'A') in ('A','I'))
1545: and exists
1546: (select 'Y' from AS_LEAD_CONTACTS_ALL

Line 1553: or exists (select 'Y' from HZ_PARTY_SITES

1549:
1550: or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1551: )
1552:
1553: or exists (select 'Y' from HZ_PARTY_SITES
1554: xx where xx.PARTY_ID = temp.party_id
1555: and (nvl(STATUS, 'A') in ('A','I'))
1556: and exists
1557: (select 'Y' from AS_SALES_CREDITS

Line 1564: or exists (select 'Y' from HZ_PARTY_SITES

1560:
1561: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1562: )
1563:
1564: or exists (select 'Y' from HZ_PARTY_SITES
1565: xx where xx.PARTY_ID = temp.party_id
1566: and (nvl(STATUS, 'A') in ('A','I'))
1567: and exists
1568: (select 'Y' from AS_SALES_CREDITS_DENORM

Line 1575: or exists (select 'Y' from HZ_PARTY_SITES

1571:
1572: or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID = temp.party_id
1573: )
1574:
1575: or exists (select 'Y' from HZ_PARTY_SITES
1576: xx where xx.PARTY_ID = temp.party_id
1577: and (nvl(STATUS, 'A') in ('A','I'))
1578: and exists
1579: (select 'Y' from AS_SALES_CREDITS_DENORM

Line 1590: or exists (select 'Y' from HZ_PARTY_SITES

1586: and exists
1587: (select 'Y' from AS_LEAD_CONTACTS_ALL
1588: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
1589: ))
1590: or exists (select 'Y' from HZ_PARTY_SITES
1591: xx where xx.PARTY_ID = temp.party_id
1592: and (nvl(STATUS, 'A') in ('A','I'))
1593: and exists
1594: (select 'Y' from HZ_CONTACT_POINTS

Line 1596: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1592: and (nvl(STATUS, 'A') in ('A','I'))
1593: and exists
1594: (select 'Y' from HZ_CONTACT_POINTS
1595: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1596: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1597: and exists
1598: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1599:
1600: or exists (select 'Y' from HZ_PARTY_SITES

Line 1600: or exists (select 'Y' from HZ_PARTY_SITES

1596: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1597: and exists
1598: (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
1599:
1600: or exists (select 'Y' from HZ_PARTY_SITES
1601: xx where xx.PARTY_ID = temp.party_id
1602: and (nvl(STATUS, 'A') in ('A','I'))
1603: and exists
1604: (select 'Y' from AS_CURRENT_ENVIRONMENT

Line 1608: or exists (select 'Y' from HZ_PARTY_SITES

1604: (select 'Y' from AS_CURRENT_ENVIRONMENT
1605: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1606: ))
1607:
1608: or exists (select 'Y' from HZ_PARTY_SITES
1609: xx where xx.PARTY_ID = temp.party_id
1610: and (nvl(STATUS, 'A') in ('A','I'))
1611: and exists
1612: (select 'Y' from HZ_ORG_CONTACTS

Line 1648: or exists (select 'Y' from HZ_PARTY_SITES

1644: and nvl(STATUS, 'A') in ('A','I')
1645: and exists
1646: (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
1647:
1648: or exists (select 'Y' from HZ_PARTY_SITES
1649: xx where xx.PARTY_ID = temp.party_id
1650: and (nvl(STATUS, 'A') in ('A','I'))
1651: and exists
1652: (select 'Y' from AS_SALES_LEADS

Line 1669: or exists (select 'Y' from HZ_PARTY_SITES

1665: and exists
1666: (select 'Y' from AS_SALES_LEADS
1667: yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
1668: ))
1669: or exists (select 'Y' from HZ_PARTY_SITES
1670: xx where xx.PARTY_ID = temp.party_id
1671: and (nvl(STATUS, 'A') in ('A','I'))
1672: and exists
1673: (select 'Y' from HZ_CONTACT_POINTS

Line 1675: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1671: and (nvl(STATUS, 'A') in ('A','I'))
1672: and exists
1673: (select 'Y' from HZ_CONTACT_POINTS
1674: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1675: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1676: and exists
1677: (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))
1678:
1679: or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID = temp.party_id

Line 1890: exists (select 'Y' from HZ_PARTY_SITES

1886: if(regid_proc = true) then
1887: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where
1888:
1889:
1890: exists (select 'Y' from HZ_PARTY_SITES
1891: xx where xx.PARTY_ID = temp.party_id
1892: and (nvl(STATUS, 'A') in ('A','I'))
1893: and exists
1894: (select 'Y' from HZ_PARTY_SITE_USES

Line 1912: or exists (select 'Y' from HZ_PARTY_SITES

1908:
1909: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1910: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1911:
1912: or exists (select 'Y' from HZ_PARTY_SITES
1913: xx where xx.PARTY_ID = temp.party_id
1914: and (nvl(STATUS, 'A') in ('A','I'))
1915: and exists
1916: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 1922: or exists (select 'Y' from HZ_PARTY_SITES

1918: and nvl(STATUS, 'A') in ('A','I')
1919: and exists
1920: (select 'Y' from OKL_TRX_AR_INVOICES_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))
1921:
1922: or exists (select 'Y' from HZ_PARTY_SITES
1923: xx where xx.PARTY_ID = temp.party_id
1924: and (nvl(STATUS, 'A') in ('A','I'))
1925: and exists
1926: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 1954: or exists (select 'Y' from HZ_PARTY_SITES

1950: and exists
1951: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B
1952: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
1953: ))
1954: or exists (select 'Y' from HZ_PARTY_SITES
1955: xx where xx.PARTY_ID = temp.party_id
1956: and (nvl(STATUS, 'A') in ('A','I'))
1957: and exists
1958: (select 'Y' from HZ_CONTACT_POINTS

Line 1960: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

1956: and (nvl(STATUS, 'A') in ('A','I'))
1957: and exists
1958: (select 'Y' from HZ_CONTACT_POINTS
1959: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1960: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1961: and exists
1962: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
1963: else
1964: delete from hz_purge_gt temp where

Line 1967: exists (select 'Y' from HZ_PARTY_SITES

1963: else
1964: delete from hz_purge_gt temp where
1965:
1966:
1967: exists (select 'Y' from HZ_PARTY_SITES
1968: xx where xx.PARTY_ID = temp.party_id
1969: and (nvl(STATUS, 'A') in ('A','I'))
1970: and exists
1971: (select 'Y' from HZ_PARTY_SITE_USES

Line 1989: or exists (select 'Y' from HZ_PARTY_SITES

1985:
1986: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1987: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1988:
1989: or exists (select 'Y' from HZ_PARTY_SITES
1990: xx where xx.PARTY_ID = temp.party_id
1991: and (nvl(STATUS, 'A') in ('A','I'))
1992: and exists
1993: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 1999: or exists (select 'Y' from HZ_PARTY_SITES

1995: and nvl(STATUS, 'A') in ('A','I')
1996: and exists
1997: (select 'Y' from OKL_TRX_AR_INVOICES_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))
1998:
1999: or exists (select 'Y' from HZ_PARTY_SITES
2000: xx where xx.PARTY_ID = temp.party_id
2001: and (nvl(STATUS, 'A') in ('A','I'))
2002: and exists
2003: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

Line 2031: or exists (select 'Y' from HZ_PARTY_SITES

2027: and exists
2028: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B
2029: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
2030: ))
2031: or exists (select 'Y' from HZ_PARTY_SITES
2032: xx where xx.PARTY_ID = temp.party_id
2033: and (nvl(STATUS, 'A') in ('A','I'))
2034: and exists
2035: (select 'Y' from HZ_CONTACT_POINTS

Line 2037: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

2033: and (nvl(STATUS, 'A') in ('A','I'))
2034: and exists
2035: (select 'Y' from HZ_CONTACT_POINTS
2036: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2037: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2038: and exists
2039: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
2040: end if;
2041:

Line 2074: or exists (select 'Y' from HZ_PARTY_SITES

2070: (select 'Y' from AP_SUPPLIER_CONTACTS
2071: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2072: ))
2073:
2074: or exists (select 'Y' from HZ_PARTY_SITES
2075: xx where xx.PARTY_ID = temp.party_id
2076: and (nvl(STATUS, 'A') in ('A','I'))
2077: and exists
2078: (select 'Y' from HZ_ORG_CONTACTS

Line 2120: or exists (select 'Y' from HZ_PARTY_SITES

2116:
2117: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2118: )
2119:
2120: or exists (select 'Y' from HZ_PARTY_SITES
2121: xx where xx.PARTY_ID = temp.party_id
2122: and (nvl(STATUS, 'A') in ('A','I'))
2123: and exists
2124: (select 'Y' from AP_SUPPLIER_CONTACTS

Line 2156: or exists (select 'Y' from HZ_PARTY_SITES

2152: (select 'Y' from AP_SUPPLIER_CONTACTS
2153: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2154: ))
2155:
2156: or exists (select 'Y' from HZ_PARTY_SITES
2157: xx where xx.PARTY_ID = temp.party_id
2158: and (nvl(STATUS, 'A') in ('A','I'))
2159: and exists
2160: (select 'Y' from HZ_ORG_CONTACTS

Line 2202: or exists (select 'Y' from HZ_PARTY_SITES

2198:
2199: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2200: )
2201:
2202: or exists (select 'Y' from HZ_PARTY_SITES
2203: xx where xx.PARTY_ID = temp.party_id
2204: and (nvl(STATUS, 'A') in ('A','I'))
2205: and exists
2206: (select 'Y' from AP_SUPPLIER_CONTACTS

Line 2369: or exists (select 'Y' from HZ_PARTY_SITES

2365:
2366: or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID = temp.party_id
2367: and (CONTACT_TYPE_CODE = 'CUST'))
2368:
2369: or exists (select 'Y' from HZ_PARTY_SITES
2370: xx where xx.PARTY_ID = temp.party_id
2371: and (nvl(STATUS, 'A') in ('A','I'))
2372: and exists
2373: (select 'Y' from JTF_TASK_REFERENCES_B

Line 2375: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))

2371: and (nvl(STATUS, 'A') in ('A','I'))
2372: and exists
2373: (select 'Y' from JTF_TASK_REFERENCES_B
2374: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2375: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2376:
2377: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2378: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2379:

Line 2380: or exists (select 'Y' from HZ_PARTY_SITES

2376:
2377: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2378: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2379:
2380: or exists (select 'Y' from HZ_PARTY_SITES
2381: xx where xx.PARTY_ID = temp.party_id
2382: and (nvl(STATUS, 'A') in ('A','I'))
2383: and exists
2384: (select 'Y' from JTF_TASKS_B

Line 2388: or exists (select 'Y' from HZ_PARTY_SITES

2384: (select 'Y' from JTF_TASKS_B
2385: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2386: ))
2387:
2388: or exists (select 'Y' from HZ_PARTY_SITES
2389: xx where xx.PARTY_ID = temp.party_id
2390: and (nvl(STATUS, 'A') in ('A','I'))
2391: and exists
2392: (select 'Y' from JTF_TASK_AUDITS_B

Line 2396: or exists (select 'Y' from HZ_PARTY_SITES

2392: (select 'Y' from JTF_TASK_AUDITS_B
2393: yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
2394: ))
2395:
2396: or exists (select 'Y' from HZ_PARTY_SITES
2397: xx where xx.PARTY_ID = temp.party_id
2398: and (nvl(STATUS, 'A') in ('A','I'))
2399: and exists
2400: (select 'Y' from JTF_TASK_AUDITS_B

Line 2411: or exists (select 'Y' from HZ_PARTY_SITES

2407: and exists
2408: (select 'Y' from JTF_TASK_PHONES
2409: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2410: ))
2411: or exists (select 'Y' from HZ_PARTY_SITES
2412: xx where xx.PARTY_ID = temp.party_id
2413: and (nvl(STATUS, 'A') in ('A','I'))
2414: and exists
2415: (select 'Y' from HZ_CONTACT_POINTS

Line 2417: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

2413: and (nvl(STATUS, 'A') in ('A','I'))
2414: and exists
2415: (select 'Y' from HZ_CONTACT_POINTS
2416: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2417: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2418: and exists
2419: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2420:
2421: or exists (select 'Y' from HZ_PARTY_SITES

Line 2421: or exists (select 'Y' from HZ_PARTY_SITES

2417: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2418: and exists
2419: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2420:
2421: or exists (select 'Y' from HZ_PARTY_SITES
2422: xx where xx.PARTY_ID = temp.party_id
2423: and (nvl(STATUS, 'A') in ('A','I'))
2424: and exists
2425: (select 'Y' from HZ_ORG_CONTACTS

Line 2461: or exists (select 'Y' from HZ_PARTY_SITES

2457: and nvl(STATUS, 'A') in ('A','I')
2458: and exists
2459: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2460:
2461: or exists (select 'Y' from HZ_PARTY_SITES
2462: xx where xx.PARTY_ID = temp.party_id
2463: and (nvl(STATUS, 'A') in ('A','I'))
2464: and exists
2465: (select 'Y' from JTF_NOTES_B

Line 2467: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

2463: and (nvl(STATUS, 'A') in ('A','I'))
2464: and exists
2465: (select 'Y' from JTF_NOTES_B
2466: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2467: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2468:
2469: or exists (select 'Y' from HZ_PARTY_SITES
2470: xx where xx.PARTY_ID = temp.party_id
2471: and (nvl(STATUS, 'A') in ('A','I'))

Line 2469: or exists (select 'Y' from HZ_PARTY_SITES

2465: (select 'Y' from JTF_NOTES_B
2466: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2467: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2468:
2469: or exists (select 'Y' from HZ_PARTY_SITES
2470: xx where xx.PARTY_ID = temp.party_id
2471: and (nvl(STATUS, 'A') in ('A','I'))
2472: and exists
2473: (select 'Y' from JTF_NOTE_CONTEXTS

Line 2475: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

2471: and (nvl(STATUS, 'A') in ('A','I'))
2472: and exists
2473: (select 'Y' from JTF_NOTE_CONTEXTS
2474: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2475: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2476:
2477: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2478: and (source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))
2479:

Line 2489: or exists (select 'Y' from HZ_PARTY_SITES

2485:
2486: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2487: and (category IN ( 'PARTY' , 'PARTNER')))
2488:
2489: or exists (select 'Y' from HZ_PARTY_SITES
2490: xx where xx.PARTY_ID = temp.party_id
2491: and (nvl(STATUS, 'A') in ('A','I'))
2492: and exists
2493: (select 'Y' from JTF_RS_RESOURCE_EXTNS

Line 2500: or exists (select 'Y' from HZ_PARTY_SITES

2496:
2497: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2498: and (ROWNUM < 2))
2499:
2500: or exists (select 'Y' from HZ_PARTY_SITES
2501: xx where xx.PARTY_ID = temp.party_id
2502: and (nvl(STATUS, 'A') in ('A','I'))
2503: and exists
2504: (select 'Y' from JTF_TERR_VALUES_ALL

Line 2520: or exists (select 'Y' from HZ_PARTY_SITES

2516:
2517: or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE = to_char(temp.party_id)
2518: and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NUMBER')))
2519:
2520: or exists (select 'Y' from HZ_PARTY_SITES
2521: xx where xx.PARTY_ID = temp.party_id
2522: and (nvl(STATUS, 'A') in ('A','I'))
2523: and exists
2524: (select 'Y' from JTF_RS_RESOURCE_EXTNS

Line 2528: or exists (select 'Y' from HZ_PARTY_SITES

2524: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2525: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2526: ))
2527:
2528: or exists (select 'Y' from HZ_PARTY_SITES
2529: xx where xx.PARTY_ID = temp.party_id
2530: and (nvl(STATUS, 'A') in ('A','I'))
2531: and exists
2532: (select 'Y' from JTF_TTY_NAMED_ACCTS

Line 2563: or exists (select 'Y' from HZ_PARTY_SITES

2559:
2560: or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID = temp.party_id
2561: and (CONTACT_TYPE_CODE = 'CUST'))
2562:
2563: or exists (select 'Y' from HZ_PARTY_SITES
2564: xx where xx.PARTY_ID = temp.party_id
2565: and (nvl(STATUS, 'A') in ('A','I'))
2566: and exists
2567: (select 'Y' from JTF_TASK_REFERENCES_B

Line 2569: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))

2565: and (nvl(STATUS, 'A') in ('A','I'))
2566: and exists
2567: (select 'Y' from JTF_TASK_REFERENCES_B
2568: yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
2569: and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))
2570:
2571: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2572: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2573:

Line 2574: or exists (select 'Y' from HZ_PARTY_SITES

2570:
2571: or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID = temp.party_id
2572: and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))
2573:
2574: or exists (select 'Y' from HZ_PARTY_SITES
2575: xx where xx.PARTY_ID = temp.party_id
2576: and (nvl(STATUS, 'A') in ('A','I'))
2577: and exists
2578: (select 'Y' from JTF_TASKS_B

Line 2582: or exists (select 'Y' from HZ_PARTY_SITES

2578: (select 'Y' from JTF_TASKS_B
2579: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2580: ))
2581:
2582: or exists (select 'Y' from HZ_PARTY_SITES
2583: xx where xx.PARTY_ID = temp.party_id
2584: and (nvl(STATUS, 'A') in ('A','I'))
2585: and exists
2586: (select 'Y' from JTF_TASK_AUDITS_B

Line 2590: or exists (select 'Y' from HZ_PARTY_SITES

2586: (select 'Y' from JTF_TASK_AUDITS_B
2587: yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
2588: ))
2589:
2590: or exists (select 'Y' from HZ_PARTY_SITES
2591: xx where xx.PARTY_ID = temp.party_id
2592: and (nvl(STATUS, 'A') in ('A','I'))
2593: and exists
2594: (select 'Y' from JTF_TASK_AUDITS_B

Line 2605: or exists (select 'Y' from HZ_PARTY_SITES

2601: and exists
2602: (select 'Y' from JTF_TASK_PHONES
2603: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2604: ))
2605: or exists (select 'Y' from HZ_PARTY_SITES
2606: xx where xx.PARTY_ID = temp.party_id
2607: and (nvl(STATUS, 'A') in ('A','I'))
2608: and exists
2609: (select 'Y' from HZ_CONTACT_POINTS

Line 2611: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')

2607: and (nvl(STATUS, 'A') in ('A','I'))
2608: and exists
2609: (select 'Y' from HZ_CONTACT_POINTS
2610: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2611: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2612: and exists
2613: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2614:
2615: or exists (select 'Y' from HZ_PARTY_SITES

Line 2615: or exists (select 'Y' from HZ_PARTY_SITES

2611: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2612: and exists
2613: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2614:
2615: or exists (select 'Y' from HZ_PARTY_SITES
2616: xx where xx.PARTY_ID = temp.party_id
2617: and (nvl(STATUS, 'A') in ('A','I'))
2618: and exists
2619: (select 'Y' from HZ_ORG_CONTACTS

Line 2655: or exists (select 'Y' from HZ_PARTY_SITES

2651: and nvl(STATUS, 'A') in ('A','I')
2652: and exists
2653: (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
2654:
2655: or exists (select 'Y' from HZ_PARTY_SITES
2656: xx where xx.PARTY_ID = temp.party_id
2657: and (nvl(STATUS, 'A') in ('A','I'))
2658: and exists
2659: (select 'Y' from JTF_NOTES_B

Line 2661: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

2657: and (nvl(STATUS, 'A') in ('A','I'))
2658: and exists
2659: (select 'Y' from JTF_NOTES_B
2660: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2661: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2662:
2663: or exists (select 'Y' from HZ_PARTY_SITES
2664: xx where xx.PARTY_ID = temp.party_id
2665: and (nvl(STATUS, 'A') in ('A','I'))

Line 2663: or exists (select 'Y' from HZ_PARTY_SITES

2659: (select 'Y' from JTF_NOTES_B
2660: yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
2661: and source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2662:
2663: or exists (select 'Y' from HZ_PARTY_SITES
2664: xx where xx.PARTY_ID = temp.party_id
2665: and (nvl(STATUS, 'A') in ('A','I'))
2666: and exists
2667: (select 'Y' from JTF_NOTE_CONTEXTS

Line 2669: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

2665: and (nvl(STATUS, 'A') in ('A','I'))
2666: and exists
2667: (select 'Y' from JTF_NOTE_CONTEXTS
2668: yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
2669: and NOTE_CONTEXT_TYPE IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))
2670:
2671: or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID = temp.party_id
2672: and (source_object_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))
2673:

Line 2683: or exists (select 'Y' from HZ_PARTY_SITES

2679:
2680: or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID = temp.party_id
2681: and (category IN ( 'PARTY' , 'PARTNER')))
2682:
2683: or exists (select 'Y' from HZ_PARTY_SITES
2684: xx where xx.PARTY_ID = temp.party_id
2685: and (nvl(STATUS, 'A') in ('A','I'))
2686: and exists
2687: (select 'Y' from JTF_RS_RESOURCE_EXTNS

Line 2694: or exists (select 'Y' from HZ_PARTY_SITES

2690:
2691: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2692: and (ROWNUM < 2))
2693:
2694: or exists (select 'Y' from HZ_PARTY_SITES
2695: xx where xx.PARTY_ID = temp.party_id
2696: and (nvl(STATUS, 'A') in ('A','I'))
2697: and exists
2698: (select 'Y' from JTF_TERR_VALUES_ALL

Line 2714: or exists (select 'Y' from HZ_PARTY_SITES

2710:
2711: or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE = to_char(temp.party_id)
2712: and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NUMBER')))
2713:
2714: or exists (select 'Y' from HZ_PARTY_SITES
2715: xx where xx.PARTY_ID = temp.party_id
2716: and (nvl(STATUS, 'A') in ('A','I'))
2717: and exists
2718: (select 'Y' from JTF_RS_RESOURCE_EXTNS

Line 2722: or exists (select 'Y' from HZ_PARTY_SITES

2718: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2719: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2720: ))
2721:
2722: or exists (select 'Y' from HZ_PARTY_SITES
2723: xx where xx.PARTY_ID = temp.party_id
2724: and (nvl(STATUS, 'A') in ('A','I'))
2725: and exists
2726: (select 'Y' from JTF_TTY_NAMED_ACCTS

Line 2805: or exists (select 'Y' from HZ_PARTY_SITES

2801:
2802: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2803: and (CONTACT_TYPE <> 'EMPLOYEE'))
2804:
2805: or exists (select 'Y' from HZ_PARTY_SITES
2806: xx where xx.PARTY_ID = temp.party_id
2807: and (nvl(STATUS, 'A') in ('A','I'))
2808: and exists
2809: (select 'Y' from CS_ESTIMATE_DETAILS

Line 2813: or exists (select 'Y' from HZ_PARTY_SITES

2809: (select 'Y' from CS_ESTIMATE_DETAILS
2810: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2811: ))
2812:
2813: or exists (select 'Y' from HZ_PARTY_SITES
2814: xx where xx.PARTY_ID = temp.party_id
2815: and (nvl(STATUS, 'A') in ('A','I'))
2816: and exists
2817: (select 'Y' from CS_ESTIMATE_DETAILS

Line 2830: or exists (select 'Y' from HZ_PARTY_SITES

2826:
2827: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2828: and (CONTACT_TYPE <> 'EMPLOYEE'))
2829:
2830: or exists (select 'Y' from HZ_PARTY_SITES
2831: xx where xx.PARTY_ID = temp.party_id
2832: and (nvl(STATUS, 'A') in ('A','I'))
2833: and exists
2834: (select 'Y' from CS_ESTIMATE_DETAILS

Line 2838: or exists (select 'Y' from HZ_PARTY_SITES

2834: (select 'Y' from CS_ESTIMATE_DETAILS
2835: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2836: ))
2837:
2838: or exists (select 'Y' from HZ_PARTY_SITES
2839: xx where xx.PARTY_ID = temp.party_id
2840: and (nvl(STATUS, 'A') in ('A','I'))
2841: and exists
2842: (select 'Y' from CS_ESTIMATE_DETAILS

Line 2857: or exists (select 'Y' from HZ_PARTY_SITES

2853:
2854: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2855: and ((pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1' OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16' OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3' OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
2856:
2857: or exists (select 'Y' from HZ_PARTY_SITES
2858: xx where xx.PARTY_ID = temp.party_id
2859: and (nvl(STATUS, 'A') in ('A','I'))
2860: and exists
2861: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

Line 2871: or exists (select 'Y' from HZ_PARTY_SITES

2867:
2868: exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM = to_char(temp.party_id)
2869: and ((pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1' OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16' OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3' OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))
2870:
2871: or exists (select 'Y' from HZ_PARTY_SITES
2872: xx where xx.PARTY_ID = temp.party_id
2873: and (nvl(STATUS, 'A') in ('A','I'))
2874: and exists
2875: (select 'Y' from OE_PRICE_ADJ_ATTRIBS

Line 2924: or exists (select 'Y' from HZ_PARTY_SITES

2920:
2921: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id
2922: )
2923:
2924: or exists (select 'Y' from HZ_PARTY_SITES
2925: xx where xx.PARTY_ID = temp.party_id
2926: and (nvl(STATUS, 'A') in ('A','I'))
2927: and exists
2928: (select 'Y' from INL_CHARGE_LINES

Line 2938: or exists (select 'Y' from HZ_PARTY_SITES

2934:
2935: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id
2936: )
2937:
2938: or exists (select 'Y' from HZ_PARTY_SITES
2939: xx where xx.PARTY_ID = temp.party_id
2940: and (nvl(STATUS, 'A') in ('A','I'))
2941: and exists
2942: (select 'Y' from INL_CHARGE_LINES

Line 2993: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

2989: appid:=665;
2990: if(regid_proc = true) then
2991: insert into hz_application_trans_gt(app_id,party_id) select 665, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 665 and appl.party_id=temp.party_id) and
2992:
2993: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
2994: xx
2995: where (nvl(STATUS, 'A') in ('A','I'))
2996: and xx.PARTY_SITE_ID
2997: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V

Line 3002: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

2998: yy
2999: ));
3000: else
3001: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3002: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3003: xx
3004: where (nvl(STATUS, 'A') in ('A','I'))
3005: and xx.PARTY_SITE_ID
3006: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V

Line 3507: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3503: appid:=435;
3504: if(regid_proc = true) then
3505: insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and
3506:
3507: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3508: xx
3509: where (nvl(STATUS, 'A') in ('A','I'))
3510: and xx.PARTY_SITE_ID
3511: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS

Line 3516: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3512: yy
3513: ));
3514: else
3515: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3516: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3517: xx
3518: where (nvl(STATUS, 'A') in ('A','I'))
3519: and xx.PARTY_SITE_ID
3520: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS

Line 3609: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3605: appid:=177;
3606: if(regid_proc = true) then
3607: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3608:
3609: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3610: xx
3611: where (nvl(STATUS, 'A') in ('A','I'))
3612: and xx.PARTY_SITE_ID
3613: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V

Line 3618: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3614: yy
3615: ));
3616: else
3617: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3618: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3619: xx
3620: where (nvl(STATUS, 'A') in ('A','I'))
3621: and xx.PARTY_SITE_ID
3622: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V

Line 3691: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3687: appid:=542;
3688: if(regid_proc = true) then
3689: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and
3690:
3691: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3692: xx
3693: where (nvl(STATUS, 'A') in ('A','I'))
3694: and xx.PARTY_SITE_ID
3695: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES

Line 3700: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3696: yy
3697: ));
3698: else
3699: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3700: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3701: xx
3702: where (nvl(STATUS, 'A') in ('A','I'))
3703: and xx.PARTY_SITE_ID
3704: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES

Line 3713: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3709: appid:=542;
3710: if(regid_proc = true) then
3711: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and
3712:
3713: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3714: xx
3715: where (nvl(STATUS, 'A') in ('A','I'))
3716: and xx.PARTY_SITE_ID
3717: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES

Line 3722: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3718: yy
3719: ));
3720: else
3721: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3722: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3723: xx
3724: where (nvl(STATUS, 'A') in ('A','I'))
3725: and xx.PARTY_SITE_ID
3726: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES

Line 3735: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3731: appid:=542;
3732: if(regid_proc = true) then
3733: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and
3734:
3735: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3736: xx
3737: where (nvl(STATUS, 'A') in ('A','I'))
3738: and xx.PARTY_SITE_ID
3739: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS

Line 3744: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3740: yy
3741: ));
3742: else
3743: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3744: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3745: xx
3746: where (nvl(STATUS, 'A') in ('A','I'))
3747: and xx.PARTY_SITE_ID
3748: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS

Line 3793: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3789: appid:=697;
3790: if(regid_proc = true) then
3791: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3792:
3793: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3794: xx
3795: where (nvl(STATUS, 'A') in ('A','I'))
3796: and xx.PARTY_SITE_ID
3797: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

Line 3802: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3798: yy
3799: ));
3800: else
3801: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3802: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3803: xx
3804: where (nvl(STATUS, 'A') in ('A','I'))
3805: and xx.PARTY_SITE_ID
3806: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

Line 3815: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3811: appid:=697;
3812: if(regid_proc = true) then
3813: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3814:
3815: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3816: xx
3817: where (nvl(STATUS, 'A') in ('A','I'))
3818: and xx.PARTY_SITE_ID
3819: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

Line 3824: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3820: yy
3821: ));
3822: else
3823: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3824: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3825: xx
3826: where (nvl(STATUS, 'A') in ('A','I'))
3827: and xx.PARTY_SITE_ID
3828: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

Line 3849: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3845: appid:=697;
3846: if(regid_proc = true) then
3847: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3848:
3849: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3850: xx
3851: where (nvl(STATUS, 'A') in ('A','I'))
3852: and xx.PARTY_SITE_ID
3853: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

Line 3858: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3854: yy
3855: ));
3856: else
3857: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3858: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3859: xx
3860: where (nvl(STATUS, 'A') in ('A','I'))
3861: and xx.PARTY_SITE_ID
3862: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

Line 3979: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3975: appid:=279;
3976: if(regid_proc = true) then
3977: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3978:
3979: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3980: xx
3981: where (nvl(STATUS, 'A') in ('A','I'))
3982: and xx.PARTY_SITE_ID
3983: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG

Line 3988: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

3984: yy
3985: ));
3986: else
3987: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3988: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3989: xx
3990: where (nvl(STATUS, 'A') in ('A','I'))
3991: and xx.PARTY_SITE_ID
3992: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG

Line 4469: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4465: appid:=540;
4466: if(regid_proc = true) then
4467: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4468:
4469: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4470: xx
4471: where (nvl(STATUS, 'A') in ('A','I'))
4472: and to_char(xx.PARTY_SITE_ID)
4473: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B

Line 4478: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4474: yy
4475: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4476: else
4477: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4478: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4479: xx
4480: where (nvl(STATUS, 'A') in ('A','I'))
4481: and to_char(xx.PARTY_SITE_ID)
4482: in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_ALL_B

Line 4491: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4487: appid:=540;
4488: if(regid_proc = true) then
4489: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4490:
4491: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4492: xx
4493: where (nvl(STATUS, 'A') in ('A','I'))
4494: and xx.PARTY_SITE_ID
4495: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B

Line 4500: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4496: yy
4497: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4498: else
4499: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4500: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4501: xx
4502: where (nvl(STATUS, 'A') in ('A','I'))
4503: and xx.PARTY_SITE_ID
4504: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B

Line 4513: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4509: appid:=540;
4510: if(regid_proc = true) then
4511: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4512:
4513: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4514: xx
4515: where (nvl(STATUS, 'A') in ('A','I'))
4516: and xx.PARTY_SITE_ID
4517: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B

Line 4522: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4518: yy
4519: where IPY_TYPE = 'THIRD_PARTY_POLICY'));
4520: else
4521: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4522: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4523: xx
4524: where (nvl(STATUS, 'A') in ('A','I'))
4525: and xx.PARTY_SITE_ID
4526: in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_ALL_B

Line 4547: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4543: appid:=540;
4544: if(regid_proc = true) then
4545: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4546:
4547: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4548: xx
4549: where (nvl(STATUS, 'A') in ('A','I'))
4550: and to_char(xx.PARTY_SITE_ID)
4551: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B

Line 4556: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4552: yy
4553: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4554: else
4555: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4556: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4557: xx
4558: where (nvl(STATUS, 'A') in ('A','I'))
4559: and to_char(xx.PARTY_SITE_ID)
4560: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_K_PARTY_ROLES_B

Line 4605: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4601: appid:=540;
4602: if(regid_proc = true) then
4603: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4604:
4605: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4606: xx
4607: where (nvl(STATUS, 'A') in ('A','I'))
4608: and xx.PARTY_SITE_ID
4609: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B

Line 4614: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4610: yy
4611: ));
4612: else
4613: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4614: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4615: xx
4616: where (nvl(STATUS, 'A') in ('A','I'))
4617: and xx.PARTY_SITE_ID
4618: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B

Line 4627: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4623: appid:=540;
4624: if(regid_proc = true) then
4625: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4626:
4627: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4628: xx
4629: where (nvl(STATUS, 'A') in ('A','I'))
4630: and xx.PARTY_SITE_ID
4631: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B

Line 4636: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4632: yy
4633: ));
4634: else
4635: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4636: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4637: xx
4638: where (nvl(STATUS, 'A') in ('A','I'))
4639: and xx.PARTY_SITE_ID
4640: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B

Line 4661: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4657: appid:=540;
4658: if(regid_proc = true) then
4659: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4660:
4661: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4662: xx
4663: where (nvl(STATUS, 'A') in ('A','I'))
4664: and xx.PARTY_SITE_ID
4665: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

Line 4670: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4666: yy
4667: ));
4668: else
4669: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4670: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4671: xx
4672: where (nvl(STATUS, 'A') in ('A','I'))
4673: and xx.PARTY_SITE_ID
4674: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

Line 4695: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4691: appid:=540;
4692: if(regid_proc = true) then
4693: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4694:
4695: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4696: xx
4697: where (nvl(STATUS, 'A') in ('A','I'))
4698: and xx.PARTY_SITE_ID
4699: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

Line 4704: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4700: yy
4701: ));
4702: else
4703: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4704: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4705: xx
4706: where (nvl(STATUS, 'A') in ('A','I'))
4707: and xx.PARTY_SITE_ID
4708: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES

Line 4729: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4725: appid:=540;
4726: if(regid_proc = true) then
4727: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4728:
4729: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4730: xx
4731: where (nvl(STATUS, 'A') in ('A','I'))
4732: and xx.PARTY_SITE_ID
4733: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

Line 4738: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4734: yy
4735: ));
4736: else
4737: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4738: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4739: xx
4740: where (nvl(STATUS, 'A') in ('A','I'))
4741: and xx.PARTY_SITE_ID
4742: in (select /*+ parallel(yy)*/ yy.BILL_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

Line 4763: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4759: appid:=540;
4760: if(regid_proc = true) then
4761: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4762:
4763: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4764: xx
4765: where (nvl(STATUS, 'A') in ('A','I'))
4766: and xx.PARTY_SITE_ID
4767: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

Line 4772: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4768: yy
4769: ));
4770: else
4771: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4772: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4773: xx
4774: where (nvl(STATUS, 'A') in ('A','I'))
4775: and xx.PARTY_SITE_ID
4776: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T

Line 4809: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4805: appid:=540;
4806: if(regid_proc = true) then
4807: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4808:
4809: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4810: xx
4811: where (nvl(STATUS, 'A') in ('A','I'))
4812: and to_char(xx.PARTY_SITE_ID)
4813: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_RULES_B

Line 4818: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4814: yy
4815: where JTOT_OBJECT1_CODE = 'OKL_PARTYSITE' AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS)));
4816: else
4817: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4818: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4819: xx
4820: where (nvl(STATUS, 'A') in ('A','I'))
4821: and to_char(xx.PARTY_SITE_ID)
4822: in (select /*+ parallel(yy)*/ yy.OBJECT1_ID1 from OKC_RULES_B

Line 4903: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4899: appid:=200;
4900: if(regid_proc = true) then
4901: insert into hz_application_trans_gt(app_id,party_id) select 200, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 200 and appl.party_id=temp.party_id) and
4902:
4903: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4904: xx
4905: where (nvl(STATUS, 'A') in ('A','I'))
4906: and xx.PARTY_SITE_ID
4907: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL

Line 4912: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

4908: yy
4909: ));
4910: else
4911: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4912: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4913: xx
4914: where (nvl(STATUS, 'A') in ('A','I'))
4915: and xx.PARTY_SITE_ID
4916: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL

Line 5069: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5065: appid:=515;
5066: if(regid_proc = true) then
5067: insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 515 and appl.party_id=temp.party_id) and
5068:
5069: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5070: xx
5071: where (nvl(STATUS, 'A') in ('A','I'))
5072: and to_char(xx.PARTY_SITE_ID)
5073: in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS

Line 5078: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5074: yy
5075: where (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
5076: else
5077: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5078: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5079: xx
5080: where (nvl(STATUS, 'A') in ('A','I'))
5081: and to_char(xx.PARTY_SITE_ID)
5082: in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS

Line 5115: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5111: appid:=170;
5112: if(regid_proc = true) then
5113: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5114:
5115: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5116: xx
5117: where (nvl(STATUS, 'A') in ('A','I'))
5118: and xx.PARTY_SITE_ID
5119: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B

Line 5124: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5120: yy
5121: ));
5122: else
5123: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5124: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5125: xx
5126: where (nvl(STATUS, 'A') in ('A','I'))
5127: and xx.PARTY_SITE_ID
5128: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B

Line 5137: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5133: appid:=170;
5134: if(regid_proc = true) then
5135: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5136:
5137: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5138: xx
5139: where (nvl(STATUS, 'A') in ('A','I'))
5140: and xx.PARTY_SITE_ID
5141: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B

Line 5146: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5142: yy
5143: ));
5144: else
5145: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5146: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5147: xx
5148: where (nvl(STATUS, 'A') in ('A','I'))
5149: and xx.PARTY_SITE_ID
5150: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B

Line 5159: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5155: appid:=170;
5156: if(regid_proc = true) then
5157: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5158:
5159: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5160: xx
5161: where (nvl(STATUS, 'A') in ('A','I'))
5162: and xx.PARTY_SITE_ID
5163: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B

Line 5168: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5164: yy
5165: ));
5166: else
5167: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5168: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5169: xx
5170: where (nvl(STATUS, 'A') in ('A','I'))
5171: and xx.PARTY_SITE_ID
5172: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B

Line 5181: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5177: appid:=170;
5178: if(regid_proc = true) then
5179: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5180:
5181: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5182: xx
5183: where (nvl(STATUS, 'A') in ('A','I'))
5184: and xx.PARTY_SITE_ID
5185: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B

Line 5190: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5186: yy
5187: ));
5188: else
5189: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5190: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5191: xx
5192: where (nvl(STATUS, 'A') in ('A','I'))
5193: and xx.PARTY_SITE_ID
5194: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B

Line 5203: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5199: appid:=170;
5200: if(regid_proc = true) then
5201: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5202:
5203: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5204: xx
5205: where (nvl(STATUS, 'A') in ('A','I'))
5206: and xx.PARTY_SITE_ID
5207: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B

Line 5212: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5208: yy
5209: ));
5210: else
5211: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5212: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5213: xx
5214: where (nvl(STATUS, 'A') in ('A','I'))
5215: and xx.PARTY_SITE_ID
5216: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B

Line 5297: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5293: appid:=170;
5294: if(regid_proc = true) then
5295: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5296:
5297: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5298: xx
5299: where (nvl(STATUS, 'A') in ('A','I'))
5300: and xx.PARTY_SITE_ID
5301: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B

Line 5306: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5302: yy
5303: ));
5304: else
5305: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5306: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5307: xx
5308: where (nvl(STATUS, 'A') in ('A','I'))
5309: and xx.PARTY_SITE_ID
5310: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B

Line 5319: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5315: appid:=170;
5316: if(regid_proc = true) then
5317: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5318:
5319: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5320: xx
5321: where (nvl(STATUS, 'A') in ('A','I'))
5322: and xx.PARTY_SITE_ID
5323: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B

Line 5328: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5324: yy
5325: ));
5326: else
5327: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5328: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5329: xx
5330: where (nvl(STATUS, 'A') in ('A','I'))
5331: and xx.PARTY_SITE_ID
5332: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B

Line 5341: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5337: appid:=170;
5338: if(regid_proc = true) then
5339: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5340:
5341: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5342: xx
5343: where (nvl(STATUS, 'A') in ('A','I'))
5344: and xx.PARTY_SITE_ID
5345: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B

Line 5350: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5346: yy
5347: ));
5348: else
5349: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5350: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5351: xx
5352: where (nvl(STATUS, 'A') in ('A','I'))
5353: and xx.PARTY_SITE_ID
5354: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B

Line 5363: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5359: appid:=174;
5360: if(regid_proc = true) then
5361: insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 174 and appl.party_id=temp.party_id) and
5362:
5363: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5364: xx
5365: where (nvl(STATUS, 'A') in ('A','I'))
5366: and xx.PARTY_SITE_ID
5367: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS

Line 5372: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5368: yy
5369: ));
5370: else
5371: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5372: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5373: xx
5374: where (nvl(STATUS, 'A') in ('A','I'))
5375: and xx.PARTY_SITE_ID
5376: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS

Line 5409: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5405: appid:=204;
5406: if(regid_proc = true) then
5407: insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and
5408:
5409: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5410: xx
5411: where (nvl(STATUS, 'A') in ('A','I'))
5412: and xx.PARTY_SITE_ID
5413: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS

Line 5418: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5414: yy
5415: ));
5416: else
5417: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5418: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5419: xx
5420: where (nvl(STATUS, 'A') in ('A','I'))
5421: and xx.PARTY_SITE_ID
5422: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS

Line 5431: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5427: appid:=204;
5428: if(regid_proc = true) then
5429: insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and
5430:
5431: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5432: xx
5433: where (nvl(STATUS, 'A') in ('A','I'))
5434: and xx.PARTY_SITE_ID
5435: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS

Line 5440: temp.party_id in (select /+ parallel (xx)/ xx.PARTY_ID from HZ_PARTY_SITES

5436: yy
5437: ));
5438: else
5439: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5440: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5441: xx
5442: where (nvl(STATUS, 'A') in ('A','I'))
5443: and xx.PARTY_SITE_ID
5444: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS