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 AMV_U_MY_CHANNELS

Line 3502: amv_u_my_channels mych

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'
3506: AND match.approval_status_type = 'APPROVED'

Line 3517: amv_u_my_channels mych, jtf_rs_group_members mem,

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
3521: AND match.table_name_code = 'ITEM'

Line 3662: amv_u_my_channels mych

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'
3666: AND match.approval_status_type = 'APPROVED'

Line 3699: amv_u_my_channels mych, jtf_rs_group_members mem,

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
3703: AND match.table_name_code = 'ITEM'