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 242: FROM gl_sets_of_books gsob

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

Line 248: gl_sets_of_books gsob,

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

Line 1681: FROM gl_sets_of_books gsob

1677: AND ROWNUM = 1;
1678:
1679: CURSOR get_segment_delimeter_cur IS
1680: SELECT fnd_flex_ext.get_delimiter('SQLGL', 'GL#', gsob.chart_of_accounts_id)
1681: FROM gl_sets_of_books gsob
1682: WHERE gsob.set_of_books_id = l_set_of_books_id;
1683:
1684: CURSOR get_segment_name_cur IS
1685: SELECT 'GL_' || fifs.application_column_name || ' || ''' || l_segment_delimiter || ''' || ' segment_name

Line 1687: gl_sets_of_books gsob,

1683:
1684: CURSOR get_segment_name_cur IS
1685: SELECT 'GL_' || fifs.application_column_name || ' || ''' || l_segment_delimiter || ''' || ' segment_name
1686: FROM fnd_id_flex_segments fifs,
1687: gl_sets_of_books gsob,
1688: fnd_application fa
1689: WHERE gsob.set_of_books_id = l_set_of_books_id
1690: AND fifs.id_flex_num = gsob.chart_of_accounts_id
1691: AND fifs.id_flex_code = 'GL#'