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 OKC_RULES_B

Line 868: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

864:
865: or exists (select 'Y' from OKC_CONTACTS 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_CONTACTS')))
867:
868: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
869: 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')))
870:
871: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
872: 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_PARTY')))

Line 871: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)

867:
868: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
869: 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')))
870:
871: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
872: 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_PARTY')))
873:
874: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
875: 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')))

Line 874: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)

870:
871: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
872: 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_PARTY')))
873:
874: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
875: 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')))
876:
877: or exists (select 'Y' from HZ_PARTY_SITES
878: xx where xx.PARTY_ID = temp.party_id

Line 881: (select 'Y' from OKC_RULES_B

877: or exists (select 'Y' from HZ_PARTY_SITES
878: xx where xx.PARTY_ID = temp.party_id
879: and (nvl(STATUS, 'A') in ('A','I'))
880: and exists
881: (select 'Y' from OKC_RULES_B
882: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
883: 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')))
884:
885: or exists (select 'Y' from HZ_PARTY_SITES

Line 889: (select 'Y' from OKC_RULES_B

885: or exists (select 'Y' from HZ_PARTY_SITES
886: xx where xx.PARTY_ID = temp.party_id
887: and (nvl(STATUS, 'A') in ('A','I'))
888: and exists
889: (select 'Y' from OKC_RULES_B
890: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
891: 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')))
892:
893: or exists (select 'Y' from HZ_PARTY_SITES

Line 897: (select 'Y' from OKC_RULES_B

893: or exists (select 'Y' from HZ_PARTY_SITES
894: xx where xx.PARTY_ID = temp.party_id
895: and (nvl(STATUS, 'A') in ('A','I'))
896: and exists
897: (select 'Y' from OKC_RULES_B
898: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
899: 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')))
900:
901: or exists (select 'Y' from HZ_PARTY_SITES

Line 909: (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'))))

905: (select 'Y' from HZ_PARTY_SITE_USES
906: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
907: and nvl(STATUS, 'A') in ('A','I')
908: and exists
909: (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'))))
910:
911: or exists (select 'Y' from HZ_PARTY_SITES
912: xx where xx.PARTY_ID = temp.party_id
913: and (nvl(STATUS, 'A') in ('A','I'))

Line 919: (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'))))

915: (select 'Y' from HZ_PARTY_SITE_USES
916: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
917: and nvl(STATUS, 'A') in ('A','I')
918: and exists
919: (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'))))
920:
921: or exists (select 'Y' from HZ_PARTY_SITES
922: xx where xx.PARTY_ID = temp.party_id
923: and (nvl(STATUS, 'A') in ('A','I'))

Line 929: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) 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_USE'))))

925: (select 'Y' from HZ_PARTY_SITE_USES
926: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
927: and nvl(STATUS, 'A') in ('A','I')
928: and exists
929: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) 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_USE'))))
930:
931: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
932: 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')))
933:

Line 961: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)

957:
958: or exists (select 'Y' from OKC_CONTACTS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
959: 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_CONTACTS')))
960:
961: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
962: 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')))
963:
964: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
965: 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_PARTY')))

Line 964: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)

960:
961: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
962: 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')))
963:
964: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
965: 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_PARTY')))
966:
967: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
968: 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')))

Line 967: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)

963:
964: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 = to_char(temp.party_id)
965: 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_PARTY')))
966:
967: or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 = to_char(temp.party_id)
968: 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')))
969:
970: or exists (select 'Y' from HZ_PARTY_SITES
971: xx where xx.PARTY_ID = temp.party_id

Line 974: (select 'Y' from OKC_RULES_B

970: or exists (select 'Y' from HZ_PARTY_SITES
971: xx where xx.PARTY_ID = temp.party_id
972: and (nvl(STATUS, 'A') in ('A','I'))
973: and exists
974: (select 'Y' from OKC_RULES_B
975: yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
976: 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')))
977:
978: or exists (select 'Y' from HZ_PARTY_SITES

Line 982: (select 'Y' from OKC_RULES_B

978: or exists (select 'Y' from HZ_PARTY_SITES
979: xx where xx.PARTY_ID = temp.party_id
980: and (nvl(STATUS, 'A') in ('A','I'))
981: and exists
982: (select 'Y' from OKC_RULES_B
983: yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
984: 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')))
985:
986: or exists (select 'Y' from HZ_PARTY_SITES

Line 990: (select 'Y' from OKC_RULES_B

986: or exists (select 'Y' from HZ_PARTY_SITES
987: xx where xx.PARTY_ID = temp.party_id
988: and (nvl(STATUS, 'A') in ('A','I'))
989: and exists
990: (select 'Y' from OKC_RULES_B
991: yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
992: 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')))
993:
994: or exists (select 'Y' from HZ_PARTY_SITES

Line 1002: (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'))))

998: (select 'Y' from HZ_PARTY_SITE_USES
999: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1000: and nvl(STATUS, 'A') in ('A','I')
1001: and exists
1002: (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'))))
1003:
1004: or exists (select 'Y' from HZ_PARTY_SITES
1005: xx where xx.PARTY_ID = temp.party_id
1006: and (nvl(STATUS, 'A') in ('A','I'))

Line 1012: (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'))))

1008: (select 'Y' from HZ_PARTY_SITE_USES
1009: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1010: and nvl(STATUS, 'A') in ('A','I')
1011: and exists
1012: (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'))))
1013:
1014: or exists (select 'Y' from HZ_PARTY_SITES
1015: xx where xx.PARTY_ID = temp.party_id
1016: and (nvl(STATUS, 'A') in ('A','I'))

Line 1022: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) 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_USE'))))

1018: (select 'Y' from HZ_PARTY_SITE_USES
1019: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1020: and nvl(STATUS, 'A') in ('A','I')
1021: and exists
1022: (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) 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_USE'))))
1023:
1024: or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 = to_char(temp.party_id)
1025: 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')))
1026: