DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_MASTERS

Line 4450: FROM cz_item_masters

4446: l_item_id_tbl t_num_array_tbl_type;
4447:
4448: CURSOR l_item_csr IS
4449: SELECT item_id
4450: FROM cz_item_masters
4451: WHERE item_type_id = p_item_type_id
4452: AND deleted_flag = '0';
4453:
4454: BEGIN

Line 4502: UPDATE cz_item_masters

4498: -------------------------------------------------------------
4499: -- change the item type of items in this item type to default
4500: -------------------------------------------------------------
4501:
4502: UPDATE cz_item_masters
4503: SET item_type_id = G_DEFAULT_ITEM_TYPE
4504: WHERE item_type_id = p_item_type_id;
4505:
4506: ----------------------------------

Line 8023: cz_item_masters itm,

8019: AND property_id = l_prp_ref(modelId)
8020: UNION
8021: SELECT devl_project_id
8022: FROM cz_item_type_properties itypr,
8023: cz_item_masters itm,
8024: cz_ps_nodes psnd
8025: WHERE itypr.deleted_flag = '0'
8026: AND itypr.item_type_id = itm.item_type_id
8027: AND itm.deleted_flag = '0'