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.JTF_OBJECT_LOV_DTLS_V

Source

View Text - Preformatted


(Select
JOT.NAME as OBJECT_NAME,
JOT.OBJECT_CODE,
JOU.OBJECT_USER_CODE,
JOLD.PG_REGION_PATH,
JOPP.source_param,
JOPP.dest_param,
JOLD.APPLICATION_ID,
JOM.SOURCE_OBJECT_CODE
From
JTF_OBJECT_USAGES JOU,
JTF_OBJECT_PG_DTLS JOLD,
JTF_OBJECTS_TL JOT,
JTF_OBJECT_PG_PARAMS JOPP,
JTF_OBJECT_MAPPINGS JOM
Where
JOPP.OBJECT_DTLS_ID=JOLD.OBJECT_DTLS_ID and
JOT.OBJECT_CODE=JOU.OBJECT_CODE
and JOLD.OBJECT_CODE=JOT.OBJECT_CODE and
JOT.LANGUAGE = userenv('LANG')
and JOLD.APPLICATION_ID= apps.FND_GLOBAL.resp_appl_id
and JOLD.PAGE_TYPE ='OA_LOV'
and JOM.object_id=JOU.OBJECT_CODE
and JOM.object_code='JTF_OBJECT_RELATION')
union
(Select
JOT.NAME as OBJECT_NAME,
JOT.OBJECT_CODE,
JOU.OBJECT_USER_CODE,
JOLD.PG_REGION_PATH,
JOPP.source_param,
JOPP.dest_param,
JOLD.APPLICATION_ID,
JOM.SOURCE_OBJECT_CODE
From
JTF_OBJECT_USAGES JOU,
JTF_OBJECT_PG_DTLS JOLD,
JTF_OBJECTS_TL JOT,
JTF_OBJECT_PG_PARAMS JOPP,
JTF_OBJECTS_B JOB,
JTF_OBJECT_MAPPINGS JOM
Where
JOPP.OBJECT_DTLS_ID=JOLD.OBJECT_DTLS_ID and
JOT.OBJECT_CODE=JOU.OBJECT_CODE
and JOLD.OBJECT_CODE=JOT.object_code and
JOT.LANGUAGE = userenv('LANG') and
JOLD.APPLICATION_ID =JOB.application_id
and JOT.object_code=JOB.object_code
and  JOLD.PAGE_TYPE='OA_LOV'
and JOM.object_id=JOU.OBJECT_CODE
and JOM.object_code='JTF_OBJECT_RELATION'
and not exists (select 1 from JTF_OBJECT_PG_DTLS L
Where L.OBJECT_CODE=JOB.OBJECT_CODE and
L.APPLICATION_ID= apps.FND_GLOBAL.resp_appl_id and PAGE_TYPE='OA_LOV' and rownum=1)  )

View Text - HTML Formatted

(SELECT JOT.NAME AS OBJECT_NAME
, JOT.OBJECT_CODE
, JOU.OBJECT_USER_CODE
, JOLD.PG_REGION_PATH
, JOPP.SOURCE_PARAM
, JOPP.DEST_PARAM
, JOLD.APPLICATION_ID
, JOM.SOURCE_OBJECT_CODE FROM JTF_OBJECT_USAGES JOU
, JTF_OBJECT_PG_DTLS JOLD
, JTF_OBJECTS_TL JOT
, JTF_OBJECT_PG_PARAMS JOPP
, JTF_OBJECT_MAPPINGS JOM WHERE JOPP.OBJECT_DTLS_ID=JOLD.OBJECT_DTLS_ID AND JOT.OBJECT_CODE=JOU.OBJECT_CODE AND JOLD.OBJECT_CODE=JOT.OBJECT_CODE AND JOT.LANGUAGE = USERENV('LANG') AND JOLD.APPLICATION_ID= APPS.FND_GLOBAL.RESP_APPL_ID AND JOLD.PAGE_TYPE ='OA_LOV' AND JOM.OBJECT_ID=JOU.OBJECT_CODE AND JOM.OBJECT_CODE='JTF_OBJECT_RELATION') UNION (SELECT JOT.NAME AS OBJECT_NAME
, JOT.OBJECT_CODE
, JOU.OBJECT_USER_CODE
, JOLD.PG_REGION_PATH
, JOPP.SOURCE_PARAM
, JOPP.DEST_PARAM
, JOLD.APPLICATION_ID
, JOM.SOURCE_OBJECT_CODE FROM JTF_OBJECT_USAGES JOU
, JTF_OBJECT_PG_DTLS JOLD
, JTF_OBJECTS_TL JOT
, JTF_OBJECT_PG_PARAMS JOPP
, JTF_OBJECTS_B JOB
, JTF_OBJECT_MAPPINGS JOM WHERE JOPP.OBJECT_DTLS_ID=JOLD.OBJECT_DTLS_ID AND JOT.OBJECT_CODE=JOU.OBJECT_CODE AND JOLD.OBJECT_CODE=JOT.OBJECT_CODE AND JOT.LANGUAGE = USERENV('LANG') AND JOLD.APPLICATION_ID =JOB.APPLICATION_ID AND JOT.OBJECT_CODE=JOB.OBJECT_CODE AND JOLD.PAGE_TYPE='OA_LOV' AND JOM.OBJECT_ID=JOU.OBJECT_CODE AND JOM.OBJECT_CODE='JTF_OBJECT_RELATION' AND NOT EXISTS (SELECT 1
FROM JTF_OBJECT_PG_DTLS L WHERE L.OBJECT_CODE=JOB.OBJECT_CODE AND L.APPLICATION_ID= APPS.FND_GLOBAL.RESP_APPL_ID
AND PAGE_TYPE='OA_LOV'
AND ROWNUM=1) )