DBA Data[Home] [Help]

APPS.JA_CN_SIOA_EXPORT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 202: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,

198: FIFS.SEGMENT_NAME AS SUB_ITEM_NAME, --Subsidiary Item Name
199: FIFS.SEGMENT_NAME AS CORR_RECORD, --Corresponding Record
200: FFVS.DESCRIPTION AS SUB_ITEM_DESC --Subsidiary Item Description
201: FROM FND_ID_FLEX_SEGMENTS FIFS,
202: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
203: GL_LEDGERS LED,
204: FND_FLEX_VALUE_SETS FFVS,
205: JA_CN_SUB_ACC_MAPPING SAM
206: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM

Line 213: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV1

209: AND (FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL' OR
210: (FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_GLOBAL' AND
211: NOT EXISTS
212: (SELECT *
213: FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV1
214: WHERE FSAV1.APPLICATION_ID = FSAV.APPLICATION_ID
215: AND FSAV1.ID_FLEX_CODE = FSAV.ID_FLEX_CODE
216: AND FSAV1.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
217: AND FSAV1.APPLICATION_COLUMN_NAME =