APPS.CSTPACIT dependencies on MFG_LOOKUPS

Line 166: FROM MFG_LOOKUPS ML,

162: l_stmt_num := 30;
163:
164: SELECT count(*)
165: INTO l_err_num
166: FROM MFG_LOOKUPS ML,
167: MTL_TXN_COST_DET_INTERFACE MTCDI
168: WHERE MTCDI.TRANSACTION_INTERFACE_ID = i_txn_interface_id
169: AND ML.LOOKUP_TYPE = 'CST_LEVEL'
170: AND ML.LOOKUP_CODE = NVL(MTCDI.LEVEL_TYPE, ML.LOOKUP_CODE)

Line 233: FROM MFG_LOOKUPS ML

229:
230: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI
231: SET LEVEL_TYPE =
232: (SELECT ML.LOOKUP_CODE
233: FROM MFG_LOOKUPS ML
234: WHERE ML.LOOKUP_TYPE = 'CST_LEVEL'
235: AND ML.MEANING = NVL(MTCDI.LEVEL_NAME, ML.MEANING))
236: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
237: AND LEVEL_TYPE IS NULL;