APPS.INV_LABEL dependencies on MFG_LOOKUPS

Line 107: FROM wms_bflow_label_type wblt, mfg_lookups ml

103: wblt.level_type_code level_type_code
104: -- Bug 3836484. The following literal is not good for performance
105: -- Remove the following since it is only used for trace message
106: -- , decode(wblt.level_type_code,10001,'Site',10002,'Application',10003,'Responsibility',10004,'User') level_type_name
107: FROM wms_bflow_label_type wblt, mfg_lookups ml
108: WHERE wblt.business_flow_code = p_business_flow
109: AND wblt.level_value_id =
110: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID
111: ,10003,FND_GLOBAL.RESP_ID,10004, FND_GLOBAL.USER_ID)

Line 124: FROM wms_bflow_label_type wblt, mfg_lookups ml

120: Cursor sel_lab is
121: SELECT wblt.document_id label_type_id,
122: ml.meaning label_type_name,
123: wblt.level_type_code level_type_code
124: FROM wms_bflow_label_type wblt, mfg_lookups ml
125: WHERE wblt.business_flow_code = 22
126: AND nvl(wblt.enabled_flag, 'N') = 'Y'
127: AND ml.lookup_type = 'WMS_LABEL_TYPE'
128: AND ml.lookup_code = wblt.document_id

Line 133: FROM wms_bflow_label_type wblt, mfg_lookups ml

129: MINUS
130: SELECT wblt.document_id label_type_id,
131: ml.meaning label_type_name,
132: wblt.level_type_code level_type_code
133: FROM wms_bflow_label_type wblt, mfg_lookups ml
134: WHERE wblt.business_flow_code = 42
135: AND nvl(wblt.enabled_flag, 'N') = 'Y'
136: AND ml.lookup_type = 'WMS_LABEL_TYPE'
137: AND ml.lookup_code = wblt.document_id

Line 153: SELECT meaning FROM mfg_lookups

149: -- Added for Add Format/Printer project
150: l_format_name VARCHAR2(100);
151:
152: CURSOR c_type_name(p_label_type_id NUMBER) IS
153: SELECT meaning FROM mfg_lookups
154: WHERE lookup_type = 'WMS_LABEL_TYPE'
155: AND lookup_code = p_label_type_id;
156:
157: l_prev_level NUMBER := 0;

Line 3791: mfg_lookups mfglkup1,

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
3793: where wlrh.label_format_id = wlf.label_format_id (+)
3794: and wlrh.lpn_id = wlpn.lpn_id (+)
3795: and wlrh.inventory_item_id = msik.inventory_item_id (+)

Line 3792: mfg_lookups mfglkup2

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
3793: where wlrh.label_format_id = wlf.label_format_id (+)
3794: and wlrh.lpn_id = wlpn.lpn_id (+)
3795: and wlrh.inventory_item_id = msik.inventory_item_id (+)
3796: and wlrh.organization_id = msik.organization_id (+)