DBA Data[Home] [Help]

APPS.JA_CN_UDR_EXPORT dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 181: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,

177: --Get the COA record name from context field.
178: SELECT DISTINCT FIFS.SEGMENT_NAME
179: into lv_record_name
180: FROM FND_ID_FLEX_SEGMENTS FIFS,
181: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
182: GL_LEDGERS LED,
183: FND_FLEX_VALUE_SETS FFVS,
184: JA_CN_SUB_ACC_MAPPING SAM
185: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM

Line 191: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV1

187: FSAV.APPLICATION_COLUMN_NAME
188: AND (FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL' OR
189: (FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_GLOBAL' AND NOT EXISTS
190: (SELECT *
191: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV1
192: WHERE FSAV1.APPLICATION_ID = FSAV.APPLICATION_ID
193: AND FSAV1.ID_FLEX_CODE = FSAV.ID_FLEX_CODE
194: AND FSAV1.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
195: AND FSAV1.APPLICATION_COLUMN_NAME =