Product: | AMS - Marketing |
---|---|
Description: | This view returns the marketing categories used in marketing deliverables / marketing events. |
Implementation/DBA Data: | APPS.AMS_CATEGORIES_V |
SELECT ACAT.CATEGORY_ID
, ACAT.CATEGORY_NAME
, ACAT.DESCRIPTION
, ACAT.OBJECT_VERSION_NUMBER
, ACAT.ENABLED_FLAG
, ACAT.PARENT_CATEGORY_ID
, PCAT.CATEGORY_NAME
, PCAT.DESCRIPTION
, ACAT.ACCRUED_LIABILITY_ACCOUNT
, ACAT.DED_ADJUSTMENT_ACCOUNT
, ACAT.ARC_CATEGORY_CREATED_FOR
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_SYS_ARC_QUALIFIER'
, ACAT.ARC_CATEGORY_CREATED_FOR) CREATED_FOR_MEANING
, ACAT.CREATION_DATE
FROM AMS_CATEGORIES_VL ACAT
, AMS_CATEGORIES_VL PCAT
WHERE ACAT.PARENT_CATEGORY_ID=PCAT.CATEGORY_ID(+)