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 153: fnd_lookup_values flv1,

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

Line 154: fnd_lookup_values flv2,

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

Line 175: fnd_lookup_values flv1,

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

Line 176: fnd_lookup_values flv2,

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

Line 587: fnd_lookup_values flv1,

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

Line 588: fnd_lookup_values flv2,

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

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

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