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 GL_SETS_OF_BOOKS

Line 240: FROM gl_sets_of_books gsob

236: AND ROWNUM = 1;
237:
238: CURSOR get_segment_delimeter_cur IS
239: SELECT fnd_flex_ext.get_delimiter('SQLGL', 'GL#', gsob.chart_of_accounts_id)
240: FROM gl_sets_of_books gsob
241: WHERE gsob.set_of_books_id = l_set_of_books_id;
242:
243: CURSOR get_segment_header_cur IS
244: SELECT fifs.segment_name || l_segment_delimiter segment_header

Line 246: gl_sets_of_books gsob,

242:
243: CURSOR get_segment_header_cur IS
244: SELECT fifs.segment_name || l_segment_delimiter segment_header
245: FROM fnd_id_flex_segments fifs,
246: gl_sets_of_books gsob,
247: fnd_application fa
248: WHERE gsob.set_of_books_id = l_set_of_books_id
249: AND fifs.id_flex_num = gsob.chart_of_accounts_id
250: AND fifs.id_flex_code = 'GL#'

Line 1669: FROM gl_sets_of_books gsob

1665: AND ROWNUM = 1;
1666:
1667: CURSOR get_segment_delimeter_cur IS
1668: SELECT fnd_flex_ext.get_delimiter('SQLGL', 'GL#', gsob.chart_of_accounts_id)
1669: FROM gl_sets_of_books gsob
1670: WHERE gsob.set_of_books_id = l_set_of_books_id;
1671:
1672: CURSOR get_segment_name_cur IS
1673: SELECT 'GL_' || fifs.application_column_name || ' || ''' || l_segment_delimiter || ''' || ' segment_name

Line 1675: gl_sets_of_books gsob,

1671:
1672: CURSOR get_segment_name_cur IS
1673: SELECT 'GL_' || fifs.application_column_name || ' || ''' || l_segment_delimiter || ''' || ' segment_name
1674: FROM fnd_id_flex_segments fifs,
1675: gl_sets_of_books gsob,
1676: fnd_application fa
1677: WHERE gsob.set_of_books_id = l_set_of_books_id
1678: AND fifs.id_flex_num = gsob.chart_of_accounts_id
1679: AND fifs.id_flex_code = 'GL#'