442: CURSOR csr_asg_loc_addr(p_location_id number) is
443: SELECT LOCATION_ID,
444: STYLE,
445: ( SELECT descriptive_flex_context_name
446: from fnd_descr_flex_contexts_vl
447: where descriptive_flexfield_name ='Address Structure'
448: AND descriptive_flex_context_code = STYLE) STYLE_DESC,
449: COUNTRY,
450: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC,
552: , to_char(DATE_FROM,'YYYY-MM-DD')
553: , PRIMARY_FLAG
554: , STYLE
555: , ( SELECT descriptive_flex_context_name
556: from fnd_descr_flex_contexts_vl
557: where descriptive_flexfield_name ='Address Structure'
558: AND descriptive_flex_context_code = STYLE) STYLE_DESC
559: , ADDRESS_LINE1
560: , ADDRESS_LINE2
624: , to_char(DATE_FROM,'YYYY-MM-DD')
625: , PRIMARY_FLAG
626: , STYLE
627: , ( SELECT descriptive_flex_context_name
628: from fnd_descr_flex_contexts_vl
629: where descriptive_flexfield_name ='Address Structure'
630: AND descriptive_flex_context_code = STYLE) STYLE_DESC
631: , ADDRESS_LINE1
632: , ADDRESS_LINE2