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.CZ_CF_API dependencies on CZ_MODEL_APPLICABILITIES_V

Line 3191: FROM cz_model_applicabilities_v

3187: c_organization_id NUMBER;
3188:
3189: CURSOR pub_cur IS
3190: SELECT publication_id
3191: FROM cz_model_applicabilities_v
3192: WHERE inventory_item_id = v_inventory_item_id
3193: AND bom_explosion_org_id = v_organization_id
3194: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3195: AND fnd_application_id = v_application_id

Line 3206: FROM cz_model_applicabilities_v

3202: ORDER BY start_date DESC;
3203:
3204: CURSOR no_appl_pub_cur IS
3205: SELECT publication_id
3206: FROM cz_model_applicabilities_v
3207: WHERE inventory_item_id = v_inventory_item_id
3208: AND bom_explosion_org_id = v_organization_id
3209: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3210: AND usage_id = v_usage_id

Line 3475: FROM cz_model_applicabilities_v

3471: c_product_key cz_devl_projects.product_key%TYPE;
3472:
3473: CURSOR pub_cur IS
3474: SELECT publication_id
3475: FROM cz_model_applicabilities_v
3476: WHERE product_key = v_product_key
3477: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3478: AND fnd_application_id = v_application_id
3479: AND usage_id = v_usage_id

Line 3488: FROM cz_model_applicabilities_v

3484: AND (v_config_lookup_date < disable_date)
3485: ORDER BY start_date DESC;
3486: CURSOR no_appl_pub_cur IS
3487: SELECT publication_id
3488: FROM cz_model_applicabilities_v
3489: WHERE product_key = v_product_key
3490: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3491: AND usage_id = v_usage_id
3492: AND Source_Target_Flag = v_source_target_flag

Line 3792: FROM cz_model_applicabilities_v pub, cz_devl_projects prj

3788: SELECT pub.publication_id, pub.model_id, pub.ui_def_id, pub.start_date,
3789: pub.last_update_date, prj.model_type
3790: BULK COLLECT INTO x_publication_ids, x_model_ids, x_ui_def_ids,
3791: x_start_dates, x_last_update_dates, l_model_type_tbl
3792: FROM cz_model_applicabilities_v pub, cz_devl_projects prj
3793: WHERE pub.model_id = prj.devl_project_id
3794: AND prj.deleted_flag ='0' AND pub.deleted_flag = '0'
3795: AND pub.inventory_item_id = p_inventory_item_id
3796: AND bom_explosion_org_id = p_organization_id