APPS.WMS_CONFIG_UI SQL Statements

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

Line: 93

		SELECT  PAGE_ID
		      , FIELD_ID
		      , FIELD_DISP_SEQUENCE_NUMBER
		      , FIELD_NAME
		      , FIELD_TYPE
		      , FIELD_CONSTRUCTOR_PARAM
		      , FIELD_PROMPT
		      , FIELD_IS_CONFIGURABLE
		      , FIELD_CATEGORY
		      , FIELD_PROPERTY1_DEFAULT_VALUE
		      , FIELD_PROPERTY2_DEFAULT_VALUE
		      , FIELD_IS_VISIBLE
		      , TEMPLATE_ID
		      , TEMPLATE_NAME
		      , USER_TEMPLATE_NAME
		      , TEMPLATE_DESCRIPTION
		      , CREATING_ORGANIZATION_ID
		      , CREATING_ORGANIZATION_CODE
		      , COMMON_TO_ALL_ORGS
		      , ENABLED
        	, FIELD_PROPERTY1_VALUE
		      , FIELD_PROPERTY2_VALUE
		FROM WMS_PAGE_CONFIG_UI_V
		WHERE PAGE_ID  =  p_page_id
		  AND TEMPLATE_ID =  -1
		  AND FIELD_IS_CONFIGURABLE <> 'Y'
		  AND FIELD_CATEGORY <> 'PAGE'
      UNION ALL
		SELECT  PAGE_ID
		      , FIELD_ID
		      , FIELD_DISP_SEQUENCE_NUMBER
		      , FIELD_NAME
		      , FIELD_TYPE
		      , FIELD_CONSTRUCTOR_PARAM
		      , FIELD_PROMPT
		      , FIELD_IS_CONFIGURABLE
		      , FIELD_CATEGORY
		      , FIELD_PROPERTY1_DEFAULT_VALUE
		      , FIELD_PROPERTY2_DEFAULT_VALUE
		      , FIELD_IS_VISIBLE
		      , TEMPLATE_ID
		      , TEMPLATE_NAME
		      , USER_TEMPLATE_NAME
		      , TEMPLATE_DESCRIPTION
		      , CREATING_ORGANIZATION_ID
		      , CREATING_ORGANIZATION_CODE
		      , COMMON_TO_ALL_ORGS
		      , ENABLED
         	, FIELD_PROPERTY1_VALUE
		      , FIELD_PROPERTY2_VALUE
		FROM WMS_PAGE_CONFIG_UI_V
		WHERE PAGE_ID  =  p_page_id
		  AND TEMPLATE_ID =  l_temp_template_id
		  AND FIELD_IS_CONFIGURABLE = 'Y'
		  AND FIELD_CATEGORY <> 'PAGE'
    ORDER BY FIELD_DISP_SEQUENCE_NUMBER;

Line: 155

          SELECT WPF.FIELD_NAME, WPF.FIELD_CATEGORY, WTF.FIELD_PROPERTY1_VALUE, WTF.FIELD_PROPERTY2_VALUE, WPF.FIELD_PROPERTY1_DEFAULT_VALUE, WPF.FIELD_PROPERTY2_DEFAULT_VALUE
          FROM WMS_PAGE_FIELDS_VL WPF, WMS_PAGE_TEMPLATE_FIELDS WTF
          WHERE WPF.PAGE_ID = WTF.PAGE_ID
            AND WPF.FIELD_ID = WTF.FIELD_ID
            AND WPF.PAGE_ID = p_page_id
            AND WTF.TEMPLATE_ID = l_template_id
            AND WPF.FIELD_CATEGORY = 'PAGE';

Line: 164

          SELECT FIELD_NAME, FIELD_CATEGORY, -1, -1, FIELD_PROPERTY1_DEFAULT_VALUE, FIELD_PROPERTY2_DEFAULT_VALUE
          FROM WMS_PAGE_FIELDS_VL
          WHERE PAGE_ID = p_page_id
            AND FIELD_CATEGORY = 'PAGE';

Line: 218

     select template_id, template_name
     into x_template_id, x_return_template
     from WMS_PAGE_TEMPLATES_VL
     where page_id in (p_page_id, nvl(l_parent_page_id, p_page_id ))
	   and template_name = p_template_name
 	   and enabled = 'Y'
	   and decode(common_to_all_orgs,
                'Y', -99,
                'N', creating_organization_id,
                creating_organization_id) = decode (common_to_all_orgs, 'Y', -99,
                                                    'N', p_organization_id,
                                                    p_organization_id);

Line: 247

    select template_id, template_name
    into x_template_id, x_return_template
    from WMS_PAGE_TEMPLATES_VL
    where page_id in (p_page_id, nvl(l_parent_page_id, p_page_id ))
	  and enabled = 'Y'
	  and default_flag = 'Y';

Line: 326

     SELECT WPF.PAGE_ID
		      , WPF.FIELD_ID
		      , WPF.FIELD_DISP_SEQUENCE_NUMBER
		      , WPF.FIELD_NAME
		      , WPF.FIELD_TYPE
		      , WPF.FIELD_CONSTRUCTOR_PARAM
		      , WPF.FIELD_PROMPT
		      , WPF.FIELD_IS_CONFIGURABLE
		      , WPF.FIELD_CATEGORY
		      , WPF.FIELD_PROPERTY1_DEFAULT_VALUE
		      , WPF.FIELD_PROPERTY2_DEFAULT_VALUE
		      , WPF.FIELD_IS_VISIBLE
		      , WTF.TEMPLATE_ID
		      , null
		      , null
		      , null
		      , -1
		      , null
		      , null
		      , null
         	, WTF.FIELD_PROPERTY1_VALUE
		      , WTF.FIELD_PROPERTY2_VALUE
      FROM WMS_PAGE_FIELDS_VL WPF , WMS_PAGE_TEMPLATE_FIELDS WTF
      WHERE WPF.PAGE_ID = WTF.PAGE_ID
        AND WPF.FIELD_ID = WTF.FIELD_ID
        AND WPF.PAGE_ID = p_page_id
        AND WTF.TEMPLATE_ID = l_template_id
        AND WPF.FIELD_NAME = p_field_name;