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,
201: FND_ID_FLEX_SEGMENTS FLEX4,
202: FND_ID_FLEX_SEGMENTS FLEX5,
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,
201: FND_ID_FLEX_SEGMENTS FLEX4,
202: FND_ID_FLEX_SEGMENTS FLEX5,
203: FND_ID_FLEX_SEGMENTS FLEX6,
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,
201: FND_ID_FLEX_SEGMENTS FLEX4,
202: FND_ID_FLEX_SEGMENTS FLEX5,
203: FND_ID_FLEX_SEGMENTS FLEX6,
204: FND_ID_FLEX_SEGMENTS FLEX7
197: FND_ID_FLEXS FLEXID,
198: FND_ID_FLEX_SEGMENTS FLEX1,
199: FND_ID_FLEX_SEGMENTS FLEX2,
200: FND_ID_FLEX_SEGMENTS FLEX3,
201: FND_ID_FLEX_SEGMENTS FLEX4,
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
198: FND_ID_FLEX_SEGMENTS FLEX1,
199: FND_ID_FLEX_SEGMENTS FLEX2,
200: FND_ID_FLEX_SEGMENTS FLEX3,
201: FND_ID_FLEX_SEGMENTS FLEX4,
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'
199: FND_ID_FLEX_SEGMENTS FLEX2,
200: FND_ID_FLEX_SEGMENTS FLEX3,
201: FND_ID_FLEX_SEGMENTS FLEX4,
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'
200: FND_ID_FLEX_SEGMENTS FLEX3,
201: FND_ID_FLEX_SEGMENTS FLEX4,
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
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,
425: FND_ID_FLEX_SEGMENTS FLEX4,
426: FND_ID_FLEX_SEGMENTS FLEX5,
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,
425: FND_ID_FLEX_SEGMENTS FLEX4,
426: FND_ID_FLEX_SEGMENTS FLEX5,
427: FND_ID_FLEX_SEGMENTS FLEX6,
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,
425: FND_ID_FLEX_SEGMENTS FLEX4,
426: FND_ID_FLEX_SEGMENTS FLEX5,
427: FND_ID_FLEX_SEGMENTS FLEX6,
428: FND_ID_FLEX_SEGMENTS FLEX7
421: FND_ID_FLEXS FLEXID,
422: FND_ID_FLEX_SEGMENTS FLEX1,
423: FND_ID_FLEX_SEGMENTS FLEX2,
424: FND_ID_FLEX_SEGMENTS FLEX3,
425: FND_ID_FLEX_SEGMENTS FLEX4,
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
422: FND_ID_FLEX_SEGMENTS FLEX1,
423: FND_ID_FLEX_SEGMENTS FLEX2,
424: FND_ID_FLEX_SEGMENTS FLEX3,
425: FND_ID_FLEX_SEGMENTS FLEX4,
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'
423: FND_ID_FLEX_SEGMENTS FLEX2,
424: FND_ID_FLEX_SEGMENTS FLEX3,
425: FND_ID_FLEX_SEGMENTS FLEX4,
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'
424: FND_ID_FLEX_SEGMENTS FLEX3,
425: FND_ID_FLEX_SEGMENTS FLEX4,
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