APPS.INV_LABEL dependencies on WMS_LABEL_FORMATS

Line 245: FROM WMS_LABEL_FORMATS

241: -- If the format is passed in, the default
242: x_types_to_print(1).manual_format_id := p_format_id;
243: BEGIN
244: SELECT label_format_name INTO l_format_name
245: FROM WMS_LABEL_FORMATS
246: WHERE label_format_id = p_format_id;
247: EXCEPTION
248: WHEN others THEN
249: IF (l_debug = 1) THEN

Line 1231: INTO p_label_format_id,p_label_format FROM WMS_LABEL_FORMATS

1227: p_label_format_id OUT NOCOPY NUMBER
1228: ) IS
1229: BEGIN
1230: SELECT label_format_id,label_format_name
1231: INTO p_label_format_id,p_label_format FROM WMS_LABEL_FORMATS
1232: WHERE document_id = p_label_type_id
1233: AND default_format_flag = 'Y';
1234: IF SQL%NOTFOUND THEN
1235: p_label_format_id := null;

Line 2048: from wms_label_formats

2044: x_label_format_id := p_label_format_id;
2045: BEGIN
2046: select label_format_name
2047: into x_label_format
2048: from wms_label_formats
2049: where label_format_id = x_label_format_id;
2050: EXCEPTION
2051: when others then
2052: IF (l_debug = 1) THEN

Line 2146: AND exists (SELECT label_format_id FROM wms_label_formats

2142: */
2143:
2144: DELETE FROM wms_label_requests
2145: WHERE label_request_id = l_label_request_id
2146: AND exists (SELECT label_format_id FROM wms_label_formats
2147: WHERE label_format_id = x_label_format_id
2148: AND document_id = p_document_id
2149: AND Nvl(label_entity_type,0) = 1);
2150:

Line 3788: wms_label_formats wlf,

3784: mfglkup1.meaning bus_flow,
3785: mfglkup2.meaning label_type,
3786: wlrh.label_request_id label_request_id
3787: from wms_label_requests_hist wlrh,
3788: wms_label_formats wlf,
3789: wms_license_plate_numbers wlpn,
3790: mtl_system_items_kfv msik,
3791: mfg_lookups mfglkup1,
3792: mfg_lookups mfglkup2