DBA Data[Home] [Help]

APPS.JA_JAAUFREV_XMLP_PKG dependencies on FA_CATEGORIES

Line 196: FA_CATEGORIES C,

192: ,C.SEGMENT1
193: ,' ')
194: INTO L_ASSET_CLASS
195: FROM
196: FA_CATEGORIES C,
197: FND_ID_FLEXS FLEXID,
198: FND_ID_FLEX_SEGMENTS FLEX1,
199: FND_ID_FLEX_SEGMENTS FLEX2,
200: FND_ID_FLEX_SEGMENTS FLEX3,

Line 206: AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'

202: FND_ID_FLEX_SEGMENTS FLEX5,
203: FND_ID_FLEX_SEGMENTS FLEX6,
204: FND_ID_FLEX_SEGMENTS FLEX7
205: WHERE C.CATEGORY_ID = P_ASSET_CLASS
206: AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'
207: AND FLEXID.UNIQUE_ID_COLUMN_NAME = 'CATEGORY_ID'
208: AND FLEX1.ID_FLEX_CODE = FLEXID.ID_FLEX_CODE
209: AND FLEX1.SEGMENT_NUM = 1
210: AND FLEX1.ENABLED_FLAG = 'Y'

Line 420: FA_CATEGORIES C,

416: ,C.SEGMENT1
417: ,' ')
418: INTO L_ASSET_CLASS
419: FROM
420: FA_CATEGORIES C,
421: FND_ID_FLEXS FLEXID,
422: FND_ID_FLEX_SEGMENTS FLEX1,
423: FND_ID_FLEX_SEGMENTS FLEX2,
424: FND_ID_FLEX_SEGMENTS FLEX3,

Line 430: AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'

426: FND_ID_FLEX_SEGMENTS FLEX5,
427: FND_ID_FLEX_SEGMENTS FLEX6,
428: FND_ID_FLEX_SEGMENTS FLEX7
429: WHERE C.CATEGORY_ID = ASSET_CLASS
430: AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'
431: AND FLEXID.UNIQUE_ID_COLUMN_NAME = 'CATEGORY_ID'
432: AND FLEX1.ID_FLEX_CODE = FLEXID.ID_FLEX_CODE
433: AND FLEX1.SEGMENT_NUM = 1
434: AND FLEX1.ENABLED_FLAG = 'Y'