DBA Data[Home] [Help]

APPS.BOM_BOMRWUIT_XMLP_PKG dependencies on MFG_LOOKUPS

Line 231: MFG_LOOKUPS ML

227: SELECT
228: ML.MEANING
229: INTO STATUS_NAME
230: FROM
231: MFG_LOOKUPS ML
232: WHERE ML.LOOKUP_CODE = 6
233: AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
234: END IF;
235: ELSE

Line 241: MFG_LOOKUPS ML

237: ML.MEANING
238: INTO STATUS_NAME
239: FROM
240: ENG_REVISED_ITEMS ERI,
241: MFG_LOOKUPS ML
242: WHERE ERI.REVISED_ITEM_SEQUENCE_ID = REVISED_ITEM_SEQUENCE_ID
243: AND ML.LOOKUP_CODE = ERI.STATUS_TYPE
244: AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
245: END IF;