APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_APC_PROPERTIES

Line 2183: SELECT COUNT(*) INTO l_check_for_stub_views FROM CZ_EXV_APC_PROPERTIES

2179:
2180: --
2181: -- if l_check_for_stub_views > 0 then stub views are used
2182: --
2183: SELECT COUNT(*) INTO l_check_for_stub_views FROM CZ_EXV_APC_PROPERTIES
2184: WHERE ATTR_GROUP_ID = -1 AND
2185: ITEM_CATALOG_GROUP_ID = -1 AND
2186: ATTR_ID = -1 AND
2187: APPLICATION_ID = -1;

Line 2258: FROM CZ_EXV_APC_PROPERTIES apcprops,

2254:
2255: FOR attr IN(SELECT attr_group_id, attr_group_name||'.'||attr_name AS attribute_name,
2256: DECODE(data_type_code,'N',DECIMAL_TYPE,'C',TEXT_TYPE,'A',TL_TEXT_TYPE,TEXT_TYPE) AS property_type,
2257: database_column,description,apcprops.item_catalog_group_id,apcprops.default_value
2258: FROM CZ_EXV_APC_PROPERTIES apcprops,
2259: CZ_IMP_TMP_ITEMCAT itemtypes
2260: WHERE apcprops.item_catalog_group_id=itemtypes.item_catalog_group_id AND
2261: itemtypes.run_id=p_run_id
2262: ORDER BY attr_group_id)