APPS.EAM_OPERATIONS_JSP dependencies on MFG_LOOKUPS

Line 348: from mfg_lookups ml -- Fix for Bug 3509465

344: l_reconciliation_code := null;
345: if( p_reconciliation_code is not null) then
346: select ml.lookup_code
347: into l_reconciliation_code
348: from mfg_lookups ml -- Fix for Bug 3509465
349: where ml.lookup_type = 'WIP_EAM_RECONCILIATION_CODE'
350: and ml.meaning = p_reconciliation_code;
351: end if;
352: EXCEPTION WHEN NO_DATA_FOUND THEN -- Bug 3133704,changed OTHERS to NO_DATA_FOUND

Line 2326: from mfg_lookups

2322: TYPE CUR_TYP is ref cursor;
2323:
2324: CURSOR c_supply_cur IS --rhshriva
2325: select meaning
2326: from mfg_lookups
2327: where lookup_type = g_supply_type
2328: and (lookup_code = 1 or lookup_code = 4) ;
2329:
2330: CURSOR c_subinv_cur IS --rhshriva

Line 2643: from mfg_lookups

2639: -- Get Supply TYpe
2640: if(p_supply is not null) then
2641: select lookup_code
2642: into l_supply
2643: from mfg_lookups
2644: where lookup_type = g_supply_type
2645: and meaning = p_supply;
2646: else
2647: l_supply := p_supply_code;

Line 3272: FROM MFG_LOOKUPS

3268: BEGIN
3269:
3270: SELECT lookup_code
3271: INTO l_lookup_code
3272: FROM MFG_LOOKUPS
3273: WHERE lookup_type = g_shutdown_type
3274: AND meaning = p_meaning ;
3275:
3276: x_return_status := l_return_status;