461: CURSOR csr_asg_loc_addr(p_location_id number) is
462: SELECT LOCATION_ID,
463: STYLE,
464: ( SELECT descriptive_flex_context_name
465: from fnd_descr_flex_contexts_vl
466: where descriptive_flexfield_name ='Address Structure'
467: AND descriptive_flex_context_code = STYLE) STYLE_DESC,
468: COUNTRY,
469: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC,
571: , to_char(DATE_FROM,'YYYY-MM-DD')
572: , PRIMARY_FLAG
573: , STYLE
574: , ( SELECT descriptive_flex_context_name
575: from fnd_descr_flex_contexts_vl
576: where descriptive_flexfield_name ='Address Structure'
577: AND descriptive_flex_context_code = STYLE) STYLE_DESC
578: , ADDRESS_LINE1
579: , ADDRESS_LINE2
643: , to_char(DATE_FROM,'YYYY-MM-DD')
644: , PRIMARY_FLAG
645: , STYLE
646: , ( SELECT descriptive_flex_context_name
647: from fnd_descr_flex_contexts_vl
648: where descriptive_flexfield_name ='Address Structure'
649: AND descriptive_flex_context_code = STYLE) STYLE_DESC
650: , ADDRESS_LINE1
651: , ADDRESS_LINE2