APPS.WMS_CONFIG_UI dependencies on WMS_PAGE_FIELDS_VL

Line 156: FROM WMS_PAGE_FIELDS_VL WPF, WMS_PAGE_TEMPLATE_FIELDS WTF

152: DEBUG (' Fetching the page level properties', l_module_name, 9);
153: IF l_template_id <> -1 THEN
154: OPEN x_page_level_props FOR
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
156: FROM WMS_PAGE_FIELDS_VL WPF, WMS_PAGE_TEMPLATE_FIELDS WTF
157: WHERE WPF.PAGE_ID = WTF.PAGE_ID
158: AND WPF.FIELD_ID = WTF.FIELD_ID
159: AND WPF.PAGE_ID = p_page_id
160: AND WTF.TEMPLATE_ID = l_template_id

Line 165: FROM WMS_PAGE_FIELDS_VL

161: AND WPF.FIELD_CATEGORY = 'PAGE';
162: ELSE
163: OPEN x_page_level_props FOR
164: SELECT FIELD_NAME, FIELD_CATEGORY, -1, -1, FIELD_PROPERTY1_DEFAULT_VALUE, FIELD_PROPERTY2_DEFAULT_VALUE
165: FROM WMS_PAGE_FIELDS_VL
166: WHERE PAGE_ID = p_page_id
167: AND FIELD_CATEGORY = 'PAGE';
168: END IF;
169: END IF;

Line 348: FROM WMS_PAGE_FIELDS_VL WPF , WMS_PAGE_TEMPLATE_FIELDS WTF

344: , null
345: , null
346: , WTF.FIELD_PROPERTY1_VALUE
347: , WTF.FIELD_PROPERTY2_VALUE
348: FROM WMS_PAGE_FIELDS_VL WPF , WMS_PAGE_TEMPLATE_FIELDS WTF
349: WHERE WPF.PAGE_ID = WTF.PAGE_ID
350: AND WPF.FIELD_ID = WTF.FIELD_ID
351: AND WPF.PAGE_ID = p_page_id
352: AND WTF.TEMPLATE_ID = l_template_id