DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on FND_FLEX_VALUE_SETS

Line 115: FROM FND_DESCR_FLEX_COL_USAGE_VL a,FND_FLEX_VALUE_SETS b

111:
112: CURSOR c_style IS
113: SELECT APPLICATION_COLUMN_NAME tag, DECODE(REQUIRED_FLAG,'Y','*','')||FORM_LEFT_PROMPT text,
114: b.FLEX_VALUE_SET_ID ffvs,b.validation_type
115: FROM FND_DESCR_FLEX_COL_USAGE_VL a,FND_FLEX_VALUE_SETS b
116: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_addr_style
117: AND APPLICATION_ID = 222 AND DESCRIPTIVE_FLEXFIELD_NAME = 'Remit Address HZ'
118: AND DISPLAY_FLAG = 'Y' AND ENABLED_FLAG='Y'
119: AND a.FLEX_VALUE_SET_ID=b.FLEX_VALUE_SET_ID(+)