DBA Data[Home] [Help]

APPS.INV_MEANING_SEL dependencies on MTL_MATERIAL_STATUSES_VL

Line 292: from mtl_material_statuses_vl

288: begin
289: if (status_id_val is NOT NULL) then
290: select STATUS_CODE
291: into temp
292: from mtl_material_statuses_vl
293: where LOT_CONTROL =1
294: and ENABLED_FLAG = 1
295: and Status_Id = status_id_val;
296: return(temp);

Line 313: from mtl_material_statuses_vl

309: begin
310: if (status_id_val is NOT NULL) then
311: select STATUS_CODE
312: into temp
313: from mtl_material_statuses_vl
314: where SERIAL_CONTROL =1
315: and ENABLED_FLAG = 1
316: and Status_Id = status_id_val;
317: return(temp);