DBA Data[Home] [Help]

APPS.AMS_WEBMARKETING_PVT dependencies on IBC_CONTENT_TYPES_VL

Line 159: FROM IBC_COMPOUND_RELATIONS cr, IBC_ATTRIBUTE_TYPES_VL attr, IBC_CONTENT_TYPES_VL ct,IBC_CITEM_VERSIONS_VL civ,

155:
156:
157: CURSOR c_plce_citems(l_citem_version_id IN NUMBER) IS
158: SELECT civ.CONTENT_ITEM_ID c_item_id ,civ.CITEM_VERSION_ID c_version_id
159: FROM IBC_COMPOUND_RELATIONS cr, IBC_ATTRIBUTE_TYPES_VL attr, IBC_CONTENT_TYPES_VL ct,IBC_CITEM_VERSIONS_VL civ,
160: IBC_CONTENT_ITEMS ci WHERE
161: cr.ATTRIBUTE_TYPE_CODE = attr.ATTRIBUTE_TYPE_CODE AND
162: cr.CONTENT_TYPE_CODE = attr.CONTENT_TYPE_CODE AND
163: ct.CONTENT_TYPE_CODE = ci.CONTENT_TYPE_CODE AND