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: APPLSYS.FND_CONC_REL_DISJ_MEMBERS#

Source

View Text - Preformatted


select DISJUNCTION_APPLICATION_ID DISJUNCTION_APPLICATION_ID, DISJUNCTION_ID DISJUNCTION_ID, PERIOD_OR_STATE_FLAG PERIOD_OR_STATE_FLAG, NEGATION_FLAG NEGATION_FLAG, OWNER_REQ_ID OWNER_REQ_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, STATE_APPLICATION_ID STATE_APPLICATION_ID, STATE_ID STATE_ID, PERIOD_APPLICATION_ID PERIOD_APPLICATION_ID, PERIOD_ID PERIOD_ID, STATUS_VALUE STATUS_VALUE, OWNER_SCH_ID OWNER_SCH_ID, OWNER_SCH_APP_ID OWNER_SCH_APP_ID from "APPLSYS"."FND_CONC_REL_DISJ_MEMBERS"

View Text - HTML Formatted

SELECT DISJUNCTION_APPLICATION_ID DISJUNCTION_APPLICATION_ID
, DISJUNCTION_ID DISJUNCTION_ID
, PERIOD_OR_STATE_FLAG PERIOD_OR_STATE_FLAG
, NEGATION_FLAG NEGATION_FLAG
, OWNER_REQ_ID OWNER_REQ_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, STATE_APPLICATION_ID STATE_APPLICATION_ID
, STATE_ID STATE_ID
, PERIOD_APPLICATION_ID PERIOD_APPLICATION_ID
, PERIOD_ID PERIOD_ID
, STATUS_VALUE STATUS_VALUE
, OWNER_SCH_ID OWNER_SCH_ID
, OWNER_SCH_APP_ID OWNER_SCH_APP_ID
FROM "APPLSYS"."FND_CONC_REL_DISJ_MEMBERS"