APPS.RRS_ATTR_PANE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

	SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
	  INTO l_date_format_mask
	  FROM DUAL;

Line: 28

		SELECT RRS_PRIMARY_ATTRIBUTE_REC(
			SITE_ID,
			SITE_IDENTIFICATION_NUMBER,
			NAME,
			(SELECT MEANING
			   FROM RRS_SITE_USES RSU, AR_LOOKUPS LK
			  WHERE RSU.SITE_ID = p_object_id
			    AND RSU.IS_PRIMARY_FLAG = 'Y'
			    AND LK.LOOKUP_TYPE (+) = 'PARTY_SITE_USE_CODE'
			    AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE (+)
			),
			DESCRIPTION,
			(SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
			(SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
			TO_CHAR(START_DATE, l_date_format_mask), --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
			TO_CHAR(END_DATE, l_date_format_mask),   --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
			(HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ', ' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)
			),
			NULL,
			NULL,
			NULL)
		   INTO x_primary_attributes
		   FROM RRS_SITES_VL RSV
		  WHERE SITE_ID = p_object_id;

Line: 63

		SELECT RRS_PRIMARY_ATTRIBUTE_REC(
			LOCATION_ID,
			NULL,
			NULL,
			COUNTRY,
			DESCRIPTION,
			NULL,
			NULL,
			NULL,
			NULL,
			(HZ_FORMAT_PUB.format_address(RLV.location_id, null, null, ',' , null) || ', ' || COUNTRY
			),
			COUNTRY,
			NULL,
			NULL)
		   INTO x_primary_attributes
		   FROM RRS_LOCATIONS_V RLV
		  WHERE LOCATION_ID = p_object_id;

Line: 91

		 SELECT RRS_PRIMARY_ATTRIBUTE_REC(
			SITE_GROUP_NODE_ID,
			NODE_IDENTIFICATION_NUMBER,
			NAME,
			(SELECT MEANING
			   FROM RRS_LOOKUPS_V LK
			  WHERE LK.LOOKUP_TYPE (+) = 'RRS_NODE_PURPOSE'
			    AND RSGNV.NODE_PURPOSE_CODE = LK.LOOKUP_CODE (+)
			),
			DESCRIPTION,
			NULL,
			NULL,
			NULL,
			NULL,
			NULL,
			NULL,
			NULL,
			NULL)
		   INTO x_primary_attributes
		   FROM RRS_SITE_GROUP_NODES_VL RSGNV
		  WHERE SITE_GROUP_NODE_ID = p_object_id;

Line: 121

		SELECT RRS_PRIMARY_ATTRIBUTE_REC(
			GROUP_ID,
			SITE_IDENTIFICATION_NUMBER,
			NAME,
			(SELECT MEANING
			   FROM RRS_SITE_USES RSU, AR_LOOKUPS LK
			  WHERE RSU.SITE_ID = p_object_id
			    AND RSU.IS_PRIMARY_FLAG = 'Y'
			    AND LK.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
			    AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE
			),
			DESCRIPTION,
			(SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' AND LOOKUP_CODE = RSV.SITE_TYPE_CODE),
			(SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' AND LOOKUP_CODE = RSV.SITE_STATUS_CODE),
			START_DATE,
			END_DATE,
			(HZ_FORMAT_PUB.format_address(RSV.location_id, null, null, ',' , null) || ', ' || (SELECT COUNTRY FROM RRS_LOCATIONS_V WHERE LOCATION_ID = RSV.LOCATION_ID)
			),
			(SELECT MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_TRADE_AREA_GROUP_TYPE' AND LOOKUP_CODE = RTAGV.GROUP_TYPE_CODE),
			NULL,
			NULL)
		   INTO x_primary_attributes
		   FROM RRS_TRADE_AREA_GROUPS_VL RTAGV
		  WHERE GROUP_ID = p_object_id;

Line: 149

		 SELECT RRS_PRIMARY_ATTRIBUTE_REC(
			SITE_GROUP_ID,
			NULL,
			NAME,
			(SELECT MEANING
			   FROM RRS_LOOKUPS_V LK
			  WHERE LK.LOOKUP_TYPE(+) = 'RRS_HIERARCHY_PURPOSE'
			    AND RSGV.GROUP_PURPOSE_CODE = LK.LOOKUP_CODE (+)
			),
			DESCRIPTION,
			NULL,
			NULL,
			TO_CHAR(START_DATE, l_date_format_mask),  --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
			TO_CHAR(END_DATE, l_date_format_mask),    --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
			NULL,
			NULL,
			SITE_GROUP_TYPE_CODE,
			NULL)
		   INTO x_primary_attributes
		   FROM RRS_SITE_GROUPS_VL RSGV
		  WHERE SITE_GROUP_ID = (SELECT SITE_GROUP_ID FROM RRS_SITE_GROUP_VERSIONS WHERE SITE_GROUP_VERSION_ID = p_object_id);

Line: 266

		SELECT ATTRIBUTE_PAGE_ID
		  BULK COLLECT
		  INTO l_page_id_array
		  FROM RRS_ATTR_PAGE_SETTINGS
		 WHERE WHERE_USED = p_where_used
		   AND OBJECT_TYPE = p_object_type
		   AND CATEGORIZATION_OBJECT1 = p_object1
		   AND CLASSIFICATION_CODE1 = p_classification_code1
		   AND CATEGORIZATION_OBJECT2 = p_object2
	   	   AND CLASSIFICATION_CODE2 = p_classification_code2;

Line: 278

		SELECT ATTRIBUTE_PAGE_ID
		  BULK COLLECT
		  INTO l_page_id_array
		  FROM RRS_ATTR_PAGE_SETTINGS
		 WHERE WHERE_USED = p_where_used
		   AND OBJECT_TYPE = p_object_type
		   AND CATEGORIZATION_OBJECT1 = p_object1
		   AND CLASSIFICATION_CODE1 = p_classification_code1
		   AND CATEGORIZATION_OBJECT2 IS NULL
	   	   AND CLASSIFICATION_CODE2 IS NULL;

Line: 290

		SELECT ATTRIBUTE_PAGE_ID
		  BULK COLLECT
		  INTO l_page_id_array
		  FROM RRS_ATTR_PAGE_SETTINGS
		 WHERE WHERE_USED = p_where_used
		   AND OBJECT_TYPE = p_object_type
		   AND CATEGORIZATION_OBJECT1 = p_object1
		   AND CLASSIFICATION_CODE1 = p_classification_code1
		   AND CATEGORIZATION_OBJECT2 = p_object2
	   	   AND CLASSIFICATION_CODE2 IS NULL;

Line: 337

		SELECT RRS_ATTR_GROUP_PAGE_REC(
		       PAGE_ID,
		       OBJECT_NAME,
		       CLASSIFICATION_CODE,
		       DATA_LEVEL_INT_NAME, INTERNAL_NAME, DISPLAY_NAME,
		       DESCRIPTION, SEQUENCE)
		  INTO l_attr_group_page_rec
		  FROM EGO_PAGES_V
		 WHERE PAGE_ID = l_page_id_array(i);

Line: 370

        SELECT RRS_ATTR_GROUP_PAGE_REC(
		PAGE_ID, OBJECT_NAME, CLASSIFICATION_CODE,
		DATA_LEVEL_INT_NAME, INTERNAL_NAME, DISPLAY_NAME,
		DESCRIPTION, SEQUENCE)
          BULK COLLECT
          INTO x_ag_page_tab
          FROM TABLE(l_attr_group_page_tab)
          ORDER BY SEQUENCE;

Line: 386

		SELECT ATTR_GROUP_TYPE, ATTR_GROUP_NAME, SEQUENCE
		  BULK COLLECT
		  INTO l_page_entries
		  FROM EGO_PAGE_ENTRIES_V
		 WHERE PAGE_ID = l_page_id_array(i)
		   AND CLASSIFICATION_CODE = l_classification_code
	      ORDER BY SEQUENCE;

Line: 409

			SELECT RRS_ATTRIBUTE_GROUP_REC(
			       l_page_id_array(i),
			       ATTR_GROUP_ID,
			       ATTR_GROUP_TYPE,
			       ATTR_GROUP_NAME,
			       ATTR_GROUP_DISP_NAME,
			       DESCRIPTION,
			       MULTI_ROW_CODE,
			       SECURITY_CODE,
			       NUM_OF_COLS,
			       NUM_OF_ROWS,
			       l_page_entries(j).sequence)
			  INTO l_attribute_group_rec
			  FROM EGO_ATTR_GROUPS_V
			 WHERE APPLICATION_ID = 718
			   AND ATTR_GROUP_TYPE = l_page_entries(j).attr_group_type
			   AND ATTR_GROUP_NAME = l_page_entries(j).attr_group_name;

Line: 466

			l_query := 'SELECT EXTENSION_ID' ||
			           '  FROM ' || l_ext_table_name ||
			 	   ' WHERE ' || l_pk_name || ' = :1'||
			 	   '   AND ' || l_classification_name || ' = :2'||
			 	   '   AND ATTR_GROUP_ID = :3';

Line: 477

			SELECT ATTR_NAME, ATTR_DISPLAY_NAME, DISPLAY_CODE, DESCRIPTION, SEQUENCE
			  BULK COLLECT
			  INTO l_attribute_tab
			  FROM EGO_ATTRS_V
			 WHERE APPLICATION_ID = 718
			   AND ATTR_GROUP_TYPE = x_attr_group_tab(j).ATTR_GROUP_TYPE
			   AND ATTR_GROUP_NAME = x_attr_group_tab(j).ATTR_GROUP_NAME
			   AND ENABLED_FLAG = 'Y'	--Bug Fix 9709262: The disabled attribute will not show up.
			 ORDER BY SEQUENCE;

Line: 675

		SELECT DATABASE_COLUMN, DATA_TYPE_CODE, INFO_1, UOM_CLASS, VALUE_SET_ID, VALIDATION_CODE, DISPLAY_CODE, DISPLAY_MEANING
		  INTO l_attr_info
		  FROM EGO_ATTRS_V
		 WHERE APPLICATION_ID = 718
		   AND ATTR_GROUP_TYPE = p_attr_group_type
		   AND ATTR_GROUP_NAME = p_attr_group_name
		   AND ATTR_NAME = p_attr_name;

Line: 699

	SELECT ATTR_GROUP_ID
	  INTO l_attr_group_id
	  FROM EGO_ATTR_GROUPS_V
	 WHERE APPLICATION_ID = 718
	   AND ATTR_GROUP_TYPE = p_attr_group_type
	   AND ATTR_GROUP_NAME = p_attr_group_name;

Line: 718

		l_query := 'SELECT ' || l_attr_info.database_column ||
		    	    ' FROM ' || l_ext_table_name ||
		   	   ' WHERE ' || l_pk_name || ' = :1' ||
		   	     ' AND ATTR_GROUP_ID = :2' ||
		   	     ' AND EXTENSION_ID = :3';

Line: 726

		l_query := 'SELECT ' || l_attr_info.database_column || ', ' || REPLACE(l_attr_info.database_column, 'N', 'UOM') ||
		    	    ' FROM ' || l_ext_table_name ||
		   	   ' WHERE ' || l_pk_name || ' = :1' ||
		   	     ' AND ATTR_GROUP_ID = :2' ||
		   	     ' AND EXTENSION_ID = :3';

Line: 736

		l_query := 'SELECT ' || l_attr_info.database_column ||
		    	    ' FROM ' || l_ext_table_name ||
		   	   ' WHERE ' || l_pk_name || ' = :1' ||
		   	     ' AND ATTR_GROUP_ID = :2' ||
		   	     ' AND EXTENSION_ID = :3';

Line: 758

		SELECT UNIT_OF_MEASURE_TL
		  INTO l_uom
		  FROM MTL_UNITS_OF_MEASURE_VL
		 WHERE UOM_CODE = l_uom_code;

Line: 764

		SELECT CONVERSION_RATE
		  INTO l_uom_conversion_rate
		  FROM MTL_UOM_CONVERSIONS
		  WHERE UOM_CODE = l_uom_code;

Line: 772

		SELECT ((l_code_value / l_uom_conversion_rate) || ' ' || l_uom)
		  INTO x_display_value
		  FROM DUAL;

Line: 847

			SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
			INTO l_date_format_mask
			FROM DUAL;

Line: 868

				SELECT FLEX_VALUE_MEANING
				  INTO x_display_value
				  FROM FND_FLEX_VALUES_VL
				 WHERE FLEX_VALUE_SET_ID = l_attr_info.value_set_id
				   AND FLEX_VALUE = l_date_value;

Line: 874

				SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
				INTO l_date_format_mask
				FROM DUAL;

Line: 890

				SELECT FLEX_VALUE_MEANING
				  INTO x_display_value
				  FROM FND_FLEX_VALUES_VL
				 WHERE FLEX_VALUE_SET_ID = l_attr_info.value_set_id
				   AND FLEX_VALUE = l_code_value;

Line: 904

		SELECT APPLICATION_TABLE_NAME, VALUE_COLUMN_NAME,
		       VALUE_COLUMN_TYPE, ID_COLUMN_NAME, ADDITIONAL_WHERE_CLAUSE
		  INTO l_app_table_name, l_value_column_name,
		       l_value_column_type, l_id_column_name, l_add_where_clause
		  FROM FND_FLEX_VALIDATION_TABLES
		 WHERE FLEX_VALUE_SET_ID = l_attr_info.value_set_id;

Line: 940

                               		SELECT DATABASE_COLUMN, DATA_TYPE_CODE
                                	  INTO l_dep_column, l_dep_data_type
                                  	  FROM EGO_ATTRS_V
                                 	 WHERE APPLICATION_ID = 718
                                   	   AND ATTR_GROUP_TYPE = p_attr_group_type
                                   	   AND ATTR_GROUP_NAME = p_attr_group_name
                                   	   AND ATTR_NAME = l_dep_attr_name;

Line: 954

	   			l_query := 'SELECT ' || l_dep_column ||
	   				   '  FROM ' || l_ext_table_name ||
					   ' WHERE ' || l_pk_name || ' = :1' ||
					     ' AND ATTR_GROUP_ID = :2' ||
					     ' AND EXTENSION_ID = :3';

Line: 994

				l_query := 'SELECT ' || l_value_column_name ||
				    '  FROM ' || l_app_table_name ||
				    ' WHERE ' || l_id_column_name || ' = :1' ||
				    '   AND ' || l_add_where_clause;

Line: 999

				l_query := 'SELECT ' || l_value_column_name ||
				    '  FROM ' || l_app_table_name ||
				    ' WHERE ' || l_add_where_clause;

Line: 1009

			 l_query := 'SELECT ' || l_value_column_name ||
				    '  FROM ' || l_app_table_name ||
				    ' WHERE ' || l_id_column_name || ' = :1';

Line: 1026

		 	SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
				INTO l_date_format_mask
				FROM DUAL;

Line: 1069

		      SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
			INTO l_date_format_mask
			FROM DUAL;

Line: 1100

	SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
	INTO l_date_format_mask
	FROM DUAL;

Line: 1181

	SELECT ATTR_GROUP_TYPE, ATTR_GROUP_NAME
	  INTO l_attr_group_type, l_attr_group_name
	  FROM EGO_ATTR_GROUPS_V
	 WHERE ATTR_GROUP_ID = p_attr_group_id;

Line: 1187

	SELECT ATTR_NAME
	  INTO l_attr_name
	  FROM EGO_ATTRS_V
	 WHERE APPLICATION_ID = 718
	   AND ATTR_GROUP_TYPE = l_attr_group_type
	   AND ATTR_GROUP_NAME = l_attr_group_name
	   AND DATABASE_COLUMN = p_column_name;

Line: 1257

	SELECT ATTR_GROUP_TYPE, ATTR_GROUP_NAME
	  INTO l_attr_group_type, l_attr_group_name
	  FROM EGO_ATTR_GROUPS_V
	 WHERE ATTR_GROUP_ID = p_attr_group_id;

Line: 1263

	SELECT ATTR_NAME
	  INTO l_attr_name
	  FROM EGO_ATTRS_V
	 WHERE APPLICATION_ID = 718
	   AND ATTR_GROUP_TYPE = l_attr_group_type
	   AND ATTR_GROUP_NAME = l_attr_group_name
	   AND DATABASE_COLUMN = p_column_name;

Line: 1316

    SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
      INTO l_timestamp
	  FROM DUAL;

Line: 1320

	--SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
	--  INTO l_timestamp
	--  FROM DUAL;