APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_MASTERS

Line 4478: FROM cz_item_masters

4474: l_item_id_tbl t_num_array_tbl_type;
4475:
4476: CURSOR l_item_csr IS
4477: SELECT item_id
4478: FROM cz_item_masters
4479: WHERE item_type_id = p_item_type_id
4480: AND deleted_flag = '0';
4481:
4482: BEGIN

Line 4530: UPDATE cz_item_masters

4526: -------------------------------------------------------------
4527: -- change the item type of items in this item type to default
4528: -------------------------------------------------------------
4529:
4530: UPDATE cz_item_masters
4531: SET item_type_id = G_DEFAULT_ITEM_TYPE
4532: WHERE item_type_id = p_item_type_id;
4533:
4534: ----------------------------------

Line 8081: cz_item_masters itm,

8077: AND property_id = l_prp_ref(modelId)
8078: UNION
8079: SELECT devl_project_id
8080: FROM cz_item_type_properties itypr,
8081: cz_item_masters itm,
8082: cz_ps_nodes psnd
8083: WHERE itypr.deleted_flag = '0'
8084: AND itypr.item_type_id = itm.item_type_id
8085: AND itm.deleted_flag = '0'

Line 12133: FROM cz_item_masters

12129: BEGIN
12130: -- Item must be valid
12131: BEGIN
12132: SELECT ref_part_nbr, item_type_id INTO l_item_name, l_item_type_id
12133: FROM cz_item_masters
12134: WHERE item_id = p_item_id
12135: AND deleted_flag = '0';
12136: EXCEPTION
12137: WHEN NO_DATA_FOUND THEN