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 962: from hz_relationships a, hz_parties b

958:
959: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
960: l_continue := 0;
961: select count(a.object_id) into l_continue
962: from hz_relationships a, hz_parties b
963: where b.party_type = 'PARTY_RELATIONSHIP'
964: and a.party_id in (select source_object_id
965: from jtf_tasks_b
966: where task_id = l_task_rec_tbl(i).id)

Line 968: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

964: and a.party_id in (select source_object_id
965: from jtf_tasks_b
966: where task_id = l_task_rec_tbl(i).id)
967: and a.party_id = b.party_id
968: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
969: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
970: AND DIRECTIONAL_FLAG = 'F';
971:
972: if (l_continue > 0) then

Line 969: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

965: from jtf_tasks_b
966: where task_id = l_task_rec_tbl(i).id)
967: and a.party_id = b.party_id
968: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
969: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
970: AND DIRECTIONAL_FLAG = 'F';
971:
972: if (l_continue > 0) then
973: select a.object_id into l_note_context_type_id

Line 974: from hz_relationships a, hz_parties b

970: AND DIRECTIONAL_FLAG = 'F';
971:
972: if (l_continue > 0) then
973: select a.object_id into l_note_context_type_id
974: from hz_relationships a, hz_parties b
975: where b.party_type = 'PARTY_RELATIONSHIP'
976: and a.party_id in (select source_object_id
977: from jtf_tasks_b
978: where task_id = l_task_rec_tbl(i).id)

Line 980: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

976: and a.party_id in (select source_object_id
977: from jtf_tasks_b
978: where task_id = l_task_rec_tbl(i).id)
979: and a.party_id = b.party_id
980: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
981: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
982: AND DIRECTIONAL_FLAG = 'F';
983:
984: else l_note_context_type_id :=null;

Line 981: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

977: from jtf_tasks_b
978: where task_id = l_task_rec_tbl(i).id)
979: and a.party_id = b.party_id
980: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
981: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
982: AND DIRECTIONAL_FLAG = 'F';
983:
984: else l_note_context_type_id :=null;
985: end if ;

Line 1026: from hz_relationships a, hz_parties b

1022:
1023: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1024: l_continue := 0;
1025: select count(a.subject_id) into l_continue
1026: from hz_relationships a, hz_parties b
1027: where b.party_type = 'PARTY_RELATIONSHIP'
1028: and a.party_id = (select source_object_id
1029: from jtf_tasks_b
1030: where task_id = l_task_rec_tbl(i).id)

Line 1032: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1028: and a.party_id = (select source_object_id
1029: from jtf_tasks_b
1030: where task_id = l_task_rec_tbl(i).id)
1031: and a.party_id = b.party_id
1032: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1033: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1034: AND DIRECTIONAL_FLAG = 'F';
1035:
1036: if (l_continue > 0) then

Line 1033: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1029: from jtf_tasks_b
1030: where task_id = l_task_rec_tbl(i).id)
1031: and a.party_id = b.party_id
1032: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1033: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1034: AND DIRECTIONAL_FLAG = 'F';
1035:
1036: if (l_continue > 0) then
1037: select a.subject_id into l_note_context_type_id

Line 1038: from hz_relationships a, hz_parties b

1034: AND DIRECTIONAL_FLAG = 'F';
1035:
1036: if (l_continue > 0) then
1037: select a.subject_id into l_note_context_type_id
1038: from hz_relationships a, hz_parties b
1039: where b.party_type = 'PARTY_RELATIONSHIP'
1040: and a.party_id = (select source_object_id
1041: from jtf_tasks_b
1042: where task_id = l_task_rec_tbl(i).id)

Line 1044: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1040: and a.party_id = (select source_object_id
1041: from jtf_tasks_b
1042: where task_id = l_task_rec_tbl(i).id)
1043: and a.party_id = b.party_id
1044: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1045: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1046: AND DIRECTIONAL_FLAG = 'F';
1047:
1048: else l_note_context_type_id := null;

Line 1045: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1041: from jtf_tasks_b
1042: where task_id = l_task_rec_tbl(i).id)
1043: and a.party_id = b.party_id
1044: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1045: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1046: AND DIRECTIONAL_FLAG = 'F';
1047:
1048: else l_note_context_type_id := null;
1049: end if;