View: HXC_LAYOUT_COMP_PROMPTS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_LAYOUT_COMP_PROMPTS_V

View Text

SELECT BASE.LAYOUT_COMP_PROMPT_ID
, BASE.LAYOUT_COMPONENT_ID
, BASE.PROMPT_ALIAS
, AK.ATTRIBUTE_LABEL_LONG LABEL
, AK.DESCRIPTION
, AK.CSS_LABEL_CLASS_NAME CSS_CLASS
FROM HXC_LAYOUT_COMP_PROMPTS BASE
, AK_REGION_ITEMS_VL AK
WHERE BASE.REGION_CODE = AK.REGION_CODE
AND BASE.REGION_APPLICATION_ID = AK.REGION_APPLICATION_ID
AND BASE.ATTRIBUTE_CODE = AK.ATTRIBUTE_CODE
AND BASE.ATTRIBUTE_APPLICATION_ID = AK.ATTRIBUTE_APPLICATION_ID
AND BASE.PROMPT_TYPE = 'AK_PROMPT'

Columns