APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_APC_PROPERTIES

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

2117:
2118: --
2119: -- if l_check_for_stub_views > 0 then stub views are used
2120: --
2121: SELECT COUNT(*) INTO l_check_for_stub_views FROM CZ_EXV_APC_PROPERTIES
2122: WHERE ATTR_GROUP_ID = -1 AND
2123: ITEM_CATALOG_GROUP_ID = -1 AND
2124: ATTR_ID = -1 AND
2125: APPLICATION_ID = -1;

Line 2196: FROM CZ_EXV_APC_PROPERTIES apcprops,

2192:
2193: FOR attr IN(SELECT attr_group_id, attr_group_name||'.'||attr_name AS attribute_name,
2194: DECODE(data_type_code,'N',DECIMAL_TYPE,'C',TEXT_TYPE,'A',TL_TEXT_TYPE,TEXT_TYPE) AS property_type,
2195: database_column,description,apcprops.item_catalog_group_id,apcprops.default_value
2196: FROM CZ_EXV_APC_PROPERTIES apcprops,
2197: CZ_IMP_TMP_ITEMCAT itemtypes
2198: WHERE apcprops.item_catalog_group_id=itemtypes.item_catalog_group_id AND
2199: itemtypes.run_id=p_run_id
2200: ORDER BY attr_group_id)