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 351: FROM wms_label_field_variables lbvar,

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

Line 2291: FROM wms_label_field_variables lbvar

2287: BEGIN
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';

Line 3562: FROM wms_label_field_variables wlfv

3558: SELECT min(a.count)
3559: INTO no_of_rows_per_label
3560: FROM (SELECT wlfv.label_field_id,
3561: count(*) count
3562: FROM wms_label_field_variables wlfv
3563: WHERE wlfv.label_format_id = l_label_format_id
3564: GROUP BY wlfv.label_field_id
3565: HAVING count(*) > 1) a;
3566:

Line 3580: FROM wms_label_field_variables wlfv

3576: SELECT max(a.count)
3577: INTO max_no_of_rows_defined
3578: FROM (SELECT wlfv.label_field_id,
3579: count(*) count
3580: FROM wms_label_field_variables wlfv
3581: WHERE wlfv.label_format_id = l_label_format_id
3582: GROUP BY wlfv.label_field_id
3583: HAVING count(*) > 1) a;
3584:

Line 3610: FROM wms_label_field_variables wlfv

3606: BEGIN
3607: SELECT count(1) INTO l_multi_format
3608: FROM DUAL
3609: WHERE EXISTS (SELECT wlfv.label_field_id, count(*) count
3610: FROM wms_label_field_variables wlfv
3611: WHERE wlfv.label_format_id = l_label_format_id
3612: GROUP BY wlfv.label_field_id
3613: HAVING count(*) > 1) ;
3614: