DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on MFG_LOOKUPS

Line 626: FROM MFG_Lookups

622: RETURN VARCHAR2 IS
623:
624: CURSOR Ml_Cur IS
625: SELECT Meaning
626: FROM MFG_Lookups
627: WHERE Lookup_Code = P_Lookup_Code
628: AND Lookup_Type = P_Lookup_Type;
629:
630: CURSOR Wl_Cur Is

Line 2325: FROM mfg_lookups ml, mst_exception_details med

2321: l_message := fnd_message.get;
2322: END IF;
2323: ELSE
2324: SELECT ml.meaning INTO l_message
2325: FROM mfg_lookups ml, mst_exception_details med
2326: WHERE med.exception_type = ml.lookup_code
2327: AND ml.lookup_type = 'MST_EXCEPTION_TYPE'
2328: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
2329: END IF;

Line 4399: FROM mfg_lookups

4395: l_lookup_code := 1;
4396: End If;
4397: SELECT meaning
4398: INTO l_str
4399: FROM mfg_lookups
4400: WHERE lookup_type = 'MST_TRIP_LOADING_STATUS'
4401: AND lookup_code = l_lookup_code;
4402:
4403: RETURN l_str;

Line 5625: FROM mfg_lookups

5621: l_message := fnd_message.get;
5622: ELSE
5623: SELECT meaning
5624: INTO l_message
5625: FROM mfg_lookups
5626: WHERE lookup_type = 'MST_EXCEPTION_TYPE'
5627: AND lookup_code = P_EXCEPTION_TYPE;
5628: END IF;
5629: return l_message;