Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BIS_TERRITORY_HIERARCHIES_V |
SELECT BTH.ROWID ROW_ID
, BTH.PARENT_TERRITORY_CODE PARENT_TERRITORY_CODE
, BTH.PARENT_TERRITORY_TYPE PARENT_TERRITORY_TYPE
, BTV1.NAME PARENT_TERRITORY_NAME
, BTH.CHILD_TERRITORY_CODE CHILD_TERRITORY_CODE
, BTH.CHILD_TERRITORY_TYPE CHILD_TERRITORY_TYPE
, BTV2.NAME CHILD_TERRITORY_NAME
, BTH.START_DATE_ACTIVE START_DATE
, BTH.END_DATE_ACTIVE END_DATE
, BTH.CREATED_BY
, BTH. CREATION_DATE
, BTH.LAST_UPDATED_BY
, BTH.LAST_UPDATE_DATE
, BTH.LAST_UPDATE_LOGIN
FROM BIS.BIS_TERRITORY_HIERARCHIES BTH
, BIS_TERRITORIES_V BTV1
, BIS_TERRITORIES_V BTV2
WHERE BTH.PARENT_TERRITORY_CODE = BTV1.TERRITORY_CODE
AND BTH.PARENT_TERRITORY_TYPE = BTV1.TYPE
AND BTH.CHILD_TERRITORY_CODE = BTV2.TERRITORY_CODE
AND BTH.CHILD_TERRITORY_TYPE = BTV2.TYPE