VIEW: APPS.JTM_AK_REGION_LOV_REL_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, REL.REGION_APPLICATION_ID, REL.REGION_CODE, REL.ATTRIBUTE_APPLICATION_ID, REL.ATTRIBUTE_CODE, REL.LOV_REGION_APPL_ID, REL.LOV_REGION_CODE, REL.LOV_ATTRIBUTE_APPL_ID, REL. LOV_ATTRIBUTE_CODE, REL.BASE_REGION_APPL_ID, REL.BASE_REGION_CODE, REL.BASE_ATTRIBUTE_APPL_ID, REL.BASE_ATTRIBUTE_CODE, REL.DIRECTION_FLAG, REL.LAST_UPDATE_DATE, REL.LAST_UPDATED_BY, REL.CREATION_DATE, REL.CREATED_BY, REL.LAST_UPDATE_LOGIN, REL.REQUIRED_FLAG FROM ak_region_lov_relations REL, JTM_AK_REGION_LOV_REL_ACC ACC WHERE REL.region_application_id = ACC.REGION_APPLICATION_ID AND REL.REGION_CODE=ACC.REGION_CODE AND REL.ATTRIBUTE_APPLICATION_ID= ACC.ATTRIBUTE_APPLICATION_ID AND REL.ATTRIBUTE_CODE=ACC.ATTRIBUTE_CODE AND REL.LOV_REGION_APPL_ID=ACC.LOV_REGION_APPL_ID AND REL.LOV_REGION_CODE=ACC.LOV_REGION_CODE AND REL.LOV_ATTRIBUTE_APPL_ID=ACC.LOV_ATTRIBUTE_APPL_ID AND REL.LOV_ATTRIBUTE_CODE=ACC.LOV_ATTRIBUTE_CODE AND REL.BASE_REGION_APPL_ID=ACC.BASE_REGION_APPL_ID AND REL.BASE_REGION_CODE=ACC.BASE_REGION_CODE AND REL.BASE_ATTRIBUTE_APPL_ID=ACC.BASE_ATTRIBUTE_APPL_ID AND REL.BASE_ATTRIBUTE_CODE=ACC.BASE_ATTRIBUTE_CODE AND REL.DIRECTION_FLAG=ACC.DIRECTION_FLAG

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, REL.REGION_APPLICATION_ID
, REL.REGION_CODE
, REL.ATTRIBUTE_APPLICATION_ID
, REL.ATTRIBUTE_CODE
, REL.LOV_REGION_APPL_ID
, REL.LOV_REGION_CODE
, REL.LOV_ATTRIBUTE_APPL_ID
, REL. LOV_ATTRIBUTE_CODE
, REL.BASE_REGION_APPL_ID
, REL.BASE_REGION_CODE
, REL.BASE_ATTRIBUTE_APPL_ID
, REL.BASE_ATTRIBUTE_CODE
, REL.DIRECTION_FLAG
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.REQUIRED_FLAG
FROM AK_REGION_LOV_RELATIONS REL
, JTM_AK_REGION_LOV_REL_ACC ACC
WHERE REL.REGION_APPLICATION_ID = ACC.REGION_APPLICATION_ID
AND REL.REGION_CODE=ACC.REGION_CODE
AND REL.ATTRIBUTE_APPLICATION_ID= ACC.ATTRIBUTE_APPLICATION_ID
AND REL.ATTRIBUTE_CODE=ACC.ATTRIBUTE_CODE
AND REL.LOV_REGION_APPL_ID=ACC.LOV_REGION_APPL_ID
AND REL.LOV_REGION_CODE=ACC.LOV_REGION_CODE
AND REL.LOV_ATTRIBUTE_APPL_ID=ACC.LOV_ATTRIBUTE_APPL_ID
AND REL.LOV_ATTRIBUTE_CODE=ACC.LOV_ATTRIBUTE_CODE
AND REL.BASE_REGION_APPL_ID=ACC.BASE_REGION_APPL_ID
AND REL.BASE_REGION_CODE=ACC.BASE_REGION_CODE
AND REL.BASE_ATTRIBUTE_APPL_ID=ACC.BASE_ATTRIBUTE_APPL_ID
AND REL.BASE_ATTRIBUTE_CODE=ACC.BASE_ATTRIBUTE_CODE
AND REL.DIRECTION_FLAG=ACC.DIRECTION_FLAG