eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_LOG_PKG dependencies on CS_LOOKUPS

Line 40: from cs_lookups

36: order by last_update_date ;
37:
38: Cursor c1log is
39: select meaning
40: from cs_lookups
41: where lookup_type = 'CS_LOG_PARAMETERS'
42: and lookup_code = 'LOG_AUDIT'
43: and enabled_flag = 'Y'
44: and sysdate between NVL(start_date_active,sysdate) and

Line 49: from cs_lookups

45: NVL(end_date_active,sysdate);
46:
47: Cursor c2log is
48: select meaning
49: from cs_lookups
50: where lookup_type = 'CS_LOG_PARAMETERS'
51: and lookup_code = 'LOG_NOTES'
52: and enabled_flag = 'Y'
53: and sysdate between NVL(start_date_active,sysdate) and

Line 58: from cs_lookups

54: NVL(end_date_active,sysdate);
55:
56: Cursor c3log is
57: select meaning
58: from cs_lookups
59: where lookup_type = 'CS_LOG_PARAMETERS'
60: and lookup_code = 'LOG_TASKS'
61: and enabled_flag = 'Y'
62: and sysdate between NVL(start_date_active,sysdate) and

Line 363: from cs_lookups

359: ls_details VARCHAR2(32767);
360:
361: Cursor c_status is
362: select meaning
363: from cs_lookups
364: where lookup_type = 'CS_LOG_PARAMETERS'
365: and lookup_code = 'LOG_STATUS'
366: and enabled_flag = 'Y'
367: and sysdate between NVL(start_date_active,sysdate) and

Line 372: from cs_lookups

368: NVL(end_date_active,sysdate);
369:
370: Cursor c_urgency is
371: select meaning
372: from cs_lookups
373: where lookup_type = 'CS_LOG_PARAMETERS'
374: and lookup_code = 'LOG_URGENCY'
375: and enabled_flag = 'Y'
376: and sysdate between NVL(start_date_active,sysdate) and

Line 382: from cs_lookups

378:
379:
380: Cursor c_severity is
381: select meaning
382: from cs_lookups
383: where lookup_type = 'CS_LOG_PARAMETERS'
384: and lookup_code = 'LOG_SEVERITY'
385: and enabled_flag = 'Y'
386: and sysdate between NVL(start_date_active,sysdate) and

Line 391: from cs_lookups

387: NVL(end_date_active,sysdate);
388:
389: Cursor c_date is
390: select meaning
391: from cs_lookups
392: where lookup_type = 'CS_LOG_PARAMETERS'
393: and lookup_code = 'LOG_DATE'
394: and enabled_flag = 'Y'
395: and sysdate between NVL(start_date_active,sysdate) and

Line 400: from cs_lookups

396: NVL(end_date_active,sysdate);
397:
398: Cursor c_obligation_date is
399: select meaning
400: from cs_lookups
401: where lookup_type = 'CS_LOG_PARAMETERS'
402: and lookup_code = 'LOG_OBLIGATION_DATE'
403: and enabled_flag = 'Y'
404: and sysdate between NVL(start_date_active,sysdate) and

Line 409: from cs_lookups

405: NVL(end_date_active,sysdate);
406:
407: Cursor c_owner is
408: select meaning
409: from cs_lookups
410: where lookup_type = 'CS_LOG_PARAMETERS'
411: and lookup_code = 'LOG_OWNER'
412: and enabled_flag = 'Y'
413: and sysdate between NVL(start_date_active,sysdate) and

Line 418: from cs_lookups

414: NVL(end_date_active,sysdate);
415:
416: Cursor c_bill_to_contact_name is
417: select meaning
418: from cs_lookups
419: where lookup_type = 'CS_LOG_PARAMETERS'
420: and lookup_code = 'LOG_BILL_TO_CONTACT_NAME'
421: and enabled_flag = 'Y'
422: and sysdate between NVL(start_date_active,sysdate) and

Line 427: from cs_lookups

423: NVL(end_date_active,sysdate);
424:
425: Cursor c_ship_to_contact_name is
426: select meaning
427: from cs_lookups
428: where lookup_type = 'CS_LOG_PARAMETERS'
429: and lookup_code = 'LOG_SHIP_TO_CONTACT_NAME'
430: and enabled_flag = 'Y'
431: and sysdate between NVL(start_date_active,sysdate) and

Line 436: from cs_lookups

432: NVL(end_date_active,sysdate);
433:
434: Cursor c_product is
435: select meaning
436: from cs_lookups
437: where lookup_type = 'CS_LOG_PARAMETERS'
438: and lookup_code = 'LOG_PRODUCT'
439: and enabled_flag = 'Y'
440: and sysdate between NVL(start_date_active,sysdate) and

Line 445: from cs_lookups

441: NVL(end_date_active,sysdate);
442:
443: Cursor c_type is
444: select meaning
445: from cs_lookups
446: where lookup_type = 'CS_LOG_PARAMETERS'
447: and lookup_code = 'LOG_TYPE'
448: and enabled_flag = 'Y'
449: and sysdate between NVL(start_date_active,sysdate) and

Line 454: from cs_lookups

450: NVL(end_date_active,sysdate);
451:
452: Cursor c_group is
453: select meaning
454: from cs_lookups
455: where lookup_type = 'CS_LOG_PARAMETERS'
456: and lookup_code = 'LOG_GROUP'
457: and enabled_flag = 'Y'
458: and sysdate between NVL(start_date_active,sysdate) and

Line 463: from cs_lookups

459: NVL(end_date_active,sysdate);
460:
461: Cursor c_language is
462: select meaning
463: from cs_lookups
464: where lookup_type = 'CS_LOG_PARAMETERS'
465: and lookup_code = 'LOG_LANGUAGE'
466: and enabled_flag = 'Y'
467: and sysdate between NVL(start_date_active,sysdate) and

Line 472: from cs_lookups

468: NVL(end_date_active,sysdate);
469:
470: Cursor c_platform is
471: select meaning
472: from cs_lookups
473: where lookup_type = 'CS_LOG_PARAMETERS'
474: and lookup_code = 'LOG_PLATFORM'
475: and enabled_flag = 'Y'
476: and sysdate between NVL(start_date_active,sysdate) and

Line 481: from cs_lookups

477: NVL(end_date_active,sysdate);
478:
479: Cursor c_platform_version is
480: select meaning
481: from cs_lookups
482: where lookup_type = 'CS_LOG_PARAMETERS'
483: and lookup_code = 'LOG_PLATFORM_VERSION'
484: and enabled_flag = 'Y'
485: and sysdate between NVL(start_date_active,sysdate) and

Line 490: from cs_lookups

486: NVL(end_date_active,sysdate);
487:
488: Cursor c_site is
489: select meaning
490: from cs_lookups
491: where lookup_type = 'CS_LOG_PARAMETERS'
492: and lookup_code = 'LOG_SITE'
493: and enabled_flag = 'Y'
494: and sysdate between NVL(start_date_active,sysdate) and

Line 768: from cs_lookups

764: ORDER BY 1;
765:
766: Cursor c2log is
767: select meaning
768: from cs_lookups
769: where lookup_type = 'CS_LOG_PARAMETERS'
770: and lookup_code = 'LOG_NOTES'
771: and enabled_flag = 'Y'
772: and sysdate between NVL(start_date_active,sysdate) and