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.IEU_WPACTIONS_PVT dependencies on HZ_PARTIES

Line 981: from hz_relationships a, hz_parties b

977:
978: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
979: l_continue := 0;
980: select count(a.object_id) into l_continue
981: from hz_relationships a, hz_parties b
982: where b.party_type = 'PARTY_RELATIONSHIP'
983: and a.party_id in (select source_object_id
984: from jtf_tasks_b
985: where task_id = l_task_rec_tbl(i).id)

Line 987: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

983: and a.party_id in (select source_object_id
984: from jtf_tasks_b
985: where task_id = l_task_rec_tbl(i).id)
986: and a.party_id = b.party_id
987: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
988: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
989: AND DIRECTIONAL_FLAG = 'F';
990:
991: if (l_continue > 0) then

Line 988: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

984: from jtf_tasks_b
985: where task_id = l_task_rec_tbl(i).id)
986: and a.party_id = b.party_id
987: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
988: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
989: AND DIRECTIONAL_FLAG = 'F';
990:
991: if (l_continue > 0) then
992: select a.object_id into l_note_context_type_id

Line 993: from hz_relationships a, hz_parties b

989: AND DIRECTIONAL_FLAG = 'F';
990:
991: if (l_continue > 0) then
992: select a.object_id into l_note_context_type_id
993: from hz_relationships a, hz_parties b
994: where b.party_type = 'PARTY_RELATIONSHIP'
995: and a.party_id in (select source_object_id
996: from jtf_tasks_b
997: where task_id = l_task_rec_tbl(i).id)

Line 999: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

995: and a.party_id in (select source_object_id
996: from jtf_tasks_b
997: where task_id = l_task_rec_tbl(i).id)
998: and a.party_id = b.party_id
999: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1000: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1001: AND DIRECTIONAL_FLAG = 'F';
1002:
1003: else l_note_context_type_id :=null;

Line 1000: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

996: from jtf_tasks_b
997: where task_id = l_task_rec_tbl(i).id)
998: and a.party_id = b.party_id
999: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1000: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1001: AND DIRECTIONAL_FLAG = 'F';
1002:
1003: else l_note_context_type_id :=null;
1004: end if ;

Line 1045: from hz_relationships a, hz_parties b

1041:
1042: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1043: l_continue := 0;
1044: select count(a.subject_id) into l_continue
1045: from hz_relationships a, hz_parties b
1046: where b.party_type = 'PARTY_RELATIONSHIP'
1047: and a.party_id = (select source_object_id
1048: from jtf_tasks_b
1049: where task_id = l_task_rec_tbl(i).id)

Line 1051: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1047: and a.party_id = (select source_object_id
1048: from jtf_tasks_b
1049: where task_id = l_task_rec_tbl(i).id)
1050: and a.party_id = b.party_id
1051: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1052: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1053: AND DIRECTIONAL_FLAG = 'F';
1054:
1055: if (l_continue > 0) then

Line 1052: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1048: from jtf_tasks_b
1049: where task_id = l_task_rec_tbl(i).id)
1050: and a.party_id = b.party_id
1051: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1052: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1053: AND DIRECTIONAL_FLAG = 'F';
1054:
1055: if (l_continue > 0) then
1056: select a.subject_id into l_note_context_type_id

Line 1057: from hz_relationships a, hz_parties b

1053: AND DIRECTIONAL_FLAG = 'F';
1054:
1055: if (l_continue > 0) then
1056: select a.subject_id into l_note_context_type_id
1057: from hz_relationships a, hz_parties b
1058: where b.party_type = 'PARTY_RELATIONSHIP'
1059: and a.party_id = (select source_object_id
1060: from jtf_tasks_b
1061: where task_id = l_task_rec_tbl(i).id)

Line 1063: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1059: and a.party_id = (select source_object_id
1060: from jtf_tasks_b
1061: where task_id = l_task_rec_tbl(i).id)
1062: and a.party_id = b.party_id
1063: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1064: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1065: AND DIRECTIONAL_FLAG = 'F';
1066:
1067: else l_note_context_type_id := null;

Line 1064: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1060: from jtf_tasks_b
1061: where task_id = l_task_rec_tbl(i).id)
1062: and a.party_id = b.party_id
1063: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1064: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1065: AND DIRECTIONAL_FLAG = 'F';
1066:
1067: else l_note_context_type_id := null;
1068: end if;