APPS.INV_LABEL_PVT5 dependencies on WMS_LABEL_FIELDS_VL

Line 117: wms_label_fields_vl wlf

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

Line 2428: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

2424: BEGIN
2425: select min(table_a.c) into no_of_rows_per_label
2426: from (select wlfv.label_field_id,
2427: wlf.column_name, count(*) c
2428: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
2429: where wlfv.label_field_id = wlf.label_field_id
2430: and wlfv.label_format_id = p_label_type_info.default_format_id
2431: group by wlfv.label_field_id, wlf.column_name
2432: having count(*)>1 ) table_a;

Line 2853: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

2849: BEGIN
2850: select min(table_a.c) into no_of_rows_per_label
2851: from (select wlfv.label_field_id,
2852: wlf.column_name, count(*) c
2853: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
2854: where wlfv.label_field_id = wlf.label_field_id
2855: and wlfv.label_format_id = l_label_format_id
2856: group by wlfv.label_field_id, wlf.column_name
2857: having count(*)>1 ) table_a;

Line 4376: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

4372: BEGIN
4373: select max(table_a.c) into max_no_of_rows_defined
4374: from (select wlfv.label_field_id,
4375: wlf.column_name, count(*) c
4376: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
4377: where wlfv.label_field_id = wlf.label_field_id
4378: and wlfv.label_format_id = l_label_format_id
4379: group by wlfv.label_field_id, wlf.column_name) table_a;
4380: EXCEPTION

Line 4456: from wms_label_field_variables wlfv, wms_label_fields_vl wlf

4452: BEGIN
4453: select max(table_a.c) into max_no_of_rows_defined
4454: from (select wlfv.label_field_id,
4455: wlf.column_name, count(*) c
4456: from wms_label_field_variables wlfv, wms_label_fields_vl wlf
4457: where wlfv.label_field_id = wlf.label_field_id
4458: and wlfv.label_format_id = l_label_format_id
4459: group by wlfv.label_field_id, wlf.column_name) table_a;
4460: EXCEPTION