DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB dependencies on JTF_RS_GROUP_MEMBERS

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 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'