Product: | AK - Common Modules-AK |
---|---|
Description: | Defines relationships between LOV regions and regions |
Implementation/DBA Data: | APPS.AK_REGION_LOV_RELATIONS_V |
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