APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_PARAMETERS

Line 74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp

70: select 1
71: into count_assigned
72: from dual
73: where exists (select 1
74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp
75: where moqd.organization_id = mp.organization_id
76: and mp.default_status_id is not null
77: and nvl(moqd.status_id, -9999) = p_status_id
78: and rownum = 1); -- Do we need to add rownum as the query is inside 'exists'.