151: LV.START_DATE_ACTIVE,
152: LV.END_DATE_ACTIVE,
153: LV.ENABLED_FLAG,
154: 'Y',
155: NVL(FND_GLOBAL.USER_ID,-1),
156: SYSDATE,
157: NVL(FND_GLOBAL.USER_ID,-1),
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
153: LV.ENABLED_FLAG,
154: 'Y',
155: NVL(FND_GLOBAL.USER_ID,-1),
156: SYSDATE,
157: NVL(FND_GLOBAL.USER_ID,-1),
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
160: FND_GLOBAL.CONC_REQUEST_ID,
161: FND_GLOBAL.CONC_PROGRAM_ID,
154: 'Y',
155: NVL(FND_GLOBAL.USER_ID,-1),
156: SYSDATE,
157: NVL(FND_GLOBAL.USER_ID,-1),
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
160: FND_GLOBAL.CONC_REQUEST_ID,
161: FND_GLOBAL.CONC_PROGRAM_ID,
162: FND_GLOBAL.PROG_APPL_ID,
156: SYSDATE,
157: NVL(FND_GLOBAL.USER_ID,-1),
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
160: FND_GLOBAL.CONC_REQUEST_ID,
161: FND_GLOBAL.CONC_PROGRAM_ID,
162: FND_GLOBAL.PROG_APPL_ID,
163: SYSDATE
164: FROM
157: NVL(FND_GLOBAL.USER_ID,-1),
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
160: FND_GLOBAL.CONC_REQUEST_ID,
161: FND_GLOBAL.CONC_PROGRAM_ID,
162: FND_GLOBAL.PROG_APPL_ID,
163: SYSDATE
164: FROM
165: FND_LOOKUP_TYPES_TL LT,
158: NVL(FND_GLOBAL.LOGIN_ID,-1),
159: SYSDATE,
160: FND_GLOBAL.CONC_REQUEST_ID,
161: FND_GLOBAL.CONC_PROGRAM_ID,
162: FND_GLOBAL.PROG_APPL_ID,
163: SYSDATE
164: FROM
165: FND_LOOKUP_TYPES_TL LT,
166: FND_LOOKUP_VALUES LV,
220: LV.START_DATE_ACTIVE,
221: LV.END_DATE_ACTIVE,
222: LV.ENABLED_FLAG,
223: 'Y',
224: NVL(FND_GLOBAL.USER_ID,-1),
225: SYSDATE,
226: NVL(FND_GLOBAL.USER_ID,-1),
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
222: LV.ENABLED_FLAG,
223: 'Y',
224: NVL(FND_GLOBAL.USER_ID,-1),
225: SYSDATE,
226: NVL(FND_GLOBAL.USER_ID,-1),
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
229: FND_GLOBAL.CONC_REQUEST_ID,
230: FND_GLOBAL.CONC_PROGRAM_ID,
223: 'Y',
224: NVL(FND_GLOBAL.USER_ID,-1),
225: SYSDATE,
226: NVL(FND_GLOBAL.USER_ID,-1),
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
229: FND_GLOBAL.CONC_REQUEST_ID,
230: FND_GLOBAL.CONC_PROGRAM_ID,
231: FND_GLOBAL.PROG_APPL_ID,
225: SYSDATE,
226: NVL(FND_GLOBAL.USER_ID,-1),
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
229: FND_GLOBAL.CONC_REQUEST_ID,
230: FND_GLOBAL.CONC_PROGRAM_ID,
231: FND_GLOBAL.PROG_APPL_ID,
232: SYSDATE
233: FROM
226: NVL(FND_GLOBAL.USER_ID,-1),
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
229: FND_GLOBAL.CONC_REQUEST_ID,
230: FND_GLOBAL.CONC_PROGRAM_ID,
231: FND_GLOBAL.PROG_APPL_ID,
232: SYSDATE
233: FROM
234: FND_LOOKUP_TYPES_TL LT,
227: NVL(FND_GLOBAL.LOGIN_ID,-1),
228: SYSDATE,
229: FND_GLOBAL.CONC_REQUEST_ID,
230: FND_GLOBAL.CONC_PROGRAM_ID,
231: FND_GLOBAL.PROG_APPL_ID,
232: SYSDATE
233: FROM
234: FND_LOOKUP_TYPES_TL LT,
235: FND_LOOKUP_VALUES LV,
265: LV.START_DATE_ACTIVE,
266: LV.END_DATE_ACTIVE,
267: LV.ENABLED_FLAG,
268: 'Y',
269: NVL(FND_GLOBAL.USER_ID,-1),
270: SYSDATE,
271: NVL(FND_GLOBAL.USER_ID,-1),
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
267: LV.ENABLED_FLAG,
268: 'Y',
269: NVL(FND_GLOBAL.USER_ID,-1),
270: SYSDATE,
271: NVL(FND_GLOBAL.USER_ID,-1),
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
274: FND_GLOBAL.CONC_REQUEST_ID,
275: FND_GLOBAL.CONC_PROGRAM_ID,
268: 'Y',
269: NVL(FND_GLOBAL.USER_ID,-1),
270: SYSDATE,
271: NVL(FND_GLOBAL.USER_ID,-1),
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
274: FND_GLOBAL.CONC_REQUEST_ID,
275: FND_GLOBAL.CONC_PROGRAM_ID,
276: FND_GLOBAL.PROG_APPL_ID,
270: SYSDATE,
271: NVL(FND_GLOBAL.USER_ID,-1),
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
274: FND_GLOBAL.CONC_REQUEST_ID,
275: FND_GLOBAL.CONC_PROGRAM_ID,
276: FND_GLOBAL.PROG_APPL_ID,
277: SYSDATE
278: FROM
271: NVL(FND_GLOBAL.USER_ID,-1),
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
274: FND_GLOBAL.CONC_REQUEST_ID,
275: FND_GLOBAL.CONC_PROGRAM_ID,
276: FND_GLOBAL.PROG_APPL_ID,
277: SYSDATE
278: FROM
279: FND_LOOKUP_TYPES_TL LT,
272: NVL(FND_GLOBAL.LOGIN_ID,-1),
273: SYSDATE,
274: FND_GLOBAL.CONC_REQUEST_ID,
275: FND_GLOBAL.CONC_PROGRAM_ID,
276: FND_GLOBAL.PROG_APPL_ID,
277: SYSDATE
278: FROM
279: FND_LOOKUP_TYPES_TL LT,
280: FND_LOOKUP_VALUES LV,
387: LV.START_DATE_ACTIVE,
388: LV.END_DATE_ACTIVE,
389: LV.ENABLED_FLAG,
390: 'Y',
391: NVL(FND_GLOBAL.USER_ID,-1),
392: SYSDATE,
393: NVL(FND_GLOBAL.USER_ID,-1),
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
389: LV.ENABLED_FLAG,
390: 'Y',
391: NVL(FND_GLOBAL.USER_ID,-1),
392: SYSDATE,
393: NVL(FND_GLOBAL.USER_ID,-1),
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
396: FND_GLOBAL.CONC_REQUEST_ID,
397: FND_GLOBAL.CONC_PROGRAM_ID,
390: 'Y',
391: NVL(FND_GLOBAL.USER_ID,-1),
392: SYSDATE,
393: NVL(FND_GLOBAL.USER_ID,-1),
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
396: FND_GLOBAL.CONC_REQUEST_ID,
397: FND_GLOBAL.CONC_PROGRAM_ID,
398: FND_GLOBAL.PROG_APPL_ID,
392: SYSDATE,
393: NVL(FND_GLOBAL.USER_ID,-1),
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
396: FND_GLOBAL.CONC_REQUEST_ID,
397: FND_GLOBAL.CONC_PROGRAM_ID,
398: FND_GLOBAL.PROG_APPL_ID,
399: SYSDATE
400: FROM
393: NVL(FND_GLOBAL.USER_ID,-1),
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
396: FND_GLOBAL.CONC_REQUEST_ID,
397: FND_GLOBAL.CONC_PROGRAM_ID,
398: FND_GLOBAL.PROG_APPL_ID,
399: SYSDATE
400: FROM
401: FND_LOOKUP_TYPES_TL LT,
394: NVL(FND_GLOBAL.LOGIN_ID,-1),
395: SYSDATE,
396: FND_GLOBAL.CONC_REQUEST_ID,
397: FND_GLOBAL.CONC_PROGRAM_ID,
398: FND_GLOBAL.PROG_APPL_ID,
399: SYSDATE
400: FROM
401: FND_LOOKUP_TYPES_TL LT,
402: FND_LOOKUP_VALUES LV,
458: LV.START_DATE_ACTIVE,
459: LV.END_DATE_ACTIVE,
460: LV.ENABLED_FLAG,
461: 'Y',
462: NVL(FND_GLOBAL.USER_ID,-1),
463: SYSDATE,
464: NVL(FND_GLOBAL.USER_ID,-1),
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
460: LV.ENABLED_FLAG,
461: 'Y',
462: NVL(FND_GLOBAL.USER_ID,-1),
463: SYSDATE,
464: NVL(FND_GLOBAL.USER_ID,-1),
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
467: FND_GLOBAL.CONC_REQUEST_ID,
468: FND_GLOBAL.CONC_PROGRAM_ID,
461: 'Y',
462: NVL(FND_GLOBAL.USER_ID,-1),
463: SYSDATE,
464: NVL(FND_GLOBAL.USER_ID,-1),
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
467: FND_GLOBAL.CONC_REQUEST_ID,
468: FND_GLOBAL.CONC_PROGRAM_ID,
469: FND_GLOBAL.PROG_APPL_ID,
463: SYSDATE,
464: NVL(FND_GLOBAL.USER_ID,-1),
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
467: FND_GLOBAL.CONC_REQUEST_ID,
468: FND_GLOBAL.CONC_PROGRAM_ID,
469: FND_GLOBAL.PROG_APPL_ID,
470: SYSDATE
471: FROM
464: NVL(FND_GLOBAL.USER_ID,-1),
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
467: FND_GLOBAL.CONC_REQUEST_ID,
468: FND_GLOBAL.CONC_PROGRAM_ID,
469: FND_GLOBAL.PROG_APPL_ID,
470: SYSDATE
471: FROM
472: FND_LOOKUP_TYPES_TL LT,
465: NVL(FND_GLOBAL.LOGIN_ID,-1),
466: SYSDATE,
467: FND_GLOBAL.CONC_REQUEST_ID,
468: FND_GLOBAL.CONC_PROGRAM_ID,
469: FND_GLOBAL.PROG_APPL_ID,
470: SYSDATE
471: FROM
472: FND_LOOKUP_TYPES_TL LT,
473: FND_LOOKUP_VALUES LV,
504: LV.START_DATE_ACTIVE,
505: LV.END_DATE_ACTIVE,
506: LV.ENABLED_FLAG,
507: 'Y',
508: NVL(FND_GLOBAL.USER_ID,-1),
509: SYSDATE,
510: NVL(FND_GLOBAL.USER_ID,-1),
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
506: LV.ENABLED_FLAG,
507: 'Y',
508: NVL(FND_GLOBAL.USER_ID,-1),
509: SYSDATE,
510: NVL(FND_GLOBAL.USER_ID,-1),
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
513: FND_GLOBAL.CONC_REQUEST_ID,
514: FND_GLOBAL.CONC_PROGRAM_ID,
507: 'Y',
508: NVL(FND_GLOBAL.USER_ID,-1),
509: SYSDATE,
510: NVL(FND_GLOBAL.USER_ID,-1),
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
513: FND_GLOBAL.CONC_REQUEST_ID,
514: FND_GLOBAL.CONC_PROGRAM_ID,
515: FND_GLOBAL.PROG_APPL_ID,
509: SYSDATE,
510: NVL(FND_GLOBAL.USER_ID,-1),
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
513: FND_GLOBAL.CONC_REQUEST_ID,
514: FND_GLOBAL.CONC_PROGRAM_ID,
515: FND_GLOBAL.PROG_APPL_ID,
516: SYSDATE
517: FROM
510: NVL(FND_GLOBAL.USER_ID,-1),
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
513: FND_GLOBAL.CONC_REQUEST_ID,
514: FND_GLOBAL.CONC_PROGRAM_ID,
515: FND_GLOBAL.PROG_APPL_ID,
516: SYSDATE
517: FROM
518: FND_LOOKUP_TYPES_TL LT,
511: NVL(FND_GLOBAL.LOGIN_ID,-1),
512: SYSDATE,
513: FND_GLOBAL.CONC_REQUEST_ID,
514: FND_GLOBAL.CONC_PROGRAM_ID,
515: FND_GLOBAL.PROG_APPL_ID,
516: SYSDATE
517: FROM
518: FND_LOOKUP_TYPES_TL LT,
519: FND_LOOKUP_VALUES LV,