VIEW: APPS.AK_REGION_LOV_RELATIONS_V

Source

View Text - Preformatted

SELECT ALR1.ROWID ROW_ID, ALR1.REGION_APPLICATION_ID, ARV1.APPLICATION_NAME REGION_APPLICATION_NAME, ALR1.REGION_CODE, ARV1.NAME REGION_NAME, ALR1.ATTRIBUTE_APPLICATION_ID, ALR1.ATTRIBUTE_CODE, ARI1.ATTRIBUTE_NAME ATTRIBUTE_NAME, ARI1.ITEM_NAME, ALR1.LOV_REGION_APPL_ID, ARV2.APPLICATION_NAME LOV_REGION_APPL_NAME, ALR1.LOV_REGION_CODE, ARV2.NAME LOV_REGION_NAME, ALR1.LOV_ATTRIBUTE_APPL_ID, ALR1.LOV_ATTRIBUTE_CODE, ARI2.ATTRIBUTE_NAME LOV_ATTRIBUTE_NAME, ARI2.ITEM_NAME LOV_ITEM_NAME, ALR1.BASE_REGION_APPL_ID, ALR1.BASE_REGION_CODE, ARV3.NAME BASE_REGION_NAME, ALR1.BASE_ATTRIBUTE_APPL_ID, ALR1.BASE_ATTRIBUTE_CODE, ARI3.ATTRIBUTE_NAME BASE_ATTRIBUTE_NAME, ARI3.ITEM_NAME BASE_ITEM_NAME, ALR1.DIRECTION_FLAG, ALR1.LAST_UPDATE_DATE, ALR1.LAST_UPDATED_BY, ALR1.CREATION_DATE, ALR1.CREATED_BY, ALR1.LAST_UPDATE_LOGIN , ALR1.REQUIRED_FLAG FROM AK_REGION_LOV_RELATIONS ALR1, AK_REGIONS_VL ARV1, AK_REGION_ITEMS_VL ARI1, AK_REGIONS_VL ARV2, AK_REGION_ITEMS_VL ARI2, AK_REGION_ITEMS_VL ARI3, AK_REGIONS_VL ARV3 WHERE ALR1.REGION_APPLICATION_ID = ARV1.REGION_APPLICATION_ID AND ALR1.REGION_CODE = ARV1.REGION_CODE AND ALR1.REGION_APPLICATION_ID = ARI1.REGION_APPLICATION_ID AND ALR1.REGION_CODE = ARI1.REGION_CODE AND ALR1.ATTRIBUTE_APPLICATION_ID = ARI1.ATTRIBUTE_APPLICATION_ID AND ALR1.ATTRIBUTE_CODE = ARI1.ATTRIBUTE_CODE AND ALR1.LOV_REGION_APPL_ID = ARV2.REGION_APPLICATION_ID AND ALR1.LOV_REGION_CODE = ARV2.REGION_CODE AND ALR1.BASE_REGION_APPL_ID = ARV3.REGION_APPLICATION_ID AND ALR1.BASE_REGION_CODE = ARV3.REGION_CODE AND ALR1.BASE_REGION_APPL_ID = ARI3.REGION_APPLICATION_ID AND ALR1.BASE_REGION_CODE = ARI3.REGION_CODE AND ALR1.BASE_ATTRIBUTE_APPL_ID = ARI3.ATTRIBUTE_APPLICATION_ID AND ALR1.BASE_ATTRIBUTE_CODE = ARI3.ATTRIBUTE_CODE AND ARV2.REGION_APPLICATION_ID = ARI2.REGION_APPLICATION_ID AND ARV2.REGION_CODE = ARI2.REGION_CODE AND ALR1.LOV_ATTRIBUTE_APPL_ID = ARI2.ATTRIBUTE_APPLICATION_ID AND ALR1.LOV_ATTRIBUTE_CODE = ARI2.ATTRIBUTE_CODE AND ALR1.BASE_REGION_APPL_ID = ARV3.REGION_APPLICATION_ID AND ALR1.BASE_REGION_CODE = ARV3.REGION_CODE AND ALR1.BASE_REGION_APPL_ID = ARI3.REGION_APPLICATION_ID AND ALR1.BASE_REGION_CODE = ARI3.REGION_CODE AND ALR1.BASE_ATTRIBUTE_APPL_ID = ARI3.ATTRIBUTE_APPLICATION_ID AND ALR1.BASE_ATTRIBUTE_CODE = ARI3.ATTRIBUTE_CODE

View Text - HTML Formatted

SELECT ALR1.ROWID ROW_ID
, ALR1.REGION_APPLICATION_ID
, ARV1.APPLICATION_NAME REGION_APPLICATION_NAME
, ALR1.REGION_CODE
, ARV1.NAME REGION_NAME
, ALR1.ATTRIBUTE_APPLICATION_ID
, ALR1.ATTRIBUTE_CODE
, ARI1.ATTRIBUTE_NAME ATTRIBUTE_NAME
, ARI1.ITEM_NAME
, ALR1.LOV_REGION_APPL_ID
, ARV2.APPLICATION_NAME LOV_REGION_APPL_NAME
, ALR1.LOV_REGION_CODE
, ARV2.NAME LOV_REGION_NAME
, ALR1.LOV_ATTRIBUTE_APPL_ID
, ALR1.LOV_ATTRIBUTE_CODE
, ARI2.ATTRIBUTE_NAME LOV_ATTRIBUTE_NAME
, ARI2.ITEM_NAME LOV_ITEM_NAME
, ALR1.BASE_REGION_APPL_ID
, ALR1.BASE_REGION_CODE
, ARV3.NAME BASE_REGION_NAME
, ALR1.BASE_ATTRIBUTE_APPL_ID
, ALR1.BASE_ATTRIBUTE_CODE
, ARI3.ATTRIBUTE_NAME BASE_ATTRIBUTE_NAME
, ARI3.ITEM_NAME BASE_ITEM_NAME
, ALR1.DIRECTION_FLAG
, ALR1.LAST_UPDATE_DATE
, ALR1.LAST_UPDATED_BY
, ALR1.CREATION_DATE
, ALR1.CREATED_BY
, ALR1.LAST_UPDATE_LOGIN
, ALR1.REQUIRED_FLAG
FROM AK_REGION_LOV_RELATIONS ALR1
, AK_REGIONS_VL ARV1
, AK_REGION_ITEMS_VL ARI1
, AK_REGIONS_VL ARV2
, AK_REGION_ITEMS_VL ARI2
, AK_REGION_ITEMS_VL ARI3
, AK_REGIONS_VL ARV3
WHERE ALR1.REGION_APPLICATION_ID = ARV1.REGION_APPLICATION_ID
AND ALR1.REGION_CODE = ARV1.REGION_CODE
AND ALR1.REGION_APPLICATION_ID = ARI1.REGION_APPLICATION_ID
AND ALR1.REGION_CODE = ARI1.REGION_CODE
AND ALR1.ATTRIBUTE_APPLICATION_ID = ARI1.ATTRIBUTE_APPLICATION_ID
AND ALR1.ATTRIBUTE_CODE = ARI1.ATTRIBUTE_CODE
AND ALR1.LOV_REGION_APPL_ID = ARV2.REGION_APPLICATION_ID
AND ALR1.LOV_REGION_CODE = ARV2.REGION_CODE
AND ALR1.BASE_REGION_APPL_ID = ARV3.REGION_APPLICATION_ID
AND ALR1.BASE_REGION_CODE = ARV3.REGION_CODE
AND ALR1.BASE_REGION_APPL_ID = ARI3.REGION_APPLICATION_ID
AND ALR1.BASE_REGION_CODE = ARI3.REGION_CODE
AND ALR1.BASE_ATTRIBUTE_APPL_ID = ARI3.ATTRIBUTE_APPLICATION_ID
AND ALR1.BASE_ATTRIBUTE_CODE = ARI3.ATTRIBUTE_CODE
AND ARV2.REGION_APPLICATION_ID = ARI2.REGION_APPLICATION_ID
AND ARV2.REGION_CODE = ARI2.REGION_CODE
AND ALR1.LOV_ATTRIBUTE_APPL_ID = ARI2.ATTRIBUTE_APPLICATION_ID
AND ALR1.LOV_ATTRIBUTE_CODE = ARI2.ATTRIBUTE_CODE
AND ALR1.BASE_REGION_APPL_ID = ARV3.REGION_APPLICATION_ID
AND ALR1.BASE_REGION_CODE = ARV3.REGION_CODE
AND ALR1.BASE_REGION_APPL_ID = ARI3.REGION_APPLICATION_ID
AND ALR1.BASE_REGION_CODE = ARI3.REGION_CODE
AND ALR1.BASE_ATTRIBUTE_APPL_ID = ARI3.ATTRIBUTE_APPLICATION_ID
AND ALR1.BASE_ATTRIBUTE_CODE = ARI3.ATTRIBUTE_CODE