APPS.INV_LABEL dependencies on WMS_LABEL_FORMATS

Line 209: FROM WMS_LABEL_FORMATS

205: -- If the format is passed in, the default
206: x_types_to_print(1).manual_format_id := p_format_id;
207: BEGIN
208: SELECT label_format_name INTO l_format_name
209: FROM WMS_LABEL_FORMATS
210: WHERE label_format_id = p_format_id;
211: EXCEPTION
212: WHEN others THEN
213: IF (l_debug = 1) THEN

Line 1170: INTO p_label_format_id,p_label_format FROM WMS_LABEL_FORMATS

1166: p_label_format_id OUT NOCOPY NUMBER
1167: ) IS
1168: BEGIN
1169: SELECT label_format_id,label_format_name
1170: INTO p_label_format_id,p_label_format FROM WMS_LABEL_FORMATS
1171: WHERE document_id = p_label_type_id
1172: AND default_format_flag = 'Y';
1173: IF SQL%NOTFOUND THEN
1174: p_label_format_id := null;

Line 1987: from wms_label_formats

1983: x_label_format_id := p_label_format_id;
1984: BEGIN
1985: select label_format_name
1986: into x_label_format
1987: from wms_label_formats
1988: where label_format_id = x_label_format_id;
1989: EXCEPTION
1990: when others then
1991: IF (l_debug = 1) THEN

Line 2085: AND exists (SELECT label_format_id FROM wms_label_formats

2081: */
2082:
2083: DELETE FROM wms_label_requests
2084: WHERE label_request_id = l_label_request_id
2085: AND exists (SELECT label_format_id FROM wms_label_formats
2086: WHERE label_format_id = x_label_format_id
2087: AND document_id = p_document_id
2088: AND Nvl(label_entity_type,0) = 1);
2089:

Line 3715: wms_label_formats wlf,

3711: mfglkup1.meaning bus_flow,
3712: mfglkup2.meaning label_type,
3713: wlrh.label_request_id label_request_id
3714: from wms_label_requests_hist wlrh,
3715: wms_label_formats wlf,
3716: wms_license_plate_numbers wlpn,
3717: mtl_system_items_kfv msik,
3718: mfg_lookups mfglkup1,
3719: mfg_lookups mfglkup2