TU_SR_TRANSCPT_REQ_STDTS

Steps:

  1. Click the Query link.   Step 1
  2. Click the Query Manager link.   Step 2
  3. Click the Create New Query link.   Step 3
  4. Enter the desired information into the begins with field. Enter "SA_R".   Step 4
  5. Click the Search button.   Step 5
  6. Click an entry in the Add Record column.   Step 6
  7. Click the option.   Step 7
  8. Click the option.   Step 8
  9. Click the option.   Step 9
  10. Click the Records tab.   Step 10
  11. Click an entry in the Join Record column.   Step 11
  12. Click the A = SA_REQUEST_DTL - Request Details link.   Step 12
  13. Click the Add Criteria button.   Step 13
  14. Click the option.   Step 14
  15. Click the option.   Step 15
  16. Point to the object.   Step 16
  17. Click the option.   Step 17
  18. Click the option.   Step 18
  19. Scroll the object with the mouse wheel.   Step 19
  20. Click the option.   Step 20
  21. Release the mouse button.   Step 21
  22. Click the Records tab.   Step 22
  23. Enter the desired information into the begins with field. Enter "names".   Step 23
  24. Click the Search button.   Step 24
  25. Click an entry in the Join Record column.   Step 25
  26. Click the A = SA_REQUEST_DTL - Request Details link.   Step 26
  27. Click the Add Criteria button.   Step 27
  28. Click the OK button.   Step 28
  29. Click the option.   Step 29
  30. Click the option.   Step 30
  31. Click the Fields tab.   Step 31
  32. Click the Add Criteria button.   Step 32
  33. Click the Prompt option.   Step 33
  34. Click the New Prompt link.   Step 34
  35. Click the Heading Type list.   Step 35
  36. Click the Text list item.   Step 36
  37. Enter the desired information into the Heading Text field. Enter "Enter Request Date".   Step 37
  38. Enter the desired information into the Length field. Enter "10".   Step 38
  39. Click the OK button.   Step 39
  40. Click the OK button.   Step 40
  41. Click the Add Criteria button.   Step 41
  42. Enter the desired information into the Constant field. Enter "SAOFF".   Step 42
  43. Click the OK button.   Step 43
  44. Click the Edit button.   Step 44
  45. Click the Long option.   Step 45
  46. Click the OK button.   Step 46
  47. Click the Reorder / Sort button.   Step 47
  48. Enter the desired information into the New Order By field. Enter "1".   Step 48
  49. Click the OK button.   Step 49
  50. Click the Add Criteria button.   Step 50
  51. Enter the desired information into the Constant field. Enter "PRI".   Step 51
  52. Click the OK button.   Step 52
  53. Click the Criteria tab.   Step 53
  54. Click the Save Query button.   Step 54
  55. Enter the desired information into the Query field. Enter "TU_SR_TRANSCPT_REQ_STDT".   Step 55
  56. Enter the desired information into the Description field. Enter "Stdt SAOFF transcript reqt".   Step 56
  57. Click the Owner list.   Step 57
  58. Click the Public list item.   Step 58
  59. Click the OK button.   Step 59
  60. Click the View SQL tab.   Step 60
  61. Click the Run tab.   Step 61

Table of Contents   Start Topic