DBA Data[Home] [Help]

APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on POR_FAVORITE_LIST_HEADERS

Line 6286: FROM por_favorite_list_headers old_fav_hdrs

6282: attribute1, attribute2, attribute3, attribute4, attribute5,
6283: attribute6, attribute7, attribute8, attribute9, attribute10,
6284: attribute11, attribute12, attribute13, attribute14, attribute15,
6285: primary_flag
6286: FROM por_favorite_list_headers old_fav_hdrs
6287: WHERE NOT EXISTS (SELECT NULL
6288: FROM icx_cat_fav_list_headers new_fav_hdrs
6289: WHERE new_fav_hdrs.employee_id = old_fav_hdrs.employee_id
6290: AND new_fav_hdrs.favorite_list_id = old_fav_hdrs.favorite_list_id);

Line 6440: FROM por_favorite_list_headers fav_hdrs, fnd_user users,

6436: -- Includes non-catalog and external (punchout/transparent punchout items
6437: CURSOR otherItemUpgradeCsr (p_profile_option_id NUMBER) IS
6438: SELECT fav_hdrs.favorite_list_id, fav_hdrs.employee_id, users.user_id,
6439: prf_vals.profile_option_value, COUNT(*)
6440: FROM por_favorite_list_headers fav_hdrs, fnd_user users,
6441: fnd_profile_option_values prf_vals, por_favorite_list_lines fav_lines
6442: WHERE fav_hdrs.favorite_list_id = fav_lines.favorite_list_id
6443: AND fav_lines.item_type <> 'CATALOG'
6444: AND fav_hdrs.employee_id = users.employee_id (+)