APPS.PSP_XMLGEN dependencies on PSP_REPORT_TEMPLATE_DETAILS_H

Line 153: FROM psp_report_template_details_h prtdh,

149: SELECT DISTINCT prtdh.criteria_value1,
150: plo.value1 || ' ' || DECODE(prtdh.criteria_value2, 'A', 'ASC', 'DESC') sort_option,
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

Line 175: FROM psp_report_template_details_h prtdh,

171: SELECT DISTINCT prtdh.criteria_value1,
172: plo.value1 || ' ' || DECODE(prtdh.criteria_value2, 'A', 'ASC', 'DESC') sort_option,
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

Line 256: FROM psp_report_template_details_h prtdh

252: AND fifs.id_flex_code = 'GL#'
253: AND fifs.application_id = fa.application_id
254: AND fa.application_short_name = 'SQLGL'
255: AND EXISTS (SELECT 1
256: FROM psp_report_template_details_h prtdh
257: WHERE prtdh.REQUEST_ID= p_request_id
258: AND prtdh.criteria_lookup_type = 'PSP_SUMMARIZATION_CRITERIA'
259: AND prtdh.criteria_lookup_code = fifs.application_column_name)
260: ORDER BY fifs.segment_num;

Line 609: from psp_report_template_details_h prtdh ,

605: CURSOR sort_option_cur (p_request_id IN NUMBER, p_business_group_id IN NUMBER) IS
606: select prtdh.criteria_value1,
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

Line 1695: FROM psp_report_template_details_h prtdh

1691: AND fifs.id_flex_code = 'GL#'
1692: AND fifs.application_id = fa.application_id
1693: AND fa.application_short_name = 'SQLGL'
1694: AND EXISTS (SELECT 1
1695: FROM psp_report_template_details_h prtdh
1696: WHERE prtdh.REQUEST_ID= p_request_id
1697: AND prtdh.criteria_lookup_type = 'PSP_SUMMARIZATION_CRITERIA'
1698: AND prtdh.criteria_lookup_code = fifs.application_column_name)
1699: ORDER BY fifs.segment_num;