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_DEVL_PROJECTS

Line 2919: FROM cz_devl_projects prj, cz_model_ref_expls expl

2915: ,x_organization_id OUT NOCOPY NUMBER)
2916: IS
2917: CURSOR reference_cursor IS
2918: SELECT prj.inventory_item_id, prj.organization_id
2919: FROM cz_devl_projects prj, cz_model_ref_expls expl
2920: WHERE expl.model_id = p_model_id
2921: AND expl.ps_node_type = PS_NODE_TYPE_REFERENCE
2922: AND expl.deleted_flag = '0'
2923: AND prj.devl_project_id = expl.component_id

Line 2952: v_product_key cz_devl_projects.product_key%TYPE;

2948: v_config_hdr_id NUMBER := config_hdr_id;
2949: v_config_rev_nbr NUMBER := config_rev_nbr;
2950: v_inventory_item_id NUMBER;
2951: v_organization_id NUMBER;
2952: v_product_key cz_devl_projects.product_key%TYPE;
2953: v_component_id NUMBER;
2954: v_model_identifier cz_config_hdrs.model_identifier%TYPE;
2955: v_ndebug NUMBER := 0;
2956:

Line 3001: FROM CZ_DEVL_PROJECTS

2997: v_ndebug := 2;
2998: BEGIN
2999: SELECT inventory_item_id, organization_id, product_key
3000: INTO v_inventory_item_id, v_organization_id, v_product_key
3001: FROM CZ_DEVL_PROJECTS
3002: WHERE deleted_flag = '0' AND devl_project_id = v_component_id;
3003: EXCEPTION
3004: WHEN no_data_found THEN
3005: v_ndebug := 3;

Line 3384: TYPE model_type_tbl_type IS TABLE OF cz_devl_projects.model_type%TYPE

3380: ,x_last_update_dates OUT NOCOPY date_tbl_indexby_type
3381: ,x_model_type OUT NOCOPY VARCHAR2
3382: )
3383: IS
3384: TYPE model_type_tbl_type IS TABLE OF cz_devl_projects.model_type%TYPE
3385: INDEX BY BINARY_INTEGER;
3386: l_model_type_tbl model_type_tbl_type;
3387: BEGIN
3388: SELECT pub.publication_id, pub.model_id, pub.ui_def_id, pub.start_date,

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