APPS.INV_LABEL dependencies on MFG_LOOKUPS

Line 106: FROM wms_bflow_label_type wblt, mfg_lookups ml

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

Line 123: FROM wms_bflow_label_type wblt, mfg_lookups ml

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

Line 132: FROM wms_bflow_label_type wblt, mfg_lookups ml

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

Line 152: SELECT meaning FROM mfg_lookups

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

Line 3718: mfg_lookups mfglkup1,

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
3720: where wlrh.label_format_id = wlf.label_format_id (+)
3721: and wlrh.lpn_id = wlpn.lpn_id (+)
3722: and wlrh.inventory_item_id = msik.inventory_item_id (+)

Line 3719: mfg_lookups mfglkup2

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
3720: where wlrh.label_format_id = wlf.label_format_id (+)
3721: and wlrh.lpn_id = wlpn.lpn_id (+)
3722: and wlrh.inventory_item_id = msik.inventory_item_id (+)
3723: and wlrh.organization_id = msik.organization_id (+)