DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on MFG_LOOKUPS

Line 6007: FROM MFG_LOOKUPS ML

6003: BEGIN
6004: IF (p_reason_code_type = 1) THEN
6005: SELECT ML.meaning
6006: INTO x_reason_code
6007: FROM MFG_LOOKUPS ML
6008: WHERE ML.lookup_type = 'BOM_SCRAP_CODES'
6009: AND ML.lookup_code = p_reason_code_num;
6010: ELSE
6011: SELECT ML.meaning

Line 6013: FROM MFG_LOOKUPS ML

6009: AND ML.lookup_code = p_reason_code_num;
6010: ELSE
6011: SELECT ML.meaning
6012: INTO x_reason_code
6013: FROM MFG_LOOKUPS ML
6014: WHERE ML.lookup_type = 'BOM_BONUS_CODES'
6015: AND ML.lookup_code = p_reason_code_num;
6016: END IF;
6017: