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.PSP_XMLGEN dependencies on FND_LOOKUP_VALUES

Line 63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '

59: || 'psp_general.get_person_name(prth.initiator_person_id, TRUNC(SYSDATE))) initiated_by, '
60: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
61: || 'FROM psp_report_templates_h prth, xdo_templates_tl xtt, '
62: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv1, '
63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '
64: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv3, '
65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '
66: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv5, '
67: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv6, '

Line 65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '

61: || 'FROM psp_report_templates_h prth, xdo_templates_tl xtt, '
62: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv1, '
63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '
64: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv3, '
65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '
66: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv5, '
67: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv6, '
68: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv7, '
69: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv8 WHERE '

Line 67: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv6, '

63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '
64: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv3, '
65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '
66: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv5, '
67: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv6, '
68: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv7, '
69: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv8 WHERE '
70: || 'prth.request_id = ' || TO_CHAR(p_request_id)
71: || 'AND flv1.lookup_code = prth.parameter_value_5 '

Line 69: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv8 WHERE '

65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '
66: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv5, '
67: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv6, '
68: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv7, '
69: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv8 WHERE '
70: || 'prth.request_id = ' || TO_CHAR(p_request_id)
71: || 'AND flv1.lookup_code = prth.parameter_value_5 '
72: || 'AND flv2.lookup_code = prth.parameter_value_6 '
73: || 'AND flv3.lookup_code = prth.parameter_value_7 '

Line 155: fnd_lookup_values flv1,

151: ' ''' || flv1.meaning || ''' ' sort_option_description,
152: ' ''' || flv2.meaning || ''' ' order_by_description
153: FROM psp_report_template_details_h prtdh,
154: psp_report_templates_h prth,
155: fnd_lookup_values flv1,
156: fnd_lookup_values flv2,
157: psp_layout_options plo
158: WHERE prtdh.request_id = p_request_id
159: AND prth.request_id = p_request_id

Line 156: fnd_lookup_values flv2,

152: ' ''' || flv2.meaning || ''' ' order_by_description
153: FROM psp_report_template_details_h prtdh,
154: psp_report_templates_h prth,
155: fnd_lookup_values flv1,
156: fnd_lookup_values flv2,
157: psp_layout_options plo
158: WHERE prtdh.request_id = p_request_id
159: AND prth.request_id = p_request_id
160: AND plo.report_template_code = prth.report_template_code

Line 177: fnd_lookup_values flv1,

173: ' ''' || flv1.meaning || ''' ' sort_option_description,
174: ' ''' || flv2.meaning || ''' ' order_by_description
175: FROM psp_report_template_details_h prtdh,
176: psp_report_templates_h prth,
177: fnd_lookup_values flv1,
178: fnd_lookup_values flv2,
179: psp_layout_options plo
180: WHERE prth.request_id = p_request_id
181: AND prtdh.request_id = p_request_id

Line 178: fnd_lookup_values flv2,

174: ' ''' || flv2.meaning || ''' ' order_by_description
175: FROM psp_report_template_details_h prtdh,
176: psp_report_templates_h prth,
177: fnd_lookup_values flv1,
178: fnd_lookup_values flv2,
179: psp_layout_options plo
180: WHERE prth.request_id = p_request_id
181: AND prtdh.request_id = p_request_id
182: AND plo.report_template_code = prth.report_template_code

Line 591: fnd_lookup_values flv1,

587: CURSOR sort_option_cur (p_template_id IN NUMBER) IS
588: SELECT DISTINCT prtd.criteria_value1,
589: plo.value1 || ' ' || DECODE(prtd.criteria_value2, 'A', 'ASC', 'DESC') sort_option
590: FROM psp_report_template_details prtd,
591: fnd_lookup_values flv1,
592: fnd_lookup_values flv2,
593: psp_layout_options plo
594: WHERE prtd.template_id = p_template_id
595: AND flv1.lookup_code = prtd.criteria_lookup_code

Line 592: fnd_lookup_values flv2,

588: SELECT DISTINCT prtd.criteria_value1,
589: plo.value1 || ' ' || DECODE(prtd.criteria_value2, 'A', 'ASC', 'DESC') sort_option
590: FROM psp_report_template_details prtd,
591: fnd_lookup_values flv1,
592: fnd_lookup_values flv2,
593: psp_layout_options plo
594: WHERE prtd.template_id = p_template_id
595: AND flv1.lookup_code = prtd.criteria_lookup_code
596: AND flv1.lookup_type = 'PSP_SORTING_CRITERIA'

Line 819: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '

815: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_actual_cost_share, '
816: || 'TRIM(MAX(lookup.lookup_code)) category_code, '
817: || 'TRIM(MAX(lookup.meaning)) category_desc '
818: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera, '
819: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '
820: || 'WHERE perd.grouping_category = plo.layout_lookup_code '
821: || 'AND plo.layout_lookup_code = lookup.lookup_code '
822: || 'AND plo.layout_lookup_type =''PSP_EFFORT_CATEGORY'' '
823: || 'AND lookup.lookup_type = ''PSP_EFFORT_CATEGORY'' '