APPS.CZ_CF_API dependencies on CZ_MODEL_APPLICABILITIES_V

Line 2791: FROM cz_model_applicabilities_v

2787: c_organization_id NUMBER;
2788:
2789: CURSOR pub_cur IS
2790: SELECT publication_id
2791: FROM cz_model_applicabilities_v
2792: WHERE inventory_item_id = v_inventory_item_id
2793: AND bom_explosion_org_id = v_organization_id
2794: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
2795: AND fnd_application_id = v_application_id

Line 2806: FROM cz_model_applicabilities_v

2802: ORDER BY start_date DESC;
2803:
2804: CURSOR no_appl_pub_cur IS
2805: SELECT publication_id
2806: FROM cz_model_applicabilities_v
2807: WHERE inventory_item_id = v_inventory_item_id
2808: AND bom_explosion_org_id = v_organization_id
2809: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
2810: AND usage_id = v_usage_id

Line 3075: FROM cz_model_applicabilities_v

3071: c_product_key VARCHAR2(40);
3072:
3073: CURSOR pub_cur IS
3074: SELECT publication_id
3075: FROM cz_model_applicabilities_v
3076: WHERE product_key = v_product_key
3077: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3078: AND fnd_application_id = v_application_id
3079: AND usage_id = v_usage_id

Line 3088: FROM cz_model_applicabilities_v

3084: AND (v_config_lookup_date < disable_date)
3085: ORDER BY start_date DESC;
3086: CURSOR no_appl_pub_cur IS
3087: SELECT publication_id
3088: FROM cz_model_applicabilities_v
3089: WHERE product_key = v_product_key
3090: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(v_publication_mode)))
3091: AND usage_id = v_usage_id
3092: AND Source_Target_Flag = v_source_target_flag

Line 3392: FROM cz_model_applicabilities_v pub, cz_devl_projects prj

3388: SELECT pub.publication_id, pub.model_id, pub.ui_def_id, pub.start_date,
3389: pub.last_update_date, prj.model_type
3390: BULK COLLECT INTO x_publication_ids, x_model_ids, x_ui_def_ids,
3391: x_start_dates, x_last_update_dates, l_model_type_tbl
3392: FROM cz_model_applicabilities_v pub, cz_devl_projects prj
3393: WHERE pub.model_id = prj.devl_project_id
3394: AND prj.deleted_flag ='0' AND pub.deleted_flag = '0'
3395: AND pub.inventory_item_id = p_inventory_item_id
3396: AND bom_explosion_org_id = p_organization_id