VIEW: APPS.HRI_DBI_CL_GEO_RGN_HRCHY_V

Source

View Text - Preformatted

SELECT lkp.lookup_code ID ,lkp.meaning VALUE ,NVL(lkp.start_date_active, hr_general.start_of_time) START_DATE ,NVL(lkp.end_date_active, hr_general.end_of_time) END_DATE ,lkp.meaning ORDER_BY ,th.parent_territory_code COUNTRY_CODE ,lkp.enabled_flag VALID_FLAG_CODE FROM bis_territory_hierarchies th , fnd_lookups lkp WHERE lkp.lookup_type ='REGION' AND lkp.lookup_code = th.child_territory_code(+) AND th.child_territory_type (+) = 'REGION' AND th.parent_territory_type (+) = 'COUNTRY' UNION ALL SELECT 'NA_EDW' ID , hri_oltp_view_message.get_unassigned_msg VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , ' ' ORDER_BY , 'NA_EDW' COUNTRY_CODE , 'Y' VALID_FLAG_CODE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT LKP.LOOKUP_CODE ID
, LKP.MEANING VALUE
, NVL(LKP.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME) START_DATE
, NVL(LKP.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME) END_DATE
, LKP.MEANING ORDER_BY
, TH.PARENT_TERRITORY_CODE COUNTRY_CODE
, LKP.ENABLED_FLAG VALID_FLAG_CODE
FROM BIS_TERRITORY_HIERARCHIES TH
, FND_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE ='REGION'
AND LKP.LOOKUP_CODE = TH.CHILD_TERRITORY_CODE(+)
AND TH.CHILD_TERRITORY_TYPE (+) = 'REGION'
AND TH.PARENT_TERRITORY_TYPE (+) = 'COUNTRY' UNION ALL SELECT 'NA_EDW' ID
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, ' ' ORDER_BY
, 'NA_EDW' COUNTRY_CODE
, 'Y' VALID_FLAG_CODE
FROM DUAL WITH READ ONLY