View: JTF_OBJECT_LOV_DTLS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.JTF_OBJECT_LOV_DTLS_V

View Text

(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) )