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.AMV_ITEM_PUB dependencies on JTF_AMV_ITEMS_VL

Line 1387: 'From JTF_AMV_ITEMS_VL';

1383: 'CONTENT_TYPE_ID, ' ||
1384: 'OWNER_ID, ' ||
1385: 'DEFAULT_APPROVER_ID, ' ||
1386: 'ITEM_DESTINATION_TYPE ' ||
1387: 'From JTF_AMV_ITEMS_VL';
1388: l_sql_statement2 :=
1389: 'Select count(*) ' ||
1390: 'From JTF_AMV_ITEMS_VL';
1391: --

Line 1390: 'From JTF_AMV_ITEMS_VL';

1386: 'ITEM_DESTINATION_TYPE ' ||
1387: 'From JTF_AMV_ITEMS_VL';
1388: l_sql_statement2 :=
1389: 'Select count(*) ' ||
1390: 'From JTF_AMV_ITEMS_VL';
1391: --
1392: l_where_clause := ' ';
1393: IF (p_item_name IS NOT NULL AND
1394: p_item_name <> FND_API.G_MISS_CHAR) THEN

Line 3501: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3497: CURSOR Get_Message_csr IS
3498: SELECT
3499: item.item_id,
3500: item.item_name
3501: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3502: amv_u_my_channels mych
3503: WHERE item.item_type = 'MESSAGE_ITEM'
3504: AND item.item_id = match.item_id
3505: AND match.table_name_code = 'ITEM'

Line 3516: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3512: UNION
3513: SELECT
3514: item.item_id,
3515: item.item_name
3516: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3517: amv_u_my_channels mych, jtf_rs_group_members mem,
3518: jtf_rs_groups_vl g
3519: WHERE item.item_type = 'MESSAGE_ITEM'
3520: AND item.item_id = match.item_id

Line 3661: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3657: item.content_type_id,
3658: item.owner_id,
3659: item.default_approver_id,
3660: item.item_destination_type
3661: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3662: amv_u_my_channels mych
3663: WHERE item.item_type = 'MESSAGE_ITEM'
3664: AND item.item_id = match.item_id
3665: AND match.table_name_code = 'ITEM'

Line 3698: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3694: item.content_type_id,
3695: item.owner_id,
3696: item.default_approver_id,
3697: item.item_destination_type
3698: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3699: amv_u_my_channels mych, jtf_rs_group_members mem,
3700: jtf_rs_groups_vl g
3701: WHERE item.item_type = 'MESSAGE_ITEM'
3702: AND item.item_id = match.item_id