APPS.INV_LABEL_PVT8 dependencies on WMS_LABEL_FIELD_VARIABLES

Line 194: FROM wms_label_field_variables wlfv,

190: CURSOR c_label_field_var IS
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;

Line 347: FROM wms_label_field_variables lbvar,

343:
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;

Line 2908: FROM wms_label_field_variables wlfv

2904: SELECT min(a.count)
2905: INTO no_of_rows_per_label
2906: FROM (SELECT wlfv.label_field_id,
2907: count(*) count
2908: FROM wms_label_field_variables wlfv
2909: WHERE wlfv.label_format_id = l_label_format_id
2910: GROUP BY wlfv.label_field_id
2911: HAVING count(*) > 1) a;
2912:

Line 2926: FROM wms_label_field_variables wlfv

2922: SELECT max(a.count)
2923: INTO max_no_of_rows_defined
2924: FROM (SELECT wlfv.label_field_id,
2925: count(*) count
2926: FROM wms_label_field_variables wlfv
2927: WHERE wlfv.label_format_id = l_label_format_id
2928: GROUP BY wlfv.label_field_id
2929: HAVING count(*) > 1) a;
2930: