Retrieving Territory RSM, DSM etc through path ID

1. Obtain the territory guid TERR_GUID from the table CRMM_TERRITORY using the obtained territory id TERR_ID.
2. Obtain the corresponding guid from the table CRMM_TERRITORY_V by entering the above guid in the field TERR_GUID
3. Use this new guid in the table CRMM_TERRSTRUCT ( field TERRITORY_V_GUID) to obtain the path id PATH_ID.
4. Use the path id in the FM CRM_TERRMAN_TSTRUC_PATH_SELECT to return the list of sub-level entries.
5. The above FM returns back all the sub-level paths.
6. Use the path-ids in the table CRMM_TERRSTRUCT to obtain the territory V Guids.
7. Use the territory v guids in the table CRMM_TERRITORY_V to obtain the territory guids
8. Use the territory guids in the table CRMM_TERRITORY to obtain the territory ids and provide them as drop down list.