APPS.MSC_OWB_TREE dependencies on MFG_LOOKUPS

Line 161: To_char(lookup_code) -- mfg_lookups still has it as a number

157: p_state,
158: p_depth,
159: Meaning,
160: p_icon,
161: To_char(lookup_code) -- mfg_lookups still has it as a number
162: FROM mfg_lookups
163: WHERE LOOKUP_TYPE = 'MRP_NODE_TYPE'
164: AND LOOKUP_CODE = To_char(p_lookup_code);
165:

Line 162: FROM mfg_lookups

158: p_depth,
159: Meaning,
160: p_icon,
161: To_char(lookup_code) -- mfg_lookups still has it as a number
162: FROM mfg_lookups
163: WHERE LOOKUP_TYPE = 'MRP_NODE_TYPE'
164: AND LOOKUP_CODE = To_char(p_lookup_code);
165:
166: BEGIN

Line 257: FROM mfg_lookups

253: 117, Substr(meaning,1,24), -- Calendar Constraint
254: 119, Substr(meaning,1,40) -- Product Family Demand Spread
255: )
256: bulk collect INTO owb_tree.lookups
257: FROM mfg_lookups
258: WHERE
259: (lookup_type = 'MRP_SOURCE_TYPE' AND lookup_code IN ( 0, 1, 2, 3))
260: OR (lookup_type = 'MRP_ATP_FORM_TYPE' AND lookup_code IN
261: (10, 15, 30, 35, 40, 45, 50, 60, 70, 75, 80, 85, 90, 100, 111,110,112,113,114,115,116, 117,119))