DBA Data[Home] [Help]

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 348: wms_label_fields_vl lbfl

344:
345: CURSOR c_fields_for_format(v_label_format_id NUMBER) IS
346: SELECT lbfl.column_name
347: FROM wms_label_field_variables lbvar,
348: wms_label_fields_vl lbfl
349: WHERE lbfl.label_field_id = lbvar.label_field_id
350: AND lbvar.label_format_id = v_label_format_id
351: GROUP BY lbfl.column_name;
352: