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 PSP_LAYOUT_OPTIONS

Line 157: psp_layout_options plo

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
161: AND flv1.lookup_code = prtdh.criteria_lookup_code

Line 179: psp_layout_options plo

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
183: AND flv1.lookup_code = prtdh.criteria_lookup_code

Line 593: psp_layout_options plo

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'
597: AND prtd.criteria_lookup_type = 'PSP_SORTING_CRITERIA'

Line 611: ,psp_layout_options plo

607: decode (substr(prtdh.CRITERIA_LOOKUP_CODE,1,7),'SEGMENT','GL_'||prtdh.CRITERIA_LOOKUP_CODE,plo.VALUE1)
608: || ' ' || DECODE(criteria_value2, 'A', 'ASC', 'DESC') --decode plo.VALUE1
609: from psp_report_template_details_h prtdh ,
610: psp_report_templates_h prth
611: ,psp_layout_options plo
612: where prth.request_id= p_request_id-- 125338 --125188
613: and prth.request_id = prtdh.request_id
614: and prtdh.CRITERIA_LOOKUP_TYPE ='PSP_SORTING_CRITERIA'
615: and prtdh.CRITERIA_LOOKUP_TYPE = plo.LAYOUT_LOOKUP_TYPE

Line 643: psp_layout_options plo

639: /* Added for Hospital effort report */
640: CURSOR grouping_category_csr(p_assignment_id IN NUMBER) IS
641: SELECT distinct perd.grouping_category, plo.layout_option_order
642: FROM psp_eff_report_details perd,
643: psp_layout_options plo
644: WHERE effort_report_id = p_effort_report_id
645: AND NVL(assignment_id,-1) = NVL(p_assignment_id,-1)
646: AND plo.layout_lookup_type ='PSP_EFFORT_CATEGORY'
647: AND plo.LAYOUT_LOOKUP_CODE = perd.grouping_category

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'' '

Line 1715: FROM psp_layout_options

1711: l_project_manager_role VARCHAR2(30);
1712:
1713: CURSOR project_manager_role_cur IS
1714: SELECT layout_lookup_code
1715: FROM psp_layout_options
1716: WHERE report_template_code = TRIM(l_report_template_code)
1717: AND layout_lookup_type = 'PSP_PROJECT_MANAGER_ROLE';
1718:
1719: