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_CATEGORY_PVT dependencies on JTF_AMV_ITEMS_VL

Line 2833: , jtf_amv_items_vl ib

2829: CURSOR Get_CategoryItems_csr IS
2830: select ib.item_id
2831: , ib.item_name
2832: from amv_c_chl_item_match cim
2833: , jtf_amv_items_vl ib
2834: where cim.channel_category_id = l_category_id
2835: and cim.channel_id is null
2836: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
2837: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 3071: , jtf_amv_items_vl ib

3067: CURSOR Get_CategoryItems_csr IS
3068: select ib.item_id
3069: , ib.item_name
3070: from amv_c_chl_item_match cim
3071: , jtf_amv_items_vl ib
3072: where cim.channel_category_id = l_category_id
3073: and cim.channel_id is null
3074: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3075: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

Line 3085: , jtf_amv_items_vl ib

3081:
3082: CURSOR Get_ItemsTotal_csr IS
3083: select count(cim.item_id)
3084: from amv_c_chl_item_match cim
3085: , jtf_amv_items_vl ib
3086: where cim.channel_category_id = l_category_id
3087: and cim.channel_id is null
3088: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3089: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE