APPS.INV_LABEL_PVT5 dependencies on WMS_LABEL_FIELDS_VL

Line 115: wms_label_fields_vl wlf

111: SELECT wlf.column_name,
112: wlf.sql_stmt,
113: wlfv.field_variable_name
114: FROM wms_label_field_variables wlfv,
115: wms_label_fields_vl wlf
116: WHERE wlfv.label_format_id = p_label_format_id
117: AND wlfv.label_field_id = wlf.label_field_id
118: ORDER BY wlf.column_name, wlfv.field_variable_name;
119:

Line 1878: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

1874: BEGIN
1875: select min(table_a.c) into no_of_rows_per_label
1876: from (select wlfv.label_field_id,
1877: wlf.column_name, count(*) c
1878: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
1879: where wlfv.label_field_id = wlf.label_field_id
1880: and wlfv.label_format_id = p_label_type_info.default_format_id
1881: group by wlfv.label_field_id, wlf.column_name
1882: having count(*)>1 ) table_a;

Line 2290: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

2286: BEGIN
2287: select min(table_a.c) into no_of_rows_per_label
2288: from (select wlfv.label_field_id,
2289: wlf.column_name, count(*) c
2290: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
2291: where wlfv.label_field_id = wlf.label_field_id
2292: and wlfv.label_format_id = l_label_format_id
2293: group by wlfv.label_field_id, wlf.column_name
2294: having count(*)>1 ) table_a;

Line 3739: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

3735: BEGIN
3736: select max(table_a.c) into max_no_of_rows_defined
3737: from (select wlfv.label_field_id,
3738: wlf.column_name, count(*) c
3739: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
3740: where wlfv.label_field_id = wlf.label_field_id
3741: and wlfv.label_format_id = l_label_format_id
3742: group by wlfv.label_field_id, wlf.column_name) table_a;
3743: EXCEPTION

Line 3819: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

3815: BEGIN
3816: select max(table_a.c) into max_no_of_rows_defined
3817: from (select wlfv.label_field_id,
3818: wlf.column_name, count(*) c
3819: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
3820: where wlfv.label_field_id = wlf.label_field_id
3821: and wlfv.label_format_id = l_label_format_id
3822: group by wlfv.label_field_id, wlf.column_name) table_a;
3823: EXCEPTION