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.

VIEW: APPS.SO_REPORT_SET_LINES_V

Source

View Text - Preformatted


SELECT RSL.ROWID ROW_ID , RSL.CREATION_DATE , RSL.CREATED_BY , RSL.LAST_UPDATE_DATE , RSL.LAST_UPDATED_BY , RSL.LAST_UPDATE_LOGIN , R.DESCRIPTION , F.USER_CONCURRENT_PROGRAM_NAME NAME , RSL.REPORT_SET_LINE_ID , RSL.REPORT_SET_ID , RSL.REPORT_ID , RSL.REPORT_SEQUENCE FROM FND_CONCURRENT_PROGRAMS_VL F, SO_REPORTS R, SO_REPORT_SET_LINES RSL WHERE RSL.REPORT_ID = R.REPORT_ID AND R.NAME = F.CONCURRENT_PROGRAM_NAME

View Text - HTML Formatted

SELECT RSL.ROWID ROW_ID
, RSL.CREATION_DATE
, RSL.CREATED_BY
, RSL.LAST_UPDATE_DATE
, RSL.LAST_UPDATED_BY
, RSL.LAST_UPDATE_LOGIN
, R.DESCRIPTION
, F.USER_CONCURRENT_PROGRAM_NAME NAME
, RSL.REPORT_SET_LINE_ID
, RSL.REPORT_SET_ID
, RSL.REPORT_ID
, RSL.REPORT_SEQUENCE
FROM FND_CONCURRENT_PROGRAMS_VL F
, SO_REPORTS R
, SO_REPORT_SET_LINES RSL
WHERE RSL.REPORT_ID = R.REPORT_ID
AND R.NAME = F.CONCURRENT_PROGRAM_NAME