eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT8 dependencies on WMS_LABEL_FIELDS_VL

Line 195: wms_label_fields_vl wlf

191: SELECT wlf.column_name,
192: wlf.sql_stmt,
193: wlfv.field_variable_name
194: FROM wms_label_field_variables wlfv,
195: wms_label_fields_vl wlf
196: WHERE wlfv.label_format_id = p_label_format_id
197: AND wlfv.label_field_id = wlf.label_field_id
198: ORDER BY wlf.column_name, wlfv.field_variable_name;
199:

Line 352: wms_label_fields_vl lbfl

348:
349: CURSOR c_fields_for_format(v_label_format_id NUMBER) IS
350: SELECT lbfl.column_name
351: FROM wms_label_field_variables lbvar,
352: wms_label_fields_vl lbfl
353: WHERE lbfl.label_field_id = lbvar.label_field_id
354: AND lbvar.label_format_id = v_label_format_id
355: GROUP BY lbfl.column_name;
356:

Line 2292: , wms_label_fields_vl lbfl

2288:
2289: SELECT Count(*)
2290: INTO l_serial_check
2291: FROM wms_label_field_variables lbvar
2292: , wms_label_fields_vl lbfl
2293: WHERE lbfl.label_field_id = lbvar.label_field_id
2294: AND lbvar.label_format_id = p_label_type_info.default_format_id
2295: AND column_name = 'serial_number';
2296: