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 AMV_C_CATEGORIES_VL

Line 2166: from amv_c_categories_vl

2162: channel_category_order,
2163: nvl(channel_count,0),
2164: channel_category_name,
2165: description
2166: from amv_c_categories_vl
2167: where channel_category_name like p_category_name
2168: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2169: and application_id = p_application_id
2170: order by channel_category_name;

Line 2180: from amv_c_categories_vl

2176: channel_category_order,
2177: nvl(channel_count,0),
2178: channel_category_name,
2179: description
2180: from amv_c_categories_vl
2181: where channel_category_name like p_category_name
2182: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2183: and application_id = p_application_id
2184: and parent_channel_category_id is null

Line 2195: from amv_c_categories_vl

2191: channel_category_order,
2192: nvl(channel_count,0),
2193: channel_category_name,
2194: description
2195: from amv_c_categories_vl
2196: where channel_category_name like p_category_name
2197: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2198: and application_id = p_application_id
2199: and parent_channel_category_id = l_parent_category_id

Line 2204: from amv_c_categories_vl

2200: order by channel_category_order;
2201:
2202: CURSOR Count_AllCategories_csr IS
2203: select count(channel_category_id)
2204: from amv_c_categories_vl
2205: where channel_category_name like p_category_name
2206: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2207: and application_id = p_application_id;
2208:

Line 2211: from amv_c_categories_vl

2207: and application_id = p_application_id;
2208:
2209: CURSOR Count_ParentCategories_csr IS
2210: select count(channel_category_id)
2211: from amv_c_categories_vl
2212: where channel_category_name like p_category_name
2213: and channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2214: and application_id = p_application_id
2215: and parent_channel_category_id is null;

Line 2219: from amv_c_categories_vl

2215: and parent_channel_category_id is null;
2216:
2217: CURSOR Count_SubCategories_csr IS
2218: select count(channel_category_id)
2219: from amv_c_categories_vl
2220: where channel_category_name not in ('AMV_GROUP', 'AMV_PRIVATE')
2221: and application_id = p_application_id
2222: and parent_channel_category_id = l_category_id;
2223:

Line 4083: from amv_c_categories_vl

4079: , object_version_number
4080: , application_id
4081: , channel_category_order
4082: , channel_count
4083: from amv_c_categories_vl
4084: where channel_category_id = p_category_id;
4085:
4086: CURSOR Get_SubCatName IS
4087: select channel_category_name

Line 4088: from amv_c_categories_vl

4084: where channel_category_id = p_category_id;
4085:
4086: CURSOR Get_SubCatName IS
4087: select channel_category_name
4088: from amv_c_categories_vl
4089: where parent_channel_category_id = p_parent_category_id;
4090:
4091: --
4092: BEGIN