VIEW: APPS.JTM_JTF_OBJECTS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.OBJECT_CODE , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , TL.NAME , TL.LANGUAGE FROM JTF_OBJECTS_B B , JTF_OBJECTS_TL TL , JTM_JTF_OBJECTS_ACC ACC WHERE B.OBJECT_CODE = TL.OBJECT_CODE AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND ACC.OBJECT_CODE = B.OBJECT_CODE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.OBJECT_CODE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, TL.NAME
, TL.LANGUAGE
FROM JTF_OBJECTS_B B
, JTF_OBJECTS_TL TL
, JTM_JTF_OBJECTS_ACC ACC
WHERE B.OBJECT_CODE = TL.OBJECT_CODE
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.OBJECT_CODE = B.OBJECT_CODE